Workfront is not recognizing my calculated expression

[OmahaOmaha]

I've entered the following expression in a calculated field to remove pieces of text/numbers from another custom text field, but I get the following error message:

"This is an invalid custom expression, please try again."

LEFT({DE:Custom Field Placeholder}, 7), & MID({DE:Custom Field Placeholder}, 9, LEN({DE:Custom Field Placeholder}) -8)

Am I missing anything in particular?  Thought I entered it correctly.

[skyehansen · Accepted solution]

Hi, I think most of your functions and syntax will come from here:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/...

I'm not seeing any "MID" function, so can you please post a link to where you found that one?

Also, I don't see anything on that page about an ampersand. It's likely that you were trying to merge two bits of text together, for which you would probably want to use the CONCAT function.

[Sven-iX]

@OmahaOmaha 

• you have a comma after the LEFT expression
• instead of & you want a plus sign or, as @skyehansen recommended, use the concat function
• there is no MID function. Try the SUBSTR instead