I am struggling to format the output with awk. i need a report file.
your help on this will be appreciated.
Fallowing is the input file that is pipe seperated.
is it possible to generated the report that is alligned left justifed as that of sample output.
I apprecitae your help on this.
InputFile:
Code:
108005555|001|christina.lipski||Submitter Signature|2005/05/09-19:16:19:021|2005/05/10-15:52:36:112| eSCR 10744 attachment in REF file
108005555|001|james.m.thompson|Unable to Complete (See Comments)|Initial Change Request Assessment|2005/05/09-19:16:21:794|2005/05/10-15:00:48:486|1 Christina Lipski
~In the body of the change request I cut and pasted Jim Lopez's comments. According to him, the inductance limit is already complete and the eSCR should have been describing a different request to change the process. Read the comment. The eSCR should probably be rejected and re-issued with the proper description.
108005555|001|james.m.thompson||Submitter Signature|2005/05/10-15:00:25:440|2005/05/10-15:00:54:659|0 Mike,
~Do you agree that this eSCR should be reissued by the supplier AND that you should be the change owner?
108005555|001|super user|OK - See Comments|Read the comments and correct me if I'm wrong.|2005/05/10-15:00:27:109|2005/05/10-15:00:53:687| Auto-signoff for Advisor Participant "james.l.lopez" to remove from inbox.
108005555|001|super user|OK - See Comments|Read the comments and correct me if I'm wrong.|2005/05/10-15:00:27:187|2005/05/10-15:00:53:964| Auto-signoff for Advisor Participant "michael.s.thompson" to remove from inbox.
108005555|001|christina.lipski|Complete (See Comments)|Perform additional work on CR|2005/05/10-15:01:00:066|2005/05/10-15:20:26:144| CR cannot be completed. Please reject.
108005555|001|james.m.thompson|Unable to Complete (See Comments)|Initial Change Request Assessment|2005/05/10-15:20:28:870|2005/05/10-15:52:11:597| eSCR that initiated this change request had wrong information. eSCR is rejected.
Output File Should look like
Code:
==================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
USER ACTION TAKEN ASSIGNMENT TIMESTAMP IN SIGNOFF DATE COMMENTS
==================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================
christina.lipski Submitter Signature 2005/05/09-19:16:19:021 2005/05/10-15:52:36:112 eSCR 10744 attachment in REF file
james.m.thompson Unable to Complete (See Comments) Initial Change Request Assessment 2005/05/09-19:16:21:794 2005/05/10-15:00:48:486 1 Christina Lipski~In the body of the change request I cut and pasted Jim Lopez's comments. According to him, the inductance limit is already complete and the eSCR should have been describing a different request to change the process. Read the comment. The eSCR should probably be rejected and re-issued with the proper description.
james.m.thompson Submitter Signature 2005/05/10-15:00:25:440 2005/05/10-15:00:54:659 0 Mike,~Do you agree that this eSCR should be reissued by the supplier AND that you should be the change owner?
super user OK - See Comments Read the comments and correct me if I'm wrong. 2005/05/10-15:00:27:109 2005/05/10-15:00:53:687 Auto-signoff for Advisor Participant "james.l.lopez" to remove from inbox.
super user OK - See Comments Read the comments and correct me if I'm wrong. 2005/05/10-15:00:27:187 2005/05/10-15:00:53:964 Auto-signoff for Advisor Participant "michael.s.thompson" to remove from inbox.
christina.lipski Complete (See Comments) Perform additional work on CR 2005/05/10-15:01:00:066 2005/05/10-15:20:26:144 CR cannot be completed. Please reject.
james.m.thompson Unable to Complete (See Comments) Initial Change Request Assessment 2005/05/10-15:20:28:870 2005/05/10-15:52:11:597 eSCR that initiated this change request had wrong information. eSCR is rejected.
I have tried the fallowing AWK script. did not help me with the correct format.
Last edited by radoulov; 11-11-2008 at 09:42 AM..
Reason: added code tags
How to append the line with the previous if it not start with 1=.
1=ttt, 2=xxxxxx, 3=4545
44545, 4=66666,
1=ttt, 2=xxxxxx, 3=34434
3545, 4=66666, 5=ffffff
6=uuuuuuu, 7=ooooooo
1=ttt, 2=xxxxxx, 3=311343545, 4=66666
1=ttt, 2=xxxxxx, 5=XAXAXA, 7=FDFD (3 Replies)
Hi,
How can I remove the line beak in the following case if the line begin with the special char “;”?
TEXT
Text;text
;text
Text;text;text
I want to convert the text to:
Text;text;text
Text;text;text
I have already tried to use... (31 Replies)
Hi all,
Please help me in providing sample code to append the following 4 lines in one row.
Input :
A1/EXT "BAPBSC10/07B/00" 523 090530 0115
RXOCF-430 HY1711 1
EXTERNAL ALARM
DOOR ALARM
Output should be :
A1/EXT "BAPBSC10/07B/00" 523 090530 0115 ... (8 Replies)
I'll try explain this as best I can. Let me know if it is not clear.
I have large text files that contain data as such:
143593502 09-08-20 09:02:13 xxxxxxxxxxx xxxxxxxxxxx 09-08-20 09:02:11 N line 1 test
line 2 test
line 3 test
143593503 09-08-20 09:02:13... (3 Replies)
Hi,
I need help for below scenario.I have a flat file which is having records seperated by delimiters which will represent each record for oracle table.My Control file will consider each line as one record for that table. Some of the lines are aligned in two/three lines so that records are... (4 Replies)
I have a requirement like below
030150678 bos 00156 0500405612 23 23
i have split the above line based on position and append pipe to it
1-3 , 4-8, 9, 10-18,19-25,26-27
030|15067|8| .... so on
i can't use cut because... (11 Replies)
Hi All,
This is very urgent, I've a data file with 1.7 millions rows in the file and the delimiter is cedilla and I need to format the data in such a way that if the NF in the next row is less than 1, it will append that value to previous line.
Any help will be appricated.
Thanks,... (17 Replies)
Hi, I have data as below.
36578019,005-923887317,UNMDL,20151230,2C3CCAAG4GH135448,L,TX,20160108,62,"030916 PPT TX AFF RPRT VALID AFF IN PDP WLL FWD TO
RYAN ON 031116 CB1619
",,
36580219,611-923785453,FC,20151209,ZACCJABT9FPC19274,L,TX,20160108,83,,,... (4 Replies)
Hi,
i have a file with multiple entries. After some tests with sed i managed to get the file output as follows:
lsn=X-LINK-IN0,apc=661:0,state=avail,avail/links=1/1,
00,2110597,2094790,0,81,529,75649011,56435363,
lsn=TM1ITP1-AM1ITP1-LS,apc=500:0,state=avail,avail/links=1/1,... (5 Replies)