Looking for a way to extract a text with a pattern in a string.

**domino21** · 10-31-2012, 08:55 PM

Happy Halloween everyone

Is it possible to extract a text that has a pattern or format in a string?
For example I have to text boxes the first one shows the original text. When I click the button, it will only show the text that I want.

untitled.JPG

In the first box, the other texts that i don't want are random in length and are alphanumeric but the text that I want has a fixed length, fixed format/pattern and only numeric. And also, the whole string in the first text box does not have fixed length.

Thanks~

**rylo** · 11-01-2012, 01:08 AM

Hi

Try this

Please Login or Register  to view this content.

rylo

**watersev** · 11-01-2012, 04:47 AM

hi domino21, option, press Run button

**domino21** · 11-04-2012, 08:01 PM

hi domino21, option, press Run button
Attached Files
domino21.xlsm‎ (16.9 KB, 5 views)

This worked great! Although I don't understand how the pattern code works. Thanks a bunch, watersev and rylo.