To remove carriage return between the line

shash · #1 (**permalink**) 07-30-2007

Hi,

I have a situation where I need to remove the carriage return between the lines.

For.eg.

The input file:

1,ad,"adc
sdfd",edf
2,asd,"def
fde",asd

The output file should be

1,ad,adc sdfd,edf
2,asd,def fde,asd

Thanks
Shash

awk · #2 (**permalink**) 07-30-2007

awk '/^[1-9]/{print ""}
{gsub("\"", "")
printf"%s,", $0}
END{print ""}' <<EOF | sed 's/,$//'
1,ad,"adc
sdfd",edf
2,asd,"def
fde",asd
EOF

1,ad,adc,sdfd,edf
2,asd,def,fde,asd

Shell_Life · #3 (**permalink**) 07-30-2007

If 'awk' is not required:

Code:

while read mLine1
do
  read mLine2
  echo ${mLine1}${mLine2}
done < input_file

shash · #4 (**permalink**) 07-31-2007

Thanks awk. It works and I have changed it to replace a space instead of comma in place of the carriage return.

Thanks for the reply Shell_Life, but some lines will not have the carriage return.

shash · #5 (**permalink**) 07-31-2007

I am having problems if I use the files as my input.

The code I'm using is as follows:

awk '/^[1-9]/{print ""}
{gsub("\"", "")
printf"%s ", $0}
END{print ""}' book2.csv | sed 's/,$//' > book3.csv

book2.csv contains data as follows:

1,ad,"adc
sdfd",edf
2,asd,"def
fde",asd
3,def,fde

The output I'm getting as book3.csv

,ad,adc sdfd,edf
,asd,def fde,asd
3,def,fde

1 & 2 values are missing.

Thanks
Shashi

shash · #6 (**permalink**) 07-31-2007

Well Shell_life code do works.. Thanks

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to insert carriage return before line feed?	huey ing	Shell Programming and Scripting	2	08-05-2005 01:22 PM
Removing Carriage Return and or line feed from a file	tbone231	Shell Programming and Scripting	1	02-18-2005 04:37 PM
Remove a carriage return at end of variable	flagship99	UNIX for Dummies Questions & Answers	5	11-17-2004 06:39 PM
carriage return/line feeds	pitstop	Shell Programming and Scripting	4	11-24-2003 03:47 PM
Regex to pick up name from the following including carriage return at end of the line	Shakey21	Shell Programming and Scripting	3	07-18-2002 08:27 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by