Workfront is not recognizing my calculated expression

Question

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 Answer

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/calculated-data-expressions

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 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded