replacing windows new line characters with JAVA
807569Jul 21 2006 — edited Jul 21 2006I am importing a file into the database... the file is written by a client using windows, and it is a text file.
When there is a windows new line character at the end of the line (^M), it is getting saved to the database as part of the string value.
When we parse this data to run a report, the (^M) are being written back out to the file and causing the fields and data not to line up.
We want to REPLACE the ^M with some other character (whatever it doesn't matter)... how can java do that???
We tried replacing '/n' with '###' and it will show the ###, but the line still breaks.
TIA,
Tonya