How to remove timestamp using regular expression
Hi all,
I would like to remove TimeStamp to the reports I'm receiving. Basically the report's format is just the same and I just like to remove the TimeStamp
FILE LIBRARY MEMBER FORMAT
QASYCPJ QTEMP QASYCPJ4 QASYCPJ4
DATE . . . . . . . 11/20/12
TIME . . . . . . . 13:35:30
11/22/12 10:41:59
ENTRY USE USRPRF USRPRF PASSWORD PASSWORD *ALLOBJ *JOBCTL
TYPE PROFILE NAME COMMAND CHANGE EXPIRED SPCAUT SPCAUT
TIMESTAMP
CP A TSJ SDDW CHG DISABLE
2012-11-22-10.37.34.969088
CP A TSJ SDDW CHG ENABLE
2012-11-22-10.37.40.973536
*****END REPORT*********
i wanted to remove @ the header
DATE . . . . . . . 11/20/12
TIME . . . . . . . 13:35:30
and @content
2012-11-22-10.37.34.969088
2012-11-22-10.37.40.973536
basically contents may add some reports with timestamps but same format. How can I get rid of this timestamp using regular expression? thanks.
Software/Hardware used:
Software/Hardware used:
ASKED:
November 26, 2012 5:35 AM
UPDATED:
November 26, 2012 1:57 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
Michael Tidmarsh 
14,000 pts. ,
jezz341 195 pts.
14,000 pts. ,
jezz341 195 pts. To see all answers submitted to the Answer Wiki: View Answer History.
What do you want to remove the timestamp from? If it’s a “report”, how are you accessing it? Where is the “report” stored? — Tom
QASYCPJ4, Outfile for journal entry type CP
I don’t think you’re be able to change the report.
Options are using the dspjrn and building a custom report
or
Coping the report to a database file and writing a program to pick the stuff you want from it.
How are you getting the reports? email or from an OUTQ or as a file?It can be done a few ways, the simple way is to modify the program that produces the report to write all the data except for the header info to a database file.
If you cannot get the program modified here’s another solution.
1.Copy the report/spoolfile into Excel.
2. Add a numeric column to keep track of the line sequence of the report.
3.Sort the spreadsheet and delete the headers and any other data you do not want.
4.Sort report back to original sequence by the column you added.
5. Delete the sequence column.