Hello
Brand new to the group. (This looks like a great group...wish I found it earlier in my career)
Thank you in advance for helping or attempting to help.
I have an access DB with a memo (Long Text) field.
This memo field contains lots of information, which is hand-typed and not consistent.
I need to pull from this field a string the matches the following format
####-####
(That being 4 numbers, a dash, then 4 numbers.)
I would prefer to use a built in function, but am comfortable with using VBA.
Examples:
123 text more text account 1234-5678 text more text
test more text 12321324234 acct: 2345-6789 text more text
test-moretext 1234 5678 Account Number 3456-7890 text more
Results would return:
1234-5678
2345-6789
3456-7890
Brand new to the group. (This looks like a great group...wish I found it earlier in my career)
Thank you in advance for helping or attempting to help.
I have an access DB with a memo (Long Text) field.
This memo field contains lots of information, which is hand-typed and not consistent.
I need to pull from this field a string the matches the following format
####-####
(That being 4 numbers, a dash, then 4 numbers.)
I would prefer to use a built in function, but am comfortable with using VBA.
Examples:
123 text more text account 1234-5678 text more text
test more text 12321324234 acct: 2345-6789 text more text
test-moretext 1234 5678 Account Number 3456-7890 text more
Results would return:
1234-5678
2345-6789
3456-7890