Columns to rows

mgirinath · #1 (**permalink**) 11-28-2007

I have a file which has values seperated by ~ as shown below and I have to achieve a column to row from this.

Incoming row is like this

Quote:

A78645~B67354~H74658~N536482

How do i get the occueance of ~ and then split it into rows as and below is what I have to achieve.

Quote:

A78645
B67354
H74658
N536482

Thanks

porter · #2 (**permalink**) 11-28-2007

Code:

for d in `echo A78645~B67354~H74658~N536482 | sed y/\~/\ /`; do echo $d; done

mgirinath · #3 (**permalink**) 11-29-2007

Quote:

Originally Posted by porter

Code:

for d in `echo A78645~B67354~H74658~N536482 | sed y/\~/\ /`; do echo $d; done

The above code works but it is splitting the record if the record has space in it.

Quote:

If i have a record A3647 76~A784657~J67364 9~H7846 9586.
it splits it into
A3647
76
A784657
J67364
9
H7846
9586

can this be fixed.

matrixmadhan · #4 (**permalink**) 11-29-2007

Code:

echo "A3647 76~A784657~J67364 9~H7846 9586" | sed 's/\~/\
/g'
A3647 76
A784657
J67364 9
H7846 9586

Lakris · #5 (**permalink**) 11-29-2007

I am sorry vgersh99, but it was Your short tone, pointing me to a "bad style of programming" page, and saying that my solution don't work, that triggered me. Of course I know there are many ways to do the same thing. I may have overreacted. Sorry.

mgirinath? Can You explain more about what You want?

Do You want

Quote:

A~B~C
1~2~3
X~Y~Z

to become

Quote:

A1X
B2Y
C3Z

or

Quote:

A
B
C
1
2
3
X
Y
Z

or even

Quote:

A
1
X
B
2
Y
C
3
Z

???
Have Yo tried my suggestion?

/Lakris

vgersh99 · #6 (**permalink**) 11-28-2007

nawk -f transpose.awk myFile

transpose.awk:

Code:

BEGIN {
   FS=OFS="~"
}
{for(i=1;i<=NF;i++){a[i,NR]=$i};m=NF;n=NR}
END{
   for(j=1;j<=m;j++)
         for(k=1;k<=n;k++)
             printf("%s%s",a[j,k],(k==n) ? "\n" : OFS)
}

Lakris · #7 (**permalink**) 11-28-2007

It doesn't have to be so complicated. Depends on if You want to group it or so but the simplest way would be to use tr, i think.

Quote:

cat splitsource.txt| tr "~" "\n"

This will shove the textfile through the program tr, and replace all occurances of ~ with a newline.
Try it.

/Lakris

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to convert a single column into several rows and columns?	ashton_smith	UNIX for Dummies Questions & Answers	5	05-24-2008 04:44 PM
shell script required to convert rows to columns	suresh3566	Shell Programming and Scripting	2	05-07-2008 05:25 AM
deleting rows & columns form a csv file	code19	Shell Programming and Scripting	2	03-13-2008 10:06 AM
Cut rows	obedkhan	HP-UX	2	08-23-2006 09:36 AM
Finding different rows	dombi	Shell Programming and Scripting	2	03-06-2006 05:01 PM

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: