Text.End Variable Value

[Simon_Br]

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

[BA_Pete · Accepted solution]

Hi Simon,

This should work fine in a new custom column:

Text.End([Text], [Length Number])

Pete

[Simon_Br]

Thank for the answer.

And whit the length? ... each Text.End(_, value(length number),... 

[wdx223_Daniel]

Splitter.SplitTextByCharacterTransition(each not List.Contains({"0".."9"},_),{"0".."9"})([Text])