If, Text.trimstart and text.end not working in Formula

[villa1980]

Hi all,

 I have the below custom column I would like added, however, I am getting a 'Token ',' expected error showing.

 Any ideas what simple thing I am doing wrong 🙂

Text.TrimStart (
Text.Contains([POS PARENT DIVISION NAME],"Area ") then text.end([POS PARENT DIVISION NAME],2)
else "99" )

Thanks

Alex

[Cookistador · Accepted solution]

Hi @villa1980 

you forgot the if clause

The following code should work 🙂

Text.TrimStart(
    if Text.Contains([POS PARENT DIVISION NAME], "Area ")
    then Text.End([POS PARENT DIVISION NAME], 2)
    else "99"
)

[villa1980]

That is great tank-you so much for the reply, I knew I was missing something so simple