Search Results

Thank you Ridic for your update. I will remember your quotes.
And rounding result value code also worked. I liked "Teach me to do it myself" thing and will do the same in future whenever needed.
...

Hi Rudic,

Thanks for your update on this. But it is not working for my case. And one more thing I have not got your code

awk 'NR == FNR {SUM[$3]+=$7+$9; next} {sub (FS $8 FS, FS sprintf...

Here is a new example to explain in detail-
new Input.dat will have content like

RRD 0Z91YUn000000Lk 9000100001 103020151117 STMT151117155527001 0000 2 000000 000004
RRD ...

Your calculations seem to assume that there will always be exactly two lines with a given 3rd field value. Are these pairs of lines always adjacent (as in your sample input and output)? Can there be...

#!/bin/sh
JOBFOLDER=/opt/hpx/exstream/StatementAppA/inputs/POC/testSort
input_file=$JOBFOLDER/Input.dat
count_output_file=$JOBFOLDER/Count_output.dat...

I have input file like Input.dat with below content
RRD 0Z91YUn000000Lk 9000100001 103020151117 STMT151117155527001 0000 2 000000 000004
RRD 0Z91YUn00000ysj 9000100001...

Hi .. I want to use |ÇÞ| this string as a delimiter in awk command.

How can I use |ÇÞ| as a delimiter in awk command ?

Yes .. It worked thank you ..

Hi all,
I have file a.dat with content
0,ID,,
1,001,2015060,UB0085000,Key2,abc,xyz
1,338,2015103,UB0085000,Key1,abc,xyz
1,338,2015103,UB0085000,Key5,abc,xyz...

Yes .. Its working ..!! :) Thank you ... Can you please explain the logic ?

Yes I want to replace 3 fields of file a.dat(7th,8th and 9th) which will be empty initially.
Can you please explain the code for this scenario ?

awk 'NR==FNR{A[$2]=$1; B[$2]=$3; next} {$3=A[$1]; $4=B[$1]}1' FS=, OFS=, a.dat b.dat

I am using awk to resolve this but not able to match the column value from both the files.

If you have any idea please share !

Hi All,

I have a.dat file with content
1,338,30253395122015103,2015103,UB0085000,STMT151117055527002,,,
1,338,30253395122015103,2015103,UB0085000,STMT151117055527001,,,

and b.dat having...