0

When we are trying to load csv file using datastage into HANA, one of our columns value contains carriage returns in the middle of the text, due to that datastage is not able to read that record.

For Ex. We have a text like this:

disjointed as well.  ^M<br>After the CT surgery

Our expected output:(Get rid of '^M' that occurs before <br>)

disjointed as well. <br>After the CT surgery

We have tried the below options, but none of them are working. Please help.

sed 's/\n<br>/<br>/g' file.csv > filenew.csv
cat -v file.csv | tr -d '^M\n<br>

Thanks

roaima
  • 107,089
  • 14
  • 139
  • 261
JothiD
  • 1
  • 1
  • The answers to the duplicate should all work for you. If they don't, update your question showing what happens when you try them and leave a comment mentioning me (`@terdon`) to reopen. – terdon Jan 27 '23 at 18:32

0 Answers0