06-28-2021 09:20 PM
Hi team,
Looking for a suggestion/enhancement to achieve the below senario. when i read a csv file (it might have \n\r (windows) & \n(unix) ). Who to fix this …
Today I read the file and when I do the bulk load using redshift bulk load snap and the data gets loaded with the \n\r . How can I escape these characters?
When i look at the properties of the snap , i could see the below. but it’s not working.
Solved! Go to Solution.
07-01-2021 02:38 AM
so … this gave me the solution
$content.contains(‘\r\n’)?
($content.replaceAll(‘\r\n’,‘\n’) && $content.replaceAll(‘\n’,‘’) ) : $content.replaceAll(‘\n’,‘\n’)
07-01-2021 06:03 AM
@koryknick Thanks for the suggestion … !! keeping this in y note…!