I'm trying to create a custom artwork file name based on the name of the project name entered into our system and reference number. Is there a custom expression I can use to remove the spaces in a project name or replace the spaces with an underscore?
Hi Sarah. You can use Replace to remove the spaces. The bolded section in the equation below is what I used on a project custom form that will replace spaces with an underscore. The equation would need to change a bit if you are adding the custom field to a different object or if you are just creating a calculated column in a report/view.
CONCAT(Reference Number,REPLACE(Name," ","_"))
The result for a Project A with a reference # of 123 would be: 123Project_A
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.