Forum Discussion
Solved
Text.End Variable Value
Hello Comunity,
Actaul i have the challange, an value to split whit a dynamic value in the M-Code in Power Query.
Per Example:
| Text | Length Number | Solution |
America30 | 2 | 30 |
| Australia300 | 3 | 300 |
| China48500 | 5 | 48500 |
| Africa4 | 4 | 4 |
| Europe1548793 | 7 | 1548793 |
How can i do that?
Simon
Hi Simon,
This should work fine in a new custom column:
Text.End([Text], [Length Number])Pete
3 Replies
Splitter.SplitTextByCharacterTransition(each not List.Contains({"0".."9"},_),{"0".."9"})([Text])
Thank for the answer.
And whit the length? ... each Text.End(_, value(length number),...
Hi Simon,
This should work fine in a new custom column:
Text.End([Text], [Length Number])Pete
