Reading multiple lines as single

braindrain · #1 (**permalink**) 10-17-2006

Hi,
Is it possible to read every 2 lines as single record, I have a file like below,

Code:

~CZK      ~TSCHECHISCHE KRONE            ~TSCHECH. REPUBLIK
           Dec  1 2005 12:00AM~         10.840000~
~DKK      ~DAENISCHE KRONE               ~DAENEMARK
           Dec  2 2005 12:00AM~          17.451000~
~DZD      ~ALGERISCHER DINAR             ~ALGERIEN
           Dec  3 2005 12:00AM~         16.100000~
~EEK      ~ESTNISCHE KRONE               ~ESTLAND

and I want to read them as single record separated by Tilda's.

~CZ~TSCHECHISCHE KRONE~TSCHECH. REPUBLIK~Dec 1 200512:00AM ~10.840000~

i.e something the does the opposite of fold.

Is this possible to do in awk or ????

Thanks a lot

anbu23 · #2 (**permalink**) 10-17-2006

Code:

paste -s -d"\t\n" file

Above command will convert the records across two lines into singe line.

petebear · #3 (**permalink**) 10-17-2006

I'm sure someone will be able to get your desired output into a single field, but here it is in two:

Code:

awk 'BEGIN { RS = "/^~/" ; FS = "\n" ; OFS = "~" } {gsub(/ +/, "") ; print $1,$2 }'

ghostdog74 · #4 (**permalink**) 10-17-2006

If you have Python:

Code:

#!/usr/bin/python
data = open("file.txt").readlines()
for i in range(len(data)):
 	try:
 		if data[i].startswith("~"):
 			data[i] = data[i].strip() #strip new lines
 			s = data[i] + "~"  + data[i+1] #concat 2 lines
 			print s.replace(" ","").strip() #replace all spaces and strip new lines
 	except: 
                        print data[i].replace(" ","") + "~"

output:

Code:

~CZK~TSCHECHISCHEKRONE~TSCHECH.REPUBLIK~Dec1200512:00AM~10.840000~
~DKK~DAENISCHEKRONE~DAENEMARK~Dec2200512:00AM~17.451000~
~DZD~ALGERISCHERDINAR~ALGERIEN~Dec3200512:00AM~16.100000~
~EEK~ESTNISCHEKRONE~ESTLAND~

vgersh99 · #5 (**permalink**) 10-17-2006

Code:

paste -d'~' - - < myFile.txt
OR
nawk -F'~' 'ORS=(FNR%2)?FS:RS' myFile.txt

anbu23 · #6 (**permalink**) 10-17-2006

Code:

paste -d'~' - - < myFile.txt

I think this will introduce an extra ~ in the output

vgersh99 · #7 (**permalink**) 10-17-2006

Quote:

Originally Posted by anbu23

Code:

paste -d'~' - - < myFile.txt

I think this will introduce an extra ~ in the output

... not that I can see

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
replacing multiple lines with single line	siba.s.nayak	Shell Programming and Scripting	3	05-28-2008 02:43 AM
Reading Multiple Variables From a Single Line in Shell	Drek	Shell Programming and Scripting	14	12-21-2006 11:20 AM
reading a single line	rochitsharma	Shell Programming and Scripting	2	02-27-2006 01:06 AM
Splitting a single line into multiple lines	thanuman	Shell Programming and Scripting	4	02-23-2005 04:56 AM
reading a single character in C	alodha	High Level Programming	3	01-28-2005 06:22 AM

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