Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
This is freakin' awsome!
Dzięki!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |