Parse a text file using shell script

Question

I am stuck with this activity ,I have a txt file like below

0112 00000 34 JOB RECOVERY status poll (ORDERID 2N000, RUNNO 0001) ACCEPTED, OWNER
0112 00000 35 JOB RECOVERY status poll (ORDERID 2N000, RUNNO 0001)STARTED , APPL TYPE
0112 00000 36 JOB PROCESS_kafka(ORDERID 2N001, RUNNO 0001) ACCEPTED , OWNER
0112 00001 37 JOB PROCESS_kafka (ORDERID 2N001, RUNNO 0001) STARTED, APPL_TYPE
0112 00001 38 JOB RECOVERY  status poll(ORDERID 2N000, RUNNO 0001) ENDED OK ,ELAPSED - 0.02 SEC
0112 00003 39 JOB PROCESS (ORDERID 2N001, RUNNO 0001) ENDED OK, ELAPSED - 2.28 SEC

i need to get elapsed - value for each orderid for each job , i need like if orderid is 2N000, then the elapsed i should get-0.02 sec. like this for each orderid i need to get from the file using shell script.

I need the output like

orderid    jobname     ELAPSED
2N000      RECOVERY    0.02
2NOO1      PROCESS     2.28

Please, post the related expected output. Don't post is as a comment, an image, a table or a link to an off-site service but use text and include it to your original question. Also, as this is not a free coding service, we'd appreciate seeing some attempt first. Thanks — James Brown
– James Brown, Commented Jan 13, 2022 at 9:47
awk could solve the problem easily. But can you please show what do you have so far? I mean, the script. — Kent
– Kent, Commented Jan 13, 2022 at 9:48
I tried to grep ORDERID filename | awk pattern , same for elapsed also ..but that gives me wrong matching of orerid and elapsed, @kent — Deepak
– Deepak, Commented Jan 13, 2022 at 9:55

choroba · Accepted Answer · 2022-01-13 12:09:38Z

1

grep ELAPSED file.txt \
| cut -d' ' -f7,5,14 \
| sed -E 's/(.*) ([^[:space:]]+),/\2 \1/'

grep selects just the lines with "ELAPSED";
cut extracts just the columns with orderid, jobname, and elapsed time;
But they are in the wrong order, so sed removes the comma from the orderid and reorders the columns.

If sed is not available, you can use awk:

awk '/ELAPSED/{id=$7; sub(",", "", id); print id, $5, $14}' file.txt

On lines containing ELAPSED, the seventh value is stored in id, comma is removed from it, and the id, jobname, and elapsed time are printed.

edited Jan 13, 2022 at 12:09

answered Jan 13, 2022 at 10:07

choroba

245k27 gold badges221 silver badges304 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Deepak Over a year ago

sed giving me :no such file or directory

choroba Over a year ago

@Deepak: Do you mean you don't have sed installed?

Deepak Over a year ago

yes @choroba ..is there any other way

choroba Over a year ago

Do you have awk installed? Or perl?

Deepak Over a year ago

i have awk installed

|

Dominique · Accepted Answer · 2022-01-13 10:02:33Z

0

It's not perfect, but it's a start:

grep -i "elapse" test.txt | awk -F " " '{print $7 " " $5 " " $14}'

answered Jan 13, 2022 at 10:02

Dominique

17.6k20 gold badges81 silver badges161 bronze badges

Collectives™ on Stack Overflow

Parse a text file using shell script

2 Answers 2

9 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related