Validate the pattern in string

Question

Hi All,&nbsp;Need help in validating a specific string pattern in the field.&nbsp; Can you please advice on how can this be achieved in DAX? Thanks.Rule is as below1st - Letter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2nd - Letter/ digit3rd - Space/ digit4th - Space/ digit5th - Space/ digit/ Letter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6th - Letter/ digit7th – Letter&nbsp;

amitchandak · Answer

AOD , where is the pattern missing?
&nbsp;
In power query, we can use Text.Contains to search
https://docs.microsoft.com/en-us/powerquery-m/text-contains

Forum Discussion

Validate the pattern in string

1 Reply

Related content

Validate a String Pattern in a Column using DAX

remove string patterns within a column

Theme Validation Error

Matching the last occurrence of string pattern with DAX

Average of Average Pattern Inaccuracies