Hi
I want to display the following input data into the tabular format as shown in the output.
Input.txt:
Following jobs are in pending state for more than 10 minutes:
JOB_ID JOB_SUBMIT_ID
MAHAR 784308
PUNJA 109367
Following jobs are running for longer time:
JOB_ID JOB_SUBMIT_ID STATUS_CD Exp_Exe_Time(Minutes) Act_Exe_Time(Minutes)
ABCD 108764 E 50 32019.9333
LMNO 109232 E 20 32019.9333
STUV 107960 E 10 3521357.2
1234 121090 E 50 10197.0166
OUTPUT :
Following jobs are in pending state for more than 10 minutes:
JOB_ID
JOB_SUBMIT_ID
MAHAR
[RIGHT]784308[/RIGHT]
PUNJA
[RIGHT]109367[/RIGHT]
Following jobs are running for longer time:
JOB_ID
JOB_SUBMIT_ID
STATUS_CD
Exp_Exe_Time(Minutes)
Act_Exe_Time(Minutes)
ABCD
[RIGHT]108764[/RIGHT]
E
[RIGHT]50
32019.9333[/RIGHT]
LMNO
[RIGHT]109232[/RIGHT]
E
[RIGHT]20
32019.9333[/RIGHT]
STUV
[RIGHT]107960[/RIGHT]
E
[RIGHT]10
3521357.2
1234
121090[/RIGHT]
E
[RIGHT]50
10197.0166[/RIGHT]