This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Redshift bulk load

Go to solution
makeshwar
New Contributor II

‎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.
image

0 Kudos
Reply
1 ACCEPTED SOLUTION

Go to solution
makeshwar
New Contributor II
In response to makeshwar

‎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’)

View solution in original post

Reply
5 REPLIES 5

Go to solution
makeshwar
New Contributor II
In response to koryknick

‎07-01-2021 06:03 AM

@koryknick Thanks for the suggestion … !! keeping this in y note…!

0 Kudos
Reply