Use Text.Length to extract certain length of the text string

[JZhang74]

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.

[wdx223_Daniel · Accepted solution]

= Table.TransformColumns(#"Added Custom", {{"Description1", each Text.Start(_, Text.Length(_)), type text}})

[JZhang74]

Interestingly, use "_" to refre to the column name, is that documented somewhere?

[wdx223_Daniel]

https://learn.microsoft.com/en-us/powerquery-m/

microsoft offical document

[JZhang74]

Great! That works, thanks so much.