Help parsing a delimited string

K

kidkosmo

Hi, All,

I need a little help with parsing a string in VBA. What I'm doing is
capturing user's NT Usernames in my database. I capture this by using
"strUser=fOSUsername". strUser is then captured as "john.a.doe". I'd
like to be able to switch that around to "Doe, John A" in one field
and not multiple fields (such as with the Split function).

Any help would be greatly appreciated.
 
K

KARL DEWEY

Try this --
Mid([YourString], InstrRev([YourString], ".")+1) & ", " &
Mid([YourString], Instr([YourString], ".")+1, InstrRev([YourString],
".")-Instr([YourString], ".")) & " " & LEFT([YourString], Instr([YourString],
".")-1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parsing a network path 2
Help parsing text field in access 3
Parsing space delimited records 8
Create a string from a query result to add into sendObject 2
Substring/Parsing Not sure what to call it! 6
Parsing tab-delimited text data 2
importing delimited ascii file with zero-length strings 1
Solution: Parsing a search string and creating an SQL where clause 3

Top