Hi Forum,
I've spent hours on trying to get this pattern right but no luck.
I thought I was following the rules but maybe someone can help here.
I want to create a regular expression for the below number - NOTE ALL numbers can change to other numbers.
I've come up with this but it's not working.
Please Login or Register to view this content.
[\d-][0-9][0-9-][0-9][0-9][0-9-][0-9][0-9][0-9][0-9][0-9-][0-9][0-9][0-9]$"
Remember you are unique, like everyone else
Hello noboffinme,
This macro will display each parsed number in the string. This will work for varying whole numbers provided the number of hyphens remains the same.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Leith,
I can see the result is displaying each piece of the 1-12-123-12345-1234.
Can you advise how I can get just a match or non match for the whole value of 1-12-123-12345-1234?
I should mention that these blocks of numbers will stay the same & also the hyphens, it's just the numbers that may change to other numbers from 0-9.
Appreciate your help.
Is your text in cells? If so...Originally Posted by noboffinme
What cells?
Are there more than one of these numbers per cell?
Where did you want the outputted values to go to... if there is only one per cell? if there are more than one per cell?
Hi Rick,
The values are in one Cell each in a worksheet.
I have a list of values, some numbers, some text in a column and I want to loop through the column & find the values that suit the REGEXP pattern.
So as the loop goes down the column, it will find matches & non matches.
Thanks
One value per cell, but does that mean the value is in a cell by itself or is it in a cell mixed in with other text?
Also, what output are you looking for (the value itself, the word "Match", something else) and where did you want that output to go to?
What I mean by one value is '1-12-123-12345-1234', this is just one long number with hyphens joining them in one cell.
The ONLY values I have in my file are numbers & hyphens in the format I've supplied ie; 1-12-123-12345-1234. If I come across a value that doesn't suit that format, I want to disregard it & go to the next value.
I'm going to do some other processing after the matching value is found so an If statement can be done to callout when there's a match, I can take that 1-12-123-12345-1234 value & apply it elsewhere.
Hope that makes sense.
Thanks
Maybe this is what you want?
there's a good site if you want to test a regex:Please Login or Register to view this content.
https://regexr.com/
I think this non-RegExp macro might be faster than a RegExp macro. This code assumes your data is in Column A and put the word "Match" in Column B ext to any number matching your pattern.
Please Login or Register to view this content.
See if this is what you wanted.
Please Login or Register to view this content.
Thanks Rick,
I've used your answer in conjunction with Leiths as I needed this to be done with a REGEX finction.
Thanks for your help!
Thanks Leith,
I've used your answer in conjunction with Ricks as I needed this to be an output in one piece.
Thanks for your help!
Yes thank you for your help jindon!
You are welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks