[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.

[Anonymous]

Hi
Do the transform on tMap, type in the following expression in the expression field of column of output table.
row1.ADRESS.replaceAll("\\your Ascii char ","new string")
Best regards
Shong

[Anonymous]

Hello Shong.
Thanks for your reply.
Not working yet. I am using the folloing expression on the tmap: row1.address.replaceAll("\\ASCII_CHAR(13)","-");
I also try: row1.address.replaceAll("\\CR","-"); for carriage return, but not supported.
Thanks again

[ytuzet]

If your purpose is to replace all carriage return test:
row1.ADRESS.replaceAll("\r"," ");

[janhess]

you'll need \n for new line as well

[Anonymous]

Hello and many thanks for your reply.
Not working: on tmap: row1.ADDRESS.replaceAll("\\r\\n"," ");
result:
Name;address;etc
Ruben;Street
name;etc
I want:
Name;address;etc
Ruben;Street name;etc
Thanks again

[ytuzet]

try row1.ADDRESS.replaceAll("\r\n"," "); instead

[Anonymous]

Hello and thanks for your reply.
Yes, that almost worked.
For this:
Name;address;etc
Ruben;Street
name;etc
The result is:
Name;address;etc
Ruben;Street name;etc
And now it's ok! Thanks.
For:
Name;address;etc
Ruben;Street
name
and number;etc
Not ok. And I don't understand beacause we are using a "replaceall"
For more than 1 Carriage return it's not working.
Sorry, I am new In Talend.
Thanks again

[ytuzet]

Can you post a screenshot with component properties of the component behind row1?
the replaceAll will not work if you put "\n" as row separator because it will do a replaceAll for each line

[Anonymous]

Yes,
That's what i was thinking