Solved
Redshift bulk load
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.
so … this gave me the solution
$content.contains(‘\r\n’)?
($content.replaceAll(‘\r\n’,‘\n’) && $content.replaceAll(‘\n’,‘’) ) : $content.replaceAll(‘\n’,‘\n’)
