troubleshooting Question

Extract credit card numbers from string of numbers

Avatar of techsmile
techsmile asked on
Visual Basic Classic
10 Comments1 Solution2419 ViewsLast Modified:
I have a field containing a string of numbers (varying lengths), some of which will contain credit card numbers and others will only contain junk (invoice numbers, etc).  I need a VB public function that I can utilize in Access that will parse through the string of numbers looking for a potential credit card number "first digit", then check the next 16-digits to see if it contains (1) enough digits and (2) digits that would be valid for a credit card number.  If it contains a credit card number, the number may or may not start in the first position in the field.  Thank you!
ASKER CERTIFIED SOLUTION
mike_dormitorio

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 10 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 10 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