Search Results

Hello gpk_newbie,

Following may help you to understand the command.

awk -F, ########### Making comma(,) as a field seprator.
'{gsub(/..../,"&-",$4); ...

Hello gpk_newbie,

Could you please try following and let me know if this helps you.

awk -F, '{gsub(/..../,"&-",$4);sub(/\-$/,X,$4);} 1' OFS=, Input_file
Output will be as follows.
...

No problem. Just a small tweek:


awk '
BEGIN { i = 0; }

{
split( $2, a, ":" ); # divide field 2 into hr min sec
t = (3600 * a[1]) + (60 * a[2]); #...

You are correct; my original post indicated that it would snarf from the first occurrence of the timestamp until the end. I didn't catch the part in your original post that indicated you only wanted...

DOS CMD is not UNIX sh. $ doesn't give you a variable.

It only took MS 20 years, but they did finally add a method to read from keyboard:@ECHO OFF

SET /p userin=Please enter your full name: ...