Search Results

Let's assume $1 is the epoch time to be considered - try
awk -F"|" '
NR == FNR {EN[$1] = $2
next
}

BEGIN {print "RNA Queue RNA Operator RNA...

OK, that should be much easier. How come the start time is later than the end time in all cases above? And, which time (start or end) of
should be considered?

Perl modules could be used to perform date arithmetic/comparison.
Here's a possible solution.


$
$
$ cat exitwithtimeout.txt
Day,Start Date,Start Time,End Date,End Time,Queue,Issue
Mon,07...

Those are not .csv - files. Howsoever, try

awk '
NR == FNR {T[$2,$3,$4,$5]
next
}
FNR == 1 {print "RNA Queue RNA...

Or, in short, show the data you have, and then, show the data you want, and explain how they're related.

It seems converting some EXCEL macro to a shell script is not too attractive in these fora. May I propose a different approach: If you post the two sheets as .csv files (in fact, text files) and...

I tried to cast ALL of this into one single awk script but was not too sure if I got the input file structures right, so YMMV. Why don't you constrain the selection with an adequate where clause on...

I don't have any of your data to work with and the awk available on my system doesn't include the strftime() function you're using, so the following is untested (and given the number of manual edits...

What help do you need?

You have a script. What is it doing wrong?

You need awk. -F and the OFS variable are helpful here
You can set the characters you want to be field separators:

awk -F '[ |]' '{ awk script here }'

You can set the output field separator...

strftime("%c",$1) should use column #1.

Could you please show us what your expected final output should be based on your sample?