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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Extract up to a comma and then what is left
- Thread starter acorbally
- Start date
There are a few ways. If there is only one comma, then this is what I suggest:
strLastName = Left(strTest, InStr(strTest, ","))
strFirstName = Right(strTest, Len(strTest) - Instr(strTest, ",") + 1)
[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]
strLastName = Left(strTest, InStr(strTest, ","))
strFirstName = Right(strTest, Len(strTest) - Instr(strTest, ",") + 1)
[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]
- Status
