Reverse Arrange File - UNIX for Dummies Questions & Answers

The One · #1 06-12-2007

I've got hundreds of lines in a file that looks like this:

Line1 CCR CCH
Line2 ICVM FBO GSC
Line3 MKF

The result should be like the one below so that I can insert them on our database.

Line1 CCR
Line1 CCH
Line2 ICVM
Line2 FBO
Line2 GSC
Line3 MKF

Thanks in advance!

vgersh99 · #2 06-12-2007

Code:

nawk '{ for(i=2;i<=NF;i++) print $1, $i }' myFile

porter · #3 06-12-2007

do something like the following to get just the list of words

Code:

cat input-file | while read N
do
    for d in $N
    do
         echo $d
    done
done

then run the output through sort.

The One · #4 06-12-2007

Quote:

Originally Posted by vgersh99

Code:

nawk '{ for(i=2;i<=NF;i++) print $1, $i }' myFile

It worked!!! I removed the "n" on the "nawk". Some users maybe confused.

Code:

awk '{ for(i=2;i<=NF;i++) print $1, $i }' myFile

jim mcnamara · #5 06-13-2007

nawk is the "usable" version of awk on Solaris, vgersh works on Solaris I believe. awk on Solaris is an ancient version and does play well with everyone else's awk.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to reverse the contents of a file?	aajan	UNIX for Advanced & Expert Users	10	05-17-2008 08:03 AM
how to arrange 3 file to one using awk...?	penyu	Shell Programming and Scripting	9	01-17-2008 02:26 AM
Need to read a file in reverse	scorreg	Shell Programming and Scripting	5	03-01-2006 09:14 PM
sort a file in reverse order	frustrated1	Shell Programming and Scripting	11	09-21-2005 12:41 PM
reverse lookup file problem	Westy564	IP Networking	2	01-09-2004 11:55 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode