Search Results

this is the error message that appears.

awk: datecommand.txt:1: awk '{
awk: datecommand.txt:1: ^ invalid char ''' in expression
awk: datecommand.txt:1: awk '{
awk: datecommand.txt:1: ...

@jim thanks for the script. I have tried each of the script but it doesn't work. could you clarify me better and which script to use. thanks for your help.

I need to print the difference (in days) in ($6) between the starting and end date of records for each unique ID ($5) on a new field.

[ 7 65 2 5 32070 2010-12-14 13:25:30
7 82 2 ...

the data has a repeated record on different days for the same Id [$5] and i want to print the difference between the oldest and recent record date (in days) [$6] for each unique ID on separate field....

I want to print the difference (in days) between ($7) and the oldest record date ($6) based on unique ID ($5) on a new field. In addition, I want to subtract oldest date from recent dates(in days)...

I used this code:
awk 'NR==FNR{a[$5]=$5 FS $6;next}$0=$0 FS a[$NF]'file2 file1


Please use CODE tags as required by forum rules!

I need to match two files based on $5 from file 1 and $5 of file 2 and print all fields of file 1 which match with file 2. In addition, want to print $6 and $7 of file 2 in file 1 after matching and...