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

Question

Hi all,&nbsp;I have the below custom column I would like added, however, I am getting a 'Token ',' expected error showing.&nbsp;Any ideas what simple thing I am doing wrong 🙂&nbsp;Text.TrimStart (Text.Contains([POS PARENT DIVISION NAME],"Area ") then text.end([POS PARENT DIVISION NAME],2)else "99" )&nbsp;ThanksAlex

cookistador · Accepted Answer

Hi&nbsp;villa1980&nbsp;you forgot the if clause&nbsp;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"
)&nbsp;

Forum Discussion

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

2 Replies

Related content

Text.End Function Returning Blanks In PowerQuery

Text.End Variable Value

Using 'IF' and 'Text.End' in the same function

MCP not working

Dataflow DB2 Text.End Issue