Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to replace Windows linefeed with Linux linefeed

Solved Go to solution

How to replace Windows linefeed with Linux linefeed

Explorer

How can I use ReplaceText processor to function like dos2unix command, i.e. change \r\n to \n

My file comes in with ^M at the end of each line

In the ReplaceText process, I have a Search Value of \r\n

That is correctly finding the Windows linefeeds

However, for Replacement value, I have tried \n also $1\n

 

They each put the character n where I want the line feed to be.

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: How to replace Windows linefeed with Linux linefeed

Master Guru

@sfishman 

In the "Replacement value" configuration property just hold the <shift> key and hit enter instead of using "\n".
Here is example of what you would see:
Screen Shot 2020-03-05 at 1.50.51 PM.png

This will create the line return you are looking for.

 

Hope this helps,
Matt

View solution in original post

1 REPLY 1
Highlighted

Re: How to replace Windows linefeed with Linux linefeed

Master Guru

@sfishman 

In the "Replacement value" configuration property just hold the <shift> key and hit enter instead of using "\n".
Here is example of what you would see:
Screen Shot 2020-03-05 at 1.50.51 PM.png

This will create the line return you are looking for.

 

Hope this helps,
Matt

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here