Spliiting a single row into multiple row

[goutam]

Hi folks,

I have the following requirement.
I have two input columns. ASSET_ID and DESC. Length of DESC field is not fixed. Output columns are same but with a fixed length of DESC field.

input row 100, WEBER MARKING SYSTEMS INC
output row should be
100, WEBER MARK
100, KING SYSTE
100, MS INC

i.e splitting the DESC field with a length of 10.
Can it be accomplished this thru transformer? If yes how?
if no, please give any ideas.

[girija]

What will be the max length of your input DESC?

[goutam]

What will be the max length of your input DESC?

i am reading DESC column value with longvarchar datatype.Precision is 999999.

[mystuff]

you have to use a function and loop around it.

[goutam]

you have to use a function and loop around it.

what kind of function??? can you please be more specific on your idea?

I was trying to solve it using buildop stage. But got stuck in string manipulation. I was using string conctenation function available in C. but there was some compilation problem.

Can anybody tell me what all function are available under APT_string header file.?

[goutam]

you have to use a function and loop around it.

Thanks to all of you. I resoved the problem using build stage.

[ray.wurlod]

Would you care (a) to mark the thread as Resolved, and (b) to share your solution?

[budde43]

Hi

Can you give the solution for your problem .How did you solved it,I think it is usefull for me.

Thanks