UNIX for Dummies Questions & Answers

customising the output

if i have entries in my file like

1234 A
3433 A
4343 B
3434 B
7667 C
4343 D

can i get the output like

A B C D
1234 4343 7667 4343
3433 3434


and also like

A
1234
3433
B
4343
3434
C
7667
d
4343

pls help in getting both the way of outputs

http://steve-parker.org/sh/sh.shtml
http://quong.best.vwh.net/shellin20/

These two links are good enough for what you need... but you can also use the manuals for sh (or ksh, csh, bash or whatever you want) or google to find other tutorials. You can solve this using a small script with 2 or 3 "for" loops or something like this which take the second field from all the rows and put it on the first line of the output and after that the second loop take the first field and put it on the second line of the output...
For the second case you should use "if" statement too
By the way... is this your homework ?

thanks, let me check with this sites and get back.

by the way this is my regular part of my day to day work

and i am trying to customise my reports

Hi

you can try this,
considered | delimited sample file

this is just an example of how to proceed with regarding formatting
and need many modifications proceeding with report generation purposes.

Please try, and let me know ur comments abt this.

Both the formats are generated.

# !/usr/bin/ksh

old_alpha=#
app_char=' '
first_line=''
second_line=''
third_line=''

#First Format
for i in `cat sample`
do
num=`echo $i | cut -f1 -d"|"`
alpha=`echo $i | cut -f2 -d"|"`

if [ $alpha != $old_alpha ]
then
first_line=$first_line$alpha$app_char
second_line=$second_line$num$app_char
else
third_line=$third_line$num$app_char
fi

old_alpha=$alpha
done

echo "$first_line"
echo "$second_line"
echo "$third_line"

#Second Format
old_alpha=#
for i in `cat sample`
do
num=`echo $i | cut -f1 -d"|"`
alpha=`echo $i | cut -f2 -d"|"`

if [ $alpha != $old_alpha ]
then
echo $alpha
echo $num
else
echo $num
fi

old_alpha=$alpha
done
exit 0

Thanks