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
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

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