Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |