The Advanced Editor $-$ Text Functions in M

We can view and modify the code created from our drag$-$and$-$drop steps using the Advanced Query Editor. This is a great way to learn how both simple and complex functions are written.

Use the Advanced Query Editor to explore the code from the exercises in this course. Which Power Query M functions are used to extract the first or last characters from a text string?

Text.First$()$ & Text.Last$()$

Text.Left$()$ & Text.Right$()$

Text.Start$()$ & Text.End$()$

None of the above

Scroll down for more