![Avatar of cisilay](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
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.
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 cisilay](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
![Avatar of cisilay](https://cdn.experts-exchange.com/images/experts-exchange/avatar-01-large.gif)
ASKER
OK thanks, it works well.
Regards.
Regards.
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