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?
