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.
Spliiting a single row into multiple row
Moderators: chulett, rschirm, roy
Spliiting a single row into multiple row
Goutam Sahoo
what kind of function??? can you please be more specific on your idea?mystuff wrote:you have to use a function and loop around it.
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 Sahoo
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Tell the solution
Hi
Can you give the solution for your problem .How did you solved it,I think it is usefull for me.
Thanks
Can you give the solution for your problem .How did you solved it,I think it is usefull for me.
Thanks