Workfront Fusion remove spaces from field | Community
Skip to main content
Level 2
September 9, 2025
Solved

Workfront Fusion remove spaces from field

  • September 9, 2025
  • 1 reply
  • 403 views

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?

Best answer by lgaertner

Hello NCorver,

 

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

 

 

Regards

Lars

 

1 reply

lgaertner
lgaertnerAccepted solution
Level 9
September 9, 2025

Hello NCorver,

 

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

 

 

Regards

Lars

 

Level 2
September 10, 2025

Hi lgeartner,

 

Works like a charm, thank you!