[SOLVED] How to split single column string into two columns

Colorinb · 10-07-2011, 06:40 PM

Hi, I'm new to Linux, after I grep "Size" and "Price" from another file, I have a single column string with following format:

Size: S
Size: M
Size: L
Size: XL
Price: 1
Price: 2
Price: 3
Price: 4
...

I want to split it into two columns with the following format

Size: S Price: 1
Size: M Price: 2
Size: L Price: 3
Size: XL Price: 4

May I know how to accomplish this, is sed a possible solution? thanks!

crts · 10-07-2011, 06:53 PM

Hi,

here is an awk solution:

Code:

awk '/Size/ {a[i++]=$0};/Price/ {print a[NR-i-1]" "$0}' file

Assuming that there are as many Size fields as Price fields.

Colorinb · 10-07-2011, 09:06 PM

Quote:

Originally Posted by crts

Hi,

here is an awk solution:

Code:

awk '/Size/ {a[i++]=$0};/Price/ {print a[NR-i-1]" "$0}' file

Assuming that there are as many Size fields as Price fields.

Thanks a lot! It's work!