Help me to process a file

[Anonymous]

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

[jeoste]

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.