Need scripting Help - Shell Programming and Scripting

nani123 · #1 (**permalink**) 10-10-2008

Dear Scripting experts,
Request to guide me in moving column values to rows
Example:
File 1:

1,a,b,c,d,e,f,g,h
2,f,g,h,i,l

Output file
1,a,b,c
1,d,e,f
1,g,h
2,f,g,h
2,i,l

Actually I tried with using awk and sed but unfortunately i couldn't get the resultant.

Regards
nani

cfajohnson · #2 (**permalink**) 10-10-2008

Quote:

Originally Posted by nani123

Dear Scripting experts,
Request to guide me in moving column values to rows

Your example doesn't move columns to rows; it splits lines.

Here's a shell solution.
Code:
IFS=,
set -f
while read line
do
  set -- $line
  if [ $# -le 4 ]
  then
    print "$line"
  else
   a=$1
   shift
   while [ $# -gt 3 ]
   do
     printf "%s," "$a" "$1" "$2"
     printf "%s\n" "$3"
     shift 3
   done
   printf "%s," "$a"
   while [ $# -gt 1 ]
   do
     printf "%s," "$1"
     shift
   done
   printf "%s\n" "$1"
  fi
done < "$FILE"
If the file is large, it will be slow, and you should convert the script to awk using the same logic.

radoulov · #3 (**permalink**) 10-10-2008

Use nawk or /usr/xpg4/bin/awk on Solaris:

Code:

$ cat file
1,a,b,c,d,e,f,g,h
2,f,g,h,i,l
$ awk -F, '{
  printf$1FS;c=0
  for(i=2;i<=NF;i++)
    printf$i (++c%3?i==NF?RS:FS:RS$1FS)
}' file
1,a,b,c
1,d,e,f
1,g,h
2,f,g,h
2,i,l

ShawnMilo · #4 (**permalink**) 10-10-2008

Here's a fairly simple Python approach (tested and working).

Code:

$ cat nani123.py 
#!/usr/bin/env python

input = open("temp.txt", 'r')

for line in input:

    line = line.rstrip()
    line = line.split(',')
    num = line[0]
    data = line[1:]

    while data:
        print num + "," + ','.join(data[:3])
        data = data[3:]

Test:

Code:

$ cat temp.txt 
1,a,b,c,d,e,f,g,h
2,f,g,h,i,l


$ python nani123.py 
1,a,b,c
1,d,e,f
1,g,h
2,f,g,h
2,i,l

radoulov · #5 (**permalink**) 10-10-2008

Perl is missing:

Code:

perl -F, -pae's/((?:(?:.*?),){3}[^,]*)/$1\n$F[0]/g' file

avronius · #6 (**permalink**) 10-10-2008

And now, my made up space language

Code:

snurdo <inputfile> {zort blip -f[] $1} | glop | ('{prattle ???}',"Take me to your leader")

Disclaimer: The preceding message was an attempt at humour

radoulov · #7 (**permalink**) 10-10-2008

Quote:

Originally Posted by avronius

And now, my made up space language

Code:

snurdo <inputfile> {zort blip -f[] $1} | glop | ('{prattle ???}',"Take me to your leader")

Disclaimer: The preceding message was an attempt at humour

That was missing too!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
New to scripting, Need help	newbie22102	Shell Programming and Scripting	2	02-25-2008 10:08 AM
scripting help	james94538	Shell Programming and Scripting	2	02-08-2008 06:36 PM
difference between AIX shell scripting and Unix shell scripting.	haroonec	Shell Programming and Scripting	2	04-12-2006 08:12 AM
scripting guru's pls help me with scripting on AIX	thatiprashant	Shell Programming and Scripting	1	01-20-2006 06:58 PM
KSH Scripting	dstaller	Shell Programming and Scripting	1	11-16-2005 01:30 PM

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: