MS Access Parsing or Splitting a text field in a table
Hi Everyone,
Can someone show me how to parse this:
Val VV Values
7 0 - no
7 1 - yes
6 M - male
6 F - female
into this in my Table1:
Val VV Values
7 0 no
7 1 yes
6 M male
6 F female
Thanks!!!!!!
Can someone show me how to parse this:
Val VV Values
7 0 - no
7 1 - yes
6 M - male
6 F - female
into this in my Table1:
Val VV Values
7 0 no
7 1 yes
6 M male
6 F female
Thanks!!!!!!
Last Comment
I may suggest to use Excel in separating the text, then import into Access once done.
Sincerely,
Ed
Sincerely,
Ed
ASKER
Sure- but I don't know how to do that either- do you?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SELECT [Val], Left(Values,1) as [VV], Mid([Values],3) as [Vals] FROM [TableName]
ASKER
Thanks!
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
Val VV Values
7 0 - no
7 1 - yes
6 M - male
6 F - female
to this:
Val VV Values
7 0 no
7 1 yes
6 M male
6 F female