topic awk Help in Operating System - HP-UX

awk Help

Ashwin_4 — Mon, 19 Apr 2004 07:33:13 GMT

hi masters,
I have one file with 3 columns, i want to take the content of this file in a individual file based on substr(3,1,3) field.

B---A213---206934875
B---A213---20534875
B---A213---207934875
.....
.....

Space is indicated by "---"
i want three output files as below,
File F206==> B---A213---206934875
File F205==> B---A213---20534875
File F207==> B---A213---207934875

Thanks

Re: awk Help

Mark Grant — Mon, 19 Apr 2004 07:41:07 GMT

How about a little shell script

IFS="
"
for i in `cat datafile`
do
newfile=`expr "$i" : ".......$...$"`
echo "$i" > "F$newfile"
done

Re: awk Help

Steve Steel — Mon, 19 Apr 2004 07:48:34 GMT

Hi

Based on

B A213 206934875
B A213 20534875
B A213 207934875

in tmp/fil

cat tmp/fil|while read line
do
echo $line|read a b c
name="F"$(echo $c|cut -c1-3)
echo "$line" > $name
done

Based on

B---A213---206934875
B---A213---20534875
B---A213---207934875

cat tmp/fil|while read line
do
name="F"$(echo $line|cut -c12-14)
echo "$line" > $name
done

Steve Steel

Re: awk Help

Kartik Gajjar — Mon, 19 Apr 2004 07:53:43 GMT

Hi,

Assuming the text in file "s.txt"

Run
awk '{print "echo " $0 " >> F" substr($0,12,3) }' s.txt > foo.sh

This will generate foo.sh

Just run foo.sh will give you the result.

Enjoy.

Kartik

Re: awk Help

Ashwin_4 — Mon, 19 Apr 2004 07:55:04 GMT

hi,
Thanks for quick reply. shall we do it using "AWK"

thanks

Re: awk Help

Mark Grant — Mon, 19 Apr 2004 08:13:10 GMT

Why do you have to use awk? Awk is good, don't get me wrong, but I don't think it's the best solution to your current problem.

The awk solution posted above does not give you the additional files you wanted by the way.

Re: awk Help

Mark Grant — Mon, 19 Apr 2004 08:33:56 GMT

Actually, re-reading Kartik's script above, properly this time, it does give you the files and is an interesting solution to the problem.

Seems a little over the top to use awk to create a shell script when you can do it in a shell script to start with, however, 10 points for style on that one Kartik :)

Re: awk Help

Rodney Hills — Mon, 19 Apr 2004 08:53:36 GMT

"awk" would be pretty straight forward-

awk '{print $0 >"F" substr($3,1,3)}'
HTH

-- Rod Hills