Visual basic and string functions

Boss1315 · Post by **Boss1315** » Thu Nov 27, 2003 2:12 pm

I need to find where a space character is, starting from the right of a string and finding the rightmost one. I've tried everything and i cant figure out a way to do it. Can anyone help?

Thanks

Plasma2002b · Post by **Plasma2002b** » Thu Nov 27, 2003 5:08 pm

InStr(String, " ")

will give the value of how many places over the white space is

Boss1315 · Post by **Boss1315** » Thu Nov 27, 2003 5:48 pm

no... i have a string with a name and address. Like: 1234 Main Street Pittsburgh 15222 PA and i need to look starting from the PA and go back and find the next space before it.

Master Jedi · Post by **Master Jedi** » Thu Nov 27, 2003 10:46 pm

use:

InStrRev (reverse instring)

Boss1315 · Post by **Boss1315** » Fri Nov 28, 2003 2:05 am

That worked perfectly.

thanks

Big-O Software

Visual basic and string functions

Visual basic and string functions

Who is online