After working on this for a bit I wanted to make sure I posted this reminder for myself and others.
Regex is a very powerful tool but the syntax is almost something of an art. I needed to identify strings of numbers between two colons. The following regex should look at a string such as…
And will allow selection of:
That regex string is:
Caveats include, this requires at least two, and no more than three colons in a file, chances are, if you have a colon separated file with a lot of fields, this may not be your ideal solution but maybe its a start. If someone has a more holistic (simple) solution to parse out such files feel free to share.