Forum Discussion

blazko's avatar
blazko
Icon for Helper III rankHelper III
7 years ago
Solved

extracting from string list number/letter

hi, I need ideas how can I convert string by encoding if it contains Letters or numbers.
Ex string= whf45po7, would give (l-letter, n-number): lllnnlln.
Dax or M.
Thanks in advance

Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi blazko 

    Please see the M Function code below.

     

    (String as text) =>
let
    split = Splitter.SplitTextByRepeatedLengths(1),
    splitText = split(String),
    checks = List.Transform(splitText, each if Value.Is(Value.FromText( _ ), type number) then "n" else "l"),
    combine = Text.Combine(checks) 
in
    combine

     

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi blazko 

    Please see the M Function code below.

     

    (String as text) =>
let
    split = Splitter.SplitTextByRepeatedLengths(1),
    splitText = split(String),
    checks = List.Transform(splitText, each if Value.Is(Value.FromText( _ ), type number) then "n" else "l"),
    combine = Text.Combine(checks) 
in
    combine

     

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.