Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Identifing unwanted lines from string and deleting 1

Status
Not open for further replies.

craigosa6033

Technical User
Sep 12, 2005
10
US
I'm currently usi8ng CR 9

I have an automated email that is posted to our companies tracking system. For reporting purposes, I would like to have the following lines deleted from the beginning of the string, but resume after this header:

The following SR was submitted online by XXXX XXXX on Mon Sep 19 17:02:59 CDT 2005
Institution: XXXXX XXXX
Requestor: XXXXXX XXXXXX
E-mail: XXXXXXXXXXXXXX
Phone: (XXX) XXX-3250
Priority: Normal (Within 48 hours)
Description: Please provide images for account XXXXX statements datedJuly 29 and August 31 Thank you XXX


Sent at 16:57, 19 Sep 05.

I would like to delete all until the word description appears. How would I do this. I've tried with a macro in access, but have not succeeded. Any ideas?

Thanks

carlos
 
Are you saying this is all one string? Then use:

mid({table.string},instr({table.string},"Description:"))

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top