troubleshooting Question

Split string when pattern an change

Avatar of PopoDi
PopoDiFlag for Canada asked on
Microsoft AccessSQL
4 Comments1 Solution260 ViewsLast Modified:
Hi!
i'm using Access 2003 and have a field in a table called NUM that can be look like any of the examples below:
1108
1010A
1010B
1020/1030/1040
1120/30/40/50/60

I am building a report and there are couple of results I want to display NUM in two columns, one for numbers and the other for suffixes. So, with the above examples, my report would look like:

1108                   |       |
1010                   |A/B |
1020/1030/1040 |        |

I was going to use regexp, but I am not sure how to set the pattern, because of the "/" that can appear unlimited times.

Thanks!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 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 4 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