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.
Solved! Go to Solution.