We help IT Professionals succeed at work.

How to trim text off of a memo field

Janice Smith
Janice Smith used Ask the Experts™
on
Hello Experts,

I have a memo field in a report that displays text like the following:

CITED PROPERTY ADDRESS - SEE JOURNAL 434 E 118TH STREET

I want to display only what comes after "...SEE JOURNAL" .  

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Will it always be SEE JOURNAL?

Will it always hav eSEE JOURNAL?

Try

Split({YourField},'SEE JOURNAL)[2]

mlmcc
Janice SmithSystems Analyst

Author

Commented:
Yes, it will always be 'SEE JOURNAL' in this instance, so this works perfectly.  Thank you.