troubleshooting Question

MS Access Parsing or Splitting a text field in a table

Avatar of jetera
jeteraFlag for Canada asked on
Microsoft Access
6 Comments1 Solution292 ViewsLast Modified:
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


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros