Splitting text field for report

[fdservices]

I have a free flow text field with the word "Title" in the text.

I need to read the text field and then insert the text following the word "Title" in to my report.

Can anyone give me a clue as to how to proceed?

Many thanks

Andrew

 

[Kempes]

New formula field.

mid({yourtextfield},6)

or 7 depending on which character you want the text to start from.

 

[boblarson]

Or use the Instr function to find the word Title

 

[fdservices]

Thanks all, I'll give it a whirl

Andrew