Hi,
I'm looking for an Regex instruction that can find the following pattern in a string:
00:00:00
- The 0 represents a digit from 0 to 9
- The two : signs will always be there
- Pattern will be present multiple (2) times in the same string
- Pattern will be surrounded by spaces or by horizontal tabs
- The string will contain all kinds of characters, the pattern however ALWAYS be the numbers seperated with the 2 colons.
- Only 1 of the 2 digits will always be there, the second is optional.
So it should match patterns like:
0:0:00
0:00:00
00:00:00
00:00:0
00:0:0
Op top of that, this pattern will always be present twice. So, I actually need 2 Regex instructions.
One to find the first instance, and one for the second.
I hope the query itself is clear.
If anyone knows how this can be done, please let me know!
Thanks a lot in advance.
