substring confusion

[beezley711]

Hi guys,
I have been trying to figure this out for over 2 hours. And I am not sure exactly how to do this. I will try and explain it the best i can.

i have a lastname field - 150 chars long.
on my report though i can only display 40 chars on 1 line - I would like to search for a " " to decide when to wrap to the next line. but it one isn't there or close enough then i just need to wrap to the next line for the next 40 chars to be displayed.

i tried to use the r-index but that starts at the right of the string
I know there is a way to do this but i am just not finding it.

any help would be much appreciated.

Thanks
Shelly

 

[piperent]

I think just plain old 'index' works from left to right.

Hope this helps