Expand my Community achievements bar.

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.