Forum Discussion

mouzzampk's avatar
mouzzampk
Icon for Helper I rankHelper 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 Yes otherwise No.

 

Value            Comment

ABC1234No
BAC5678No
123X756Yes
222D897Yes
ADC1234No
ADX4325

No

Need Help
  • dufoq3's avatar
    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]

     

5 Replies

  • dufoq3's avatar
    dufoq3
    Icon for Community Champion rankCommunity Champion
    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]

     

    • mouzzampk's avatar
      mouzzampk
      Icon for Helper I rankHelper I
      2 years ago

      This is awesome, thank you. Some next level stuff 🙂