so … this gave me the solution
$content.contains(‘\r\n’)?
($content.replaceAll(‘\r\n’,‘\n’) && $content.replaceAll(‘\n’,‘’) ) : $content.replaceAll(‘\n’,‘\n’)
Well, thanks for coming back @mbowen … my target is redshift … I will be getting the file from the win / Unix system and blow will be its behaviour
Win
Unix
I am trying to read the csv file irrespective of the system
i am using the blow code for replacing the \r\n – ($content.replaceAll(‘\r\n’,‘\n’) && $content.replaceAll(‘\n’,‘’) )
Problem - when I pass the Unix file it replaces the \n to ‘’ and makes the csv invalid.
how to accommodate them both
so … this gave me the solution
$content.contains(‘\r\n’)?
($content.replaceAll(‘\r\n’,‘\n’) && $content.replaceAll(‘\n’,‘’) ) : $content.replaceAll(‘\n’,‘\n’)
