Skip to Content
0
Former Member
Dec 12, 2006 at 07:02 AM

Field Segregartion

22 Views

Hi ,

I have a field of type string in my Source strucutre of type String which consists multiple values seperated by SPACE,

Now in mapping i have to segregate these values into individual fields could u tellme how is it possible,

Sample data:

========

Field: 200006 2000000018 2100000026548

these have to be mapped to a field "targetField" (0-unbounded) in target.

so my target would be

targetfield1 = 200006

targetfield2 = 2000000018

targetfield3 = 2100000026548

any inputs.....!!! any UDF i can use....? i am not good at java..though....!!!