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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

substring confusion

Status
Not open for further replies.

beezley711

Programmer
Joined
Sep 12, 2012
Messages
1
Location
US
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
 
I think just plain old 'index' works from left to right.

Hope this helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top