Extract data from a string when seperated by a dash "-"

[joesofine10]

Here is an example:  

Excess 002-0832 - L/C: 002-0949

the pattern will always be 3 numbers, dash, 4 numbers:  xxx-yyyy;  I would like to extract all instances of xxx-yyyy

[apathetichell · Accepted solution]

 

assuming there are multiple row and an unknown quantity in each row...

record id.

regex tool - tokenize split to rows.

(\d{3}-\d{4})

[joesofine10]

BRILLIANT!!!  thank you!