Search Results

Hi

i need to compare the datetime between 2 columns.
SunOS 5.1 is used. Notice that mktime seems like not supported.

cat file2
P1,2012 12 4 21 36 48,2012 12 4 22 26 53
P2,2012 12 4 20 36...

Hi R. Singh

I hit syntax error when invoking the command.
awk: syntax error near line 1
awk: bailing out near line 1

Can help to explain the logic for the command?

Thanks

----------...

Yes there are 3 lines with column3 as 1.
The matching row for the third line (2014-09-17 23:28:13|T2|1|1|RE|N) is fifth line (2014-09-17 23:31:16|T2|0).
The result will be 2014-09-17...

I would like to find the first matching row and continue to search from the matching row. if column3 equal to 1 in the row, find the next matching row based on the criteria below. column3 in the...

sh script will be used.
Yes, you are right, can ignore field 3, we can use field 4 to match the Begin and End record.

The input file is sorted by transaction (T1,T2,T3) and datetime.
There are 2 records tied to 1 transaction (start and end).
As there is no end transaction for the first line, it will not be...

Hi Rudic,

column B and C are referring to column 2 and 3.
if current line's column C = 'JO' and next line's column C='JOR' and current line's column B = next line's column B then write the...

Need help to create the script that does the following : -
1. Compare the current line "column B and C" with next line "column B and C"
2. If they are the same, print output to a file

Input...