Shell Programming and Scripting

Hi guys,

I need help with formatting the output of a file. Below is the script I use to generate a file called output.xls.

DAY=`TZ=MYT+16 date '+%b'`
DAY1=`TZ=MYT+16 date '+%e'`
ls -ltr /bscswork_bi2/WORK/UMOBILE/IR/IN/ALL/PROCESSED | grep "$DAY $DAY1" | awk '{print $9}' | sort | cut -c3-7 > output1
ls -ltr /bscswork_bi2/WORK/UMOBILE/IR/IN/ALL/PROCESSED | grep "$DAY $DAY1" | awk '{print $9}' | sort | cut -c13-17 > output2
paste output1 output2 > output.xls
rm output1 output2

This is how the output.xls looks like (partial file).

AREDU 772
AREDU 773
AREDU 774
ARM05 17
AUSOP 251
AZEAC 51
AZEAF 264
AZEAF 265
AZEAF 266
AZEAF 267
BELKO 172
BGDAK 258
BGDWT 199
BGRVA 745
BRNBR 186
BRNDS 79
CYPSC 129
CYPSC 130
DZAA1 16
ESPRT 55
ESTRE 308
ESTRE 309

There are identical directory name but the file sequence differ in the above example.

And this is how I would like the output.xls file to look like.

AREDU 772, 773, 774
ARM05 17
AUSOP 251
AZEAC 51
AZEAF 264, 265, 266, 267
BELKO 172
BGDAK 258
BGDWT 199
BGRVA 745
BRNBR 186
BRNDS 79
CYPSC 129, 130
DZAA1 16
ESPRT 55
ESTRE 308, 309

Is there a way I could accomplish this. Please advice.

Thank you all for your assistance.

There are a number of ways of doing what you want to do. Here is one way of doing it using bash.

Code:

match=""
nums=""

while read word num
do
    if [[ $match != $word ]]
    then
        if [[ $match != "" ]]
        then
            echo "$match $nums"
        fi
        match=$word
        nums=$num
    else
        nums="$nums, $num"
    fi
done < file1

if [[ $match != "" ]]
then
   echo "$match $nums"
fi

Hi fpmurphy, thanks for your reply. I'm new to the unix environment and I dont entirely understand your code.

Perhaps you could explain to me how your code works and how I could use it to format my output file.

Sorry for being so green, I'm still learning.

Thanks again for your assistance.

An awk version:

awk '

BEGIN {

word=""
num=""

}

{
if ( NR==1 )
{
word=$1;
num=$2;
}
else {

if ($1 == word)
num=num "," $2;
else {
print word " " num ;
num=$2;
}

word=$1;
}
}

END {

print word " " num;
}

'

Thanks guys. fpmurphy your script worked like a charm, though I'm still trying to figure out how it did it.

If you guys can explain how the scripts work, I would be much obliged.

Thank you so much amicon007 & fpmurphy