Shell Programming and Scripting

Thanks All....
it is working....
but i am facing another problem

while i am trying to change the format

like

794051400123|99.98|COM|24|MOM|62|RNO|73|SOM|25

it gives me result like

794051400123|99.98
|COM|24|MOM|62|RNO|73|SOM|25

i.e brake 1 line into 2 line...

Please post a sample of input lines (preferably less than five lines) which allows us to reproduce this problem. With the input you have posted, the code works. We can't know what the special cases are if you don't provide representative input samples.

here i past my code:-

awk -F '|' 'NF==0 { next } $1 == prev {collect=collect","$2"="$3; next }
{ if (collect) print collect; prev = $1; collect = $1","$5","$6","$7","$2"="$3; next }
END { if (collect) print collect}'

Input:-

794051400123|COM|24|0|BD|R|99.98

794051413727|COM|11|0|BD|R|28.99

794051415622|COM|23|0|BD|R|28.99

883929004676|COM|0|0|BD|R|28.99
794051400123|MOM|62|0|BD|R|99.98

794051413727|MOM|4|0|BD|R|28.99

794051415622|MOM|80|0|BD|R|28.99

883929004676|MOM|0|0|BD|R|28.99

883929017164|MOM|0|0|BD|R|39.99
794051400123|RNO|73|0|BD|R|99.98

Corrent Out put:-


794051400123,BD,R,99.98,COM=24,MOM=62,SOM=25,RNO=73
794051413727,BD,R,28.99,COM=11,MOM=4,RNO=8
.....

But my out put(Wrong):-

794051400123,BD,R,99.98
,COM=24,MOM=62,SOM=25,RNO=73
794051413727,BD,R,28.99
,COM=11,MOM=4,RNO=8
.....

i.e breaks line from 99.98..Which is wrong.

With the input you posted, I get the following output.

Code:

794051400123,BD,R,99.98,COM=24
794051413727,BD,R,28.99,COM=11
794051415622,BD,R,28.99,COM=23
883929004676,BD,R,28.99,COM=0
794051400123,BD,R,99.98,MOM=62
794051413727,BD,R,28.99,MOM=4
794051415622,BD,R,28.99,MOM=80
883929004676,BD,R,28.99,MOM=0
883929017164,BD,R,39.99,MOM=0
794051400123,BD,R,99.98,RNO=73

There is not a SOM in sight in your sample input data, so I don't understand where that would come from.

If I sort the input before feeding it to awk, I get the following result.

Code:

794051400123,BD,R,99.98,COM=24,MOM=62,RNO=73
794051413727,BD,R,28.99,COM=11,MOM=4
794051415622,BD,R,28.99,COM=23,MOM=80
883929004676,BD,R,28.99,COM=0,MOM=0
883929017164,BD,R,39.99,MOM=0

If I understand your requirements, this is correct.

In other words, I cannot reproduce your problem. Again, we need input and output which we can reproduce the problem with.

yes...

794051400123,BD,R,99.98,COM=24,MOM=62,RNO=73
794051413727,BD,R,28.99,COM=11,MOM=4
794051415622,BD,R,28.99,COM=23,MOM=80
883929004676,BD,R,28.99,COM=0,MOM=0
883929017164,BD,R,39.99,MOM=0

is correct

but when i run my shell script all lines brakes from 99.98,28.99...etc.

i.e
794051400123,BD,R,99.98
,COM=24,MOM=62,RNO=73
794051413727,BD,R
,28.99,COM=11,MOM=4

i don't understand why it breaks the line? Will there any may to merge 2 line into one line.I have tried it but falied...Can u pls paste your code?

Code:

sort inputfile | awk ... your awk script here ...

If you have DOS carriage returns in the file, that could perhaps also explain the breaks.