exp vg
asked on
Access - Separate delimited field with comma or dot
The following statements work if the name field only is separated by a comma, but I have found instances where it is separated by a dot as well.
FName = Left([First Name], InStr([First Name], ",")-1)
LName = Right([First Name], Len([First Name]) - InstrRev([First Name], ","))
I have tried to change the "," to be ",",".",""))
Without success.
I also can run this, followed by a separate replace query for the dot, but I am wondering if there is an easier way.
Thank you
FName = Left([First Name], InStr([First Name], ",")-1)
LName = Right([First Name], Len([First Name]) - InstrRev([First Name], ","))
I have tried to change the "," to be ",",".",""))
Without success.
I also can run this, followed by a separate replace query for the dot, but I am wondering if there is an easier way.
Thank you
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please post examples of names in your database table and how they should be parsed
ASKER
Thank you.
ASKER
Thank you both.