Forum Discussion

Helper I

2 years ago

Solved

Yes or No based on Numbers before or after Specific Letter

Hi, This is my table Book1.xlsx Value ABC1234 BAC5678 123X756 222D897 ADC1234 ADX4325 But how can I show if there are three numbers before or after X or D then say ...

Need Help

dufoq3

2 years ago

Hi mouzzampk,

Result:

[ a = Text.SplitAny([Value], "XD"),
  b = List.AnyTrue(List.Transform(a, (x)=> try Number.From(x) is number and Text.Length(x) = 3 otherwise false)),
  c = if b = true then "Yes" else "No"
][c]