tMap Expression - Replace Chr(10), Chr(13), Chr(9) With Spaces

[the_etl_guy]

Hello everyone,

I had to replace hidden characters in  field sourced from MSSQL, though I've already found a working solution I'm curious about something in it.

Issue: "\n" in data ending the line in the target file.

Solution: row1.field.replaceAll("\r\n"," ").replaceAll("\n"," ")

For me, the above solution as well as just row1.field.replaceAll("\n"," ") has worked well.

I just want to know how the two replaceAll placed one after another actually work.

[manodwhb · Accepted solution]

as per the solution, first row1.field.replaceAll("\r\n"," ") will exectue and to the oput of row1.field.replaceAll("\r\n"," ")  is passed to replaceAll("\n"," ") will replace \n to empty string.