[resolved] Tmap from Sql to tfilidelimited

[Anonymous]

Hello.
The problem is that the csv file creates new line if ascii_char(13) and ascii_char(10) is found on adress column
I want to replace all ascii_char(13) and ascii_char(10) from that string.
row1.ADRESS.replaceAll(" "," "); How can I express Ascii Char here?
File is ISO-8859-15.
Thanks in advance.

[ytuzet]

You forgot, it happens 😜

[Anonymous]

Here goes the screen shot

[ytuzet]

can you unplugged the tmap and place a tlogrow instead with a screenshot of the result ?

[ytuzet]

can you unplugged the tmap and place a tlogrow instead with a screenshot of the result ?

[Anonymous]

Here goes

[ytuzet · Accepted solution]

re-plug your tMap and test with row1.ADDRESS.replaceAll("\r\n"," ").replaceAll("\n"," ");

[Anonymous]

Perfect.
Thank YOU!
Have a nice Xmax!

[ytuzet]

Thx.
That was your present 😜

[janhess]

re-plug your tMap and test with row1.ADDRESS.replaceAll("\r\n"," ").replaceAll("\n"," ");

Probably best to do row1.ADDRESS.replaceAll("\r"," ").replaceAll("\n"," "). That way you catch any lone carriage returns.

[Anonymous]

Hi janhess,

re-plug your tMap and test with row1.ADDRESS.replaceAll("\r\n"," ").replaceAll("\n"," ");

Probably best to do row1.ADDRESS.replaceAll("\r"," ").replaceAll("\n"," "). That way you catch any lone carriage returns.
I have similar problem and tried with your solution. It's almost work but there are two blank spaces everywhere. I've tried with replaceAll(" +",""), but no luck.
Could you help me on this?
Thanks in advance.