How to remove timestamp using regular expression

195 pts.
Tags:
AS/400
AS/400 TimeStamp
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • philpl1jb
    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.
    49,590 pointsBadges:
    report
  • ToddN2000
    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.
    8,705 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following