Extract substring from string with no delimiters

[mpeggielycetts]

With one of the platforms that I work with, the data extracts are often messy. I am looking to extract an ID from within a string with no delimiters present.

Example string: "Matthew(10/10/2000)FarmX1234-56789-01234DogsAndCats"

Example substring for extraction: "X1234-56789-01234"

The format is letter,number{4}-number{5}-number{5}, so not always "X" to begin with.

I presume this is RegEx but not entirely sure how to use it for this case.

Any help would be greatly appreciated, thanks!

[FinnCharlton · Accepted solution]

Hi @mpeggielycetts , here's the RegEx you need:

Hope it helps!

[DataNath]

Hey @mpeggielycetts, great that you've provided the exact pattern here - definitely one for RegEx. If you drag a RegEx tool into your workflow and put it in Parse mode, you ought to be able to use this expression to extract the necessary data:

([A-Z]\d{4}-\d{5}-\d{5})

[ShankerV]

Hi @mpeggielycetts 

One way of doing this.

 

Many thanks

Shanker V