Help me to process a file

Anonymous — Sun, 22 Mar 2020 12:04:18 GMT

Hello,

I'm trying to process a file with splitRow etc.. but I'm doing something wrong..

Input file:

12001A1.10 1.20 $ 2.20

Output file:

columnA colB colC colD colE colF

12 001A 1.10 1.20 0 2.20

I want to save first input field(12001A1.10) in 3 different columns but I don't know if there is a split component by length so I could trim 2 chars then 4 chars and finally 3 more.

Another issue is how to convert/change special chars like "$" from my input into a value 0 (with normalize is possible to do?)

Any idea how can I do all of this, can you help me?

Thanks in advance

Re: Help me to process a file

jeoste — Sun, 22 Mar 2020 13:53:26 GMT

Hello,

Can you provide some screenshot of your job ?

You're using tSplitRow, but in your case I'll better use a tMap

I've created a .csv file with your input data, I'm making transformation inside the tMap component to match the output you wanted. Here's the following screenshot, is that what you wanted ?

Make sure to create "intermediary variable" inside the tMap to put your transformation code (with substring and condition) for good practices and readability.

topic Re: Help me to process a file in Talend Studio

Help me to process a file

Re: Help me to process a file