Hi,
I'm using CRXI

I have a field which contains text such as:
"Item one has this description"
"The second item has different text"
"And so does the third"
"And on and on"

I would like my report to remove all text after the 2nd space so that the report would have:
Item one
The second
And so
And on

In the report, I'm using format field; display string with the following formula:

extractstring({vRptScheduledExams.ExamDesc},"",mid({vRptScheduledExams.ExamDesc},
instr({vRptScheduledExams.ExamDesc}," ")+0))

This removes all text after the first " " (space).
It returns only:
Item
The
And
And
How do I advance the formula to remove after the second space?
Thanks for your help.

Patrick




Edited by patgio - 28 Aug 2012 at 5:54am

wow.. that is amazing.
Thank you very much.
It works perfectly.