Forum Discussion
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.TransformColumns(#"Added Custom", {{"Description1", each Text.Start(_, Text.Length([Description1])), type text}})
But I'm getting error like this:
Can anyone shed any light on this please. Thanks in advance.
= Table.TransformColumns(#"Added Custom", {{"Description1", each Text.Start(_, Text.Length(_)), type text}})
4 Replies
= 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
