Search Results

Hi I want to compare two rows in unix

first value in row is 1.12 while value in other row is 000001.12.

if i do normal diff this will come as difference...is it any way to overcome this?

This is Output
SUM|1|2|2|20|7
SUM|1|3|1|10|3


First col is fized string
Second and thrid column are col1 and col 2 from input, fouth column is recound count bases on col and col2, fifth column...

Hi,
I have file with below format and sample data - File is pipe delimited
Col1|col2|Account|Bal1|Bal2
1|2|1|10|5
1|2|2|10|2
1|3|3|10|3

I want output as
SUM|1|2|2|20|7
SUM|1|3|1|10|3
...

Hi

My file have 7 column, FIle is pipe delimed

Col1|Col2|col3|Col4|col5|Col6|Col7

I want to find out uniq record count on col3, col4 and col2 ( same order) how can I achieve it.
ex...

Hi
I am executing below command to do summation on 46th coloumn.
cat File1| awk -F"|" '{p += $46} END { printf"Column Name | SUM | " p}'

I am getting output as
Column Name | SUM | 1.01139e+10...

Thanks

Hi All,
I have requirement where I have 4 columns in flat file.
Column names are P,Q,X,Y
in column X I have 3 diff value for records say A,B,C
Now Lets say there are 100 records in file , My...