Forum Discussion

Simon_Br's avatar
Simon_Br
Icon for Helper I rankHelper I
3 years ago
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 Au...
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Simon,

     

    This should work fine in a new custom column:

     

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

     

     

     

    Pete

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

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