Shell Programming and Scripting

I have one csv file and it contains values for 10 columns. Need to create one script using awk which will take the values from csv and write in a flat file.While writing the values from csv to flat file,one condition has to satisfy ie:-if suppose csv contains values as

Code:

abc,cd,e,f,gh,ij,kl,mn.op,qr

these values has to write in say examople:--in the form

Code:

abc   cd e   f     gh  ij    kl   mn             op  qr

space between abc and cd may 3 characters,space b/w cd and e may 5 characters..this way i ahve to write the values in flat file
please help to solve....

thanks in advance

Your question does not make a lot of sense....

try something like:

Code:

#  echo "abc,cd,e,f,gh,ij,kl,mn.op,qr" | tr ",." "  "
abc cd e f gh ij kl mn op qr

or

#  echo "abc,cd,e,f,gh,ij,kl,mn.op,qr" | nawk -F"[,.]" '{print $1"   "$2" "$3"   "$4"     "$5"  "$6"    "$7"   "$8"             "$9"  "$10}'
abc   cd e   f     gh  ij    kl   mn             op  qr

Have a play with these, and see if you can get what you want. Otherwise, if you define your problem a little more clearly it would help.

HTH

thanks for the reply..i will make it more clear......

my csv file has 10 columns
eg:-
A,1,2,3,4,5,6,7,8,9
B,1,2,3,4,5,6,7,8,9
c,1,2,3,4,5,6,7,8,9
-----------------

I have to create a flat file from this.Conditions are:if the first column is "A",then take 1st 3rd,5th and 9th column from csv file and write to flat file.IF the first record is C then take 2nd.4th and 8th column and write to same flat file..like that..
one more condition is :-
at the time of writing values from csv to flat file,if suppose for record A,it will take 1st 3rd,5th and 9th column from csv file and while writing,after 1st column,give some spaces say 4 characters ,then write 3rd column,after that give some space say 5 characters and write 5th column......

ok..

something along lines of:

Code:

#  awk -F, '$1=="A"{print $1,$3,$5,$9}$1=="c"{print $2,$4,$8}' infile
A 2 4 8
1 3 7

or
#  awk -F, '$1=="A"{print $1"    "$3"        "$5,$9}$1=="c"{print $2,$4,$8}' infile
A    2        4 8
1 3 7

Closer to what you're after ?

thanks tyta..i will check this logic.....

another one is:---
from this csv file
suppose 10 columns:-
A,1,2,3,4,5,6,7,8,9
B,1,2,3,6,7,8,9
c,1,2,3,4,5,9
-----------------
just need to create one flat file.only condition is each columns has fixed length size..say

length of column 1 =1,length of column 2=3,length of column 3=5,length of column4=15....so at the time of writing values from csv to flat file,this format has to follow.
if supppose here 3 rd column is "2" and while writing to flat file length of column 3=5 is declared,so that after 2 four space then only another ....

you can prob deal with that using printf e.g.

Code:

#  awk -F, '{printf("%5s%3s%7s\n",$1,$2,$3)}' infile
    A  1      2
    B  1      2
    c  1      2

HTH

thanks....