Removing special character from a string in a calculated field | Community
Skip to main content
S
SuryaLa1
Level 2
September 28, 2020
Question

Removing special character from a string in a calculated field

  • September 28, 2020
  • 1 reply
  • 607 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    K
    KevinQu1
    Level 10
    September 29, 2020

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...