Forum Discussion

blazko's avatar
blazko
Helper 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.

Mariusz's avatar
Mariusz
Community 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.

  • blazko's avatar
    blazko
    Helper III
    7 years ago

    This is freakin' awsome! 
    Dzięki!