Link to home
Start Free TrialLog in
Avatar of cisilay
cisilay

asked on

Parsing text in access 2007

Hi,
I have imported some datas to access 2007 from a text file. One of the field is an artist full name with 2 or 3 words included (Elton John) or (Evelyn Peggy March).
How can I parse this "full name" field to 2 separated fields (First Name and Last Name) like (John, Elton) or (March, Evelyn Peggy) ?
Please note that I'm a novice and I cannot maybe understand when you explain only the function (without how and where I must enter).
Thanks.
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Hello cisilay,

This is actually a more complex question than I think you realize.  Have a look at this
current question for a sense of the difficulties behind what, at first glance, sounds
like such a simple thing:

https://www.experts-exchange.com/questions/22902631/PARSE-FULL-NAME-FIELD.html

Regards,

Patrick
Avatar of cisilay
cisilay

ASKER

Hi,
These kind of formulas are very complicated for me.
OK, if I want only parse 2 words from one "full name" field to 2 separated fields (First Name) (Last Name), without suffix or without middle name, like only from (Elton John) to (Elton) and (John), is it easy  and if yes how ?
Please don't forget to answer for a novice user.
Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cisilay

ASKER

OK thanks, it works well.
Regards.