Problem with Text.PositionOf and setting the Occurence value

[pjmorris]

Hi

I want to use this code to extract the first part of a file path:

Location1=Text.Start(Address,Text.PositionOf(Address, "\", 2))

,

However, when this runs it returns the error:

Error Message:
We cannot convert a value of type List to type Number.
Details:
    Value=List
    Type=Type

In the online documentation I found references to Occurence.Last, Occurence.First, but nothing that would allow me to set the occurence value I need.

Grateful for advice.

Regards

 

[GraH]

Hi, can't you use something like

Text.BeforeDelimiter ( Address, "\", x )

. "x" is the number of "\" at which you cut off. Only needed when it it not the first one. (base 0)

Text.BeforeDelimiter - PowerQuery M

Learn more about: Text.BeforeDelimiter

docs.microsoft.com