Finding last occurrence of character in string?
Posted by Mike Fleuette on September 17, 2001 8:38 PM
Is there a an easy way to find the last occurrence of a particular character in a text string? Specifically, I have a column that has user names in it and I need to break it out into first and last names (in two different columns).
For example, "Mike Fleuette" would become "Mike" and "Fleuette"; "Mike X. Fleuette" would become "Mike X." and "Fleuette"; "Mike and Michelle Fleuette" would become "Mike and Michelle" and "Fleuette".
Any thoughts? If there is a way to find the last space, then it is easy enough to do with RIGHT(), LEFT() and LEN()...