Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.