Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Removing special character from a string in a calculated field

Avatar

Level 3

I am trying to add a calculated field that removes dashes from another field value, I was thinking it would be just as straightforward as:

REPLACE(FIELD,"-","")

But doesn't seam to work. It does replace the dashes with a letter or a space when the same is added as the third string:

REPLACE(FIELD,"-","a")

REPLACE(FIELD,"-"," ")

I feel like I am missing something really simple here, any suggestions?

1 Reply

Avatar

Level 10

I wish Workfront had some idea of string filtering (like GREP) and/or simple Excel-like input restriction (MMDDYY, #,###.##, etc.) syntax. That way certain formats could be enforced.