Talend community forum / parse single line into multiple

pnbalaji · 2012-02-17 14:53:16

Hi,

I am using talend integration suite 4.2 and I have a new requirement.

I have a positional file which contains data like this:

000123 KL
000234 MNO
000768 CKNYPQ

I would like read the above file and generate an output file like the one given below.

000123 K
000123 L
000234 M
000234 N
000234 O
000768 C
000768 K
000768 N
000768 Y
000768 P
000768 Q

Is there a talend component that can help to acheive this? I would consider the tjava, tjavarow as the last option, if nothing works out.

Thanks,
Balaji.

y2k_k2a · 2012-02-17 15:02:35

Hi Balaji,

I think u can use tNormalize component.. In the Basic setting of the component you can use your second column as the column to normalize.. and in the Item separator column you can have ""(blank).. I guess this will work.. Can give a try.

Thanks,
Yuraj

Balaji Pooruli · 2012-02-17 16:31:13

y2k_k2a wrote:
Hi Balaji,

I think u can use tNormalize component.. In the Basic setting of the component you can use your second column as the column to normalize.. and in the Item separator column you can have ""(blank).. I guess this will work.. Can give a try.

Thanks,
Yuraj

Balaji Pooruli · 2012-02-17 16:31:52

y2k_k2a wrote:
Hi Balaji,

I think u can use tNormalize component.. In the Basic setting of the component you can use your second column as the column to normalize.. and in the Item separator column you can have ""(blank).. I guess this will work.. Can give a try.

Thanks,
Yuraj

Yuraj,

Thanks for your help. tNormalize component works perfectly in my case.

Thank you very much again.

Thanks,
Balaji.

Announcement

Unanswered posts

#1 2012-02-17 14:53:16

parse single line into multiple

#2 2012-02-17 15:02:35

Re: parse single line into multiple

#3 2012-02-17 16:31:13

Re: parse single line into multiple

y2k_k2a wrote:

#4 2012-02-17 16:31:52

Re: parse single line into multiple

y2k_k2a wrote:

Board footer