Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

removing spaces after carriage return

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers removing spaces after carriage return
# 1  
Old 09-30-2008
removing spaces after carriage return
I have a file that I have to place a carriage return at the end of each line for another program to process it. I also need to remove all spaces after the carriage return. I searched the forums and found this command, but it removes all spaces:
Code:
sed "s/[\r ]*//g" ic527.txt > ic527.new

The records in the file are written out like so:
Code:
 MSH|^~\&|IC527|         Lawson|sr_islawson|DBS|200809300822||M
FN^MUP|200809300822012164|P|2.1|012164|\r







                                                         CD1||R01176^BHI WITH VA
NCOMYCIN|R01176^BHI WITH VANCOMYCIN USE ITEM#110400|BHI WITH VANCOMYCINUSE ITEM#\r



                            CD2||R01176^BHI WITH VANCOMYCIN|R01176^BHI WITH VANC\r

I want to remove all spaces after the "\r" and retain the "\r".
# 2  
Old 09-30-2008
Try this:

Code:
sed 's/\(.*\\r\).*/\1/' ic527.txt > ic527.new

Regards
# 3  
Old 09-30-2008
Hi Franklin52,
I tried your code and it did not work. It is not removing the spaces after the carriage return. Thank you for the quick response.
# 4  
Old 09-30-2008
Your right, my mistake, try this one, to get the ^M character you must type <CTRL>-v <CTRL>-m not just a ^ and a M:

Code:
sed 's/\(.*^M\).*/\1/' ic527.txt > ic527.new

Regards
# 5  
Old 09-30-2008
Hi Franklin52,
I tried your suggestion and still no luck. This is what I typed in:
Code:
sed 's/\(.*<CTRL>-v<CTRL>-m\).*/\1/' ic527.txt > ic527.new

# 6  
Old 10-01-2008
put file1,file2 but other syntex use as it is:

tr -d '\015' <file1> file2
# 7  
Old 10-01-2008
Quote:
Originally Posted by jyoung
Hi Franklin52,
I tried your suggestion and still no luck. This is what I typed in:
Code:
sed 's/\(.*<CTRL>-v<CTRL>-m\).*/\1/' ic527.txt > ic527.new

In the command you've type <CTRL>-v and <CTRL>-m literally, to get the ^M character you must press those keys successively.

Regards
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Substitute \n with carriage return

Hello all, I've a flat file in the following format: AB\001\CDED\001\ABC\001\nEG\001\HIJF\001\EFG\001\nHI\003\HIUL\003\HIJ\003 And I want to substitute \n with the carriage return. Any help is appreciated! Regards, - Seth (8 Replies)
Discussion started by: sethmj
8 Replies

2. Shell Programming and Scripting

Removing carriage return/line feeds on multiple lines

I would like to remove carriage returns/line feeds in a text file, but in a specific cadence: Read first line (Header Line 1), remove cr/lf at the end (replace it with a space ideally); Read the next line (Line of Text 2), leave the cr/lf intact; Read the next line, remove the cr/lf; Read... (14 Replies)
Discussion started by: tomr2012
14 Replies

3. Shell Programming and Scripting

Removing Carriage return in a file after particular string

Hi All, I want to remove carriage return in a file using some unix command without writing a script my file is as follows abc1 abc2 abc3 abc4 abc5 bac6 abc1 abc2 abc3 abc4 abc5 bac6 I want the output as follows: abc1 abc2 abc3 abc4 abc5 bac6 abc1 abc2 abc3 abc4 abc5 bac6 , Please... (7 Replies)
Discussion started by: manish8484
7 Replies

4. Shell Programming and Scripting

Removing Carriage return and merging data

Hi, I am trying to remove the carriage return on the record which starts with ADD, MODIFY, or DELETE keyword as the first value in the record. If the records does not start with anyone of these keywords then combine the records with the previous record (line). Input File name xyz.txt... (6 Replies)
Discussion started by: naveed
6 Replies

5. UNIX for Dummies Questions & Answers

carriage return and linefeed

hi can anyone please tell me the difference between carriage return, linefeed and newline ? (2 Replies)
Discussion started by: streetfi8er
2 Replies

6. UNIX for Advanced & Expert Users

Issue with Removing Carriage Return (^M) in delimited file

Hi - I tried to remove ^M in a delimited file using "tr -d "\r" and "sed 's/^M//g'", but it does not work quite well. While the ^M is removed, the format of the record is still cut in half, like a,b, c c,d,e The delimited file is generated using sh script by outputing a SQL query result to... (7 Replies)
Discussion started by: sirahc
7 Replies

7. Shell Programming and Scripting

Removing Carriage Return and or line feed from a file

Hello I'm trying to write a shell script which can remove a carriage return and/or line feed from a file, so the resulting file all ends up on one line. So, I begin with a file like this text in file!<CR> line two!<CR> line three!<CR> END!<CR> And I want to end up with a file... (1 Reply)
Discussion started by: tbone231
1 Replies

8. Shell Programming and Scripting

sed removing carriage return and newline

Hi, I'm not very familiar with unix shell. I want to replace the combination of two carriage returns and one newline with one carriage return and one newline. I think the best way to do this is to use sed. I tried something like this: sed -e "s#\#\#g" file.txt but it doesn't work. Thanx... (2 Replies)
Discussion started by: mored
2 Replies

9. Shell Programming and Scripting

Removing Carriage return to create one record

I have a file with multiple records in it and want to create a single record by removing all the carriage returns, is there a sed command or another command that will easily allow this to happen. current layout 813209A 813273C 812272B expected result 813209A813273C812272B previously I... (3 Replies)
Discussion started by: r1500
3 Replies

10. UNIX for Dummies Questions & Answers

Removing carriage return characters from file

Hello there, I need to remove carriage return characters (\n and \r) from any input file specified. This is what I am doing right now: - dumping the file to octal format using the command 'od -c file_name - removing and \s and \n characters using sed commands What I need to do now is... (3 Replies)
Discussion started by: b1saini
3 Replies
Login or Register to Ask a Question