I have an issue where I am getting a flatfile source with a huge number of records with PIPE delimiters and one of the fields is getting carriage returns (in multiple lines) and starts with a newline (\n). So how can I remove the \n character in the file?Example:-000123456|1654321|6/12/2002 8:49:20 AM|tt Cynthia L Eggleston E456585 remove move the funds adv account in fcle flagged on 710091 pmt due 12-16- 15|Can anyone suggest how to proceed?
Getting Source as Flatfile and to remove the Carriage returns and \n ...special charaters?
text processing