Shell Programming and Scripting

Try this:

Code:

awk '/^PRODUCT/ {getline; printf("%s%s", $1, NR%2? FS:RS}
/^SALE SERIAL/ {getline; printf("%s%s", $1, NR%2? FS:RS}
' Sales.txt > Sales_Filtered.txt

Regards

Hi Franklin52,

Many thanks for your answer.

I,ve tryed your suggestion

Code:

 
awk '/^PRODUCT/ {getline; printf("%s%s", $1, NR%2? FS:RS)} 
/^SALE SERIAL/ {getline; printf("%s%s", $1, NR%2? FS:RS)}
' Sales.txt

and a little bit shorter variant

Code:

awk '/^PRODUCT/||/^SALE SERIAL/ {getline; printf("%s%s", $1, NR%2? FS:RS)}' Sales.txt

but the result is the same, as follow:

79833269999
7-4324990101 79806743123 7-4324995448

and not like I´d like, as follow:

79833269999 7-4324990101
79806743123 7-4324995448

What it´s missing?

I´m beginning to understand awk´s logic, thanks for your help.

Best regards

Sorry, I looked over something, try this:

Code:

awk '/^PRODUCT/ {getline; printf("%s ", $1)} 
/^SALE SERIAL/ {getline; printf("%s\n", $1)}
' Sales.txt

Regards

Hi, I'm newby to scripting. Thanks in advance for your input.. I have a flat file like below:
"Mon Jan 7 11:32:25 EST 2008",
291
"Mon Jan 7 12:01:00 EST 2008",
291
"Mon Jan 7 18:01:00 EST 2008",
318
"Tue Jan 8 00:01:00 EST 2008",
357
"Tue Jan 8 06:01:00 EST 2008",
352
"Tue Jan 8 12:01:00 EST 2008",
388
"Tue Jan 8 18:01:00 EST 2008",
387
"Wed Jan 9 00:01:00 EST 2008",
387
"Wed Jan 9 06:01:00 EST 2008",
406
"Wed Jan 9 12:01:00 EST 2008",
403
"Wed Jan 9 18:01:00 EST 2008",
406
"Thu Jan 10 00:01:00 EST 2008",
414
"Thu Jan 10 06:01:00 EST 2008",

I need to merge line 1 and 2, then 3 and 4, to make it become:
"Mon Jan 7 11:32:25 EST 2008", 291
"Mon Jan 7 12:01:00 EST 2008",291
"Mon Jan 7 18:01:00 EST 2008",318
"Tue Jan 8 00:01:00 EST 2008",357
"Tue Jan 8 06:01:00 EST 2008",352
"Tue Jan 8 12:01:00 EST 2008",388
"Tue Jan 8 18:01:00 EST 2008",387
"Wed Jan 9 00:01:00 EST 2008",387
"Wed Jan 9 06:01:00 EST 2008",406
"Wed Jan 9 12:01:00 EST 2008",403
"Wed Jan 9 18:01:00 EST 2008",406
"Thu Jan 10 00:01:00 EST 2008",414
"Thu Jan 10 06:01:00 EST 2008",.......

Any quick way to do it?? Thanks!

Perfect man!!!

I understand almost all code:

getline= Get data from line below
$1=Get data from column 1

but only one more thing, what it´s means in your code

"%s "=
"%s\n"=

I dont get the meaning.

Thanks in advance

Code:

"%s " = print a space after the line
"%s\n"= print a newline after the line

Regards

Many thanks Franklin52, I´ve learned several things through this question.
Thanks for your contribution and take some of your time to share what you know.

Hi flyingfish,

Part of my problem was exactly you´re asking.

I got a sample code over there that does what you want; I mean, put odd lines in column 1
and even lines in column 2. I´m not completely sure how it works, but it works

Try with:
(To print in display the processed data)

Code:

  awk 'ORS = NR%2 ? " " : "\n"' Source.txt

or

(To send the processed data from Source.txt to the file Destination.txt)

Code:

awk 'ORS = NR%2 ? " " : "\n"' Source.txt > Destination.txt

I hope it helps,

Really thanks to all,

Best regards