Forum Discussion

mouzzampk's avatar
mouzzampk
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'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]

     

dufoq3's avatar
dufoq3
Community 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
    Helper I
    2 years ago

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

    • dufoq3's avatar
      dufoq3
      Community Champion
      2 years ago

      You're welcome 😉

    • dufoq3's avatar
      dufoq3
      Community Champion
      2 years ago

      If you want to check how every part of record works - remove this [c] at the end and expand the record

      • mouzzampk's avatar
        mouzzampk
        Helper I
        2 years ago

        You are great, thank you. This is extremely helpful.