Parse Access Field

[artemetis]

Hey there....using MS Access, I have a field that is holding names. First field is UID, second is email address, third is names.

some names are formatted as Jack,Smith ; J.Smith, ; me@me.com

I'm only concerned with the ones that are separated by a comma. I need to break them out into two separate fields.

I'm trying to do this in access using the query builder.

Any suggestions?

 

[dhookom]

Why don't you give us about 10 sample values and how you want them to be split?

Duane
Hook'D on Access
MS Access MVP

 

[HarleyQuinn]

I'd imagine using a UDF with Split() would probably be the easiest way to go here but I'll wait for the sample data with Duane.

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.