Solved: [resolved] how to replace in a field when the row ... - Qlik Community

Anonymous · ‎2011-11-17

Hello,
I have a delimited file (field separator "\t", row separator "\n") looking like :
1 \tblue \tapple \n
2 \tred \n
\tpeer \n
tFileInputDelimited will fail on line 2 ...
So my idea was to replace the row separator so I will be able to replace \n by "" in the field. Bbut I didn't found a component for that

regards

Anonymous · ‎2011-11-18

Well this format is really big shit

. Well, still there is solution of course 🙂 If you know the schema, you can go trough the whole file and detect \t char which seems to be used as column delimiter and repair the file first before it can be read by Talend.
Send me the file to archenroot@gmail.com, I can write small code which will standardize the file.
Ladislav

View solution in original post

Anonymous · ‎2011-11-17

You want to replace the \n of the second line, the one in the middle?

Anonymous · ‎2011-11-17

You want to replace the \n of the second line, the one in the middle?

I have modified line 2 in my post to reflect what's real

Anonymous · ‎2011-11-17

So actually it's not really a tFileDelimited. Do you have only 2 columns?

Anonymous · ‎2011-11-17

no the file have 15 columns

Anonymous · ‎2011-11-17

But I don't really get it. Could you post a part of what you have and what you want?

Anonymous · ‎2011-11-17

in my example the expected result will be :
1\tblue\tapple\n
2\tred\tpeer\n

Anonymous · ‎2011-11-17

But why the first line has the right format?

Anonymous · ‎2011-11-17

Because it has been entered correctly in the frontend application I guess
In line 2 the operator hit the return key by accident

Anonymous · ‎2011-11-17

So sometimes you want to replace the \n, sometimes not?

[resolved] how to replace in a field when the row separator is also

Other

Talend Data Integration