I have 3 columns in my Power Query that contains some values of text & numbers. I wanted to split it by number of character to extract the text from numbers. I have done this one after the other, i want to know if there is an easy step I can apply to the column at once using M query.
Thanks
Use List.Accumulate
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(
"NY/LDQQhDEN74Yws8iNQxFYwmv7b2AkJJ4uYPDvP0xbG/rXeNiTEwd/z7U8j6IoJQyl0QTydDa+
/e4YODE5nQGNAZ9CbYOmFiWQKacJuDEM4ITqrR8EEttPxo5XuhdBa+FDzLuzT1OCW8ca38fIsRpTN
44J07BSbsKJ60N4/", BinaryEncoding.Base64), Compression.Deflate)),
type table [Value, Wage, #"Release Clause"]),
tbl = List.Accumulate({"Value", "Wage","Release Clause"}, Source, (s,c)=>
Table.SplitColumn(s, c, Splitter.SplitTextByCharacterTransition({"0".."9","."}, (x) =>
not List.Contains({"0".."9", "."}, x)), {c, c & ".1"}))
in
tbl
Here is my advanced editor, How can I use it?
It's showing "Token Identifier Expected"