Workfront Fusion remove spaces from field

[NCorver]

Hi,

I am trying to remove spaces from values and concat them into a new field with Fusion such that we can easily provide information. This has to be done with Fusion because some of the information is on a higher task or even project level and are custom fields, so doing this with a calculated field is not an option. For now I have 5 fields that I want to concat into one field such that:

• Field 1: 1112222
• Field 2: Collection
• Field 3: Product Description
• Field 4: Volume in ML

Combines into the field that shows: 1112222-collection-productdescription-volumeinml

I managed to create the concat and also make it lower case using the lower() function. Now I tried to use the replace function by doing replace(fieldname;" ";"") but that does not seem to work. How can I get rid of all the spaces such that the name is just one string of text?

[lgaertner · Accepted solution]

Hello NCorver,

I think you need to use the corresponding keywords for space and emptystring to make it work.

Regards

Lars

[NielsCorver]

Hi lgeartner,

Works like a charm, thank you!