Finding+Extracting certain set of characters (16 digits, starting with 20) of column

[Dominik]

Dear all,

would be great if someone can help me out - I am looking now since forever for a solution on this:

I have data table and there is one column containing basically just any kind of text.

Within this text there might (or sometimes might not) be a certain character set (ticket numbers) - e.g.:  2018022801000052

These character sets are always starting with "20", and will always have a length of 16 digits.

(sometimes there is a # in front of it, sometimes not. so basically this won't help)

Now I would like to extract those numbers to a new column.

Does anyone out there have an idea how to solve this issue?

Cheers, Dominik

[Greg_Deckler · Accepted solution]

How about some DAX like:

Column 3 = IF(FIND("20",[Column1],1,FALSE()) && NOT(ISERROR(VALUE(MID([Column1],[Column]+15,1)))),MID([Column1],FIND("20",[Column1],1),16),BLANK())

Probably not foolproof but checks to see if "20" is in the text and also whether the 16th character after that is a number and if so does the extract.