Forum Discussion
Solved
Use Text.Length to extract certain length of the text string
Hi all, Can I have help on this one. So I'm try to extract certain lenght text string based on the length of the text string in column and minus certain lengh. Example like this: = Table.Transfo...
= Table.TransformColumns(#"Added Custom", {{"Description1", each Text.Start(_, Text.Length(_)), type text}})
= Table.TransformColumns(#"Added Custom", {{"Description1", each Text.Start(_, Text.Length(_)), type text}})
Great! That works, thanks so much.
Interestingly, use "_" to refre to the column name, is that documented somewhere?
https://learn.microsoft.com/en-us/powerquery-m/
microsoft offical document
