How can I parse a field with separating commas

P

penake

The field has information that must be parsed out -- it looks like this:
firstname,middlename,lastname,maidenname
I need to have each name in a unique field.
 
S

Sergey Poberezovskiy

Take a look at Split function - it may the answer you are
looking for:

Dim values as Variant
values = Split(inputString, ",")
firstName = values(0)
middleName = values(1)
...

HTH
 
Top