String replacement in calculated field

Question: Is it possible to perform a string replacement in a calculated field without having to perform the string manipulation on the database side? 

For example:
In the string "Hi this is a test" I would like to replace "this" with a blank space. Thus, the result would be "Hi is a test".

Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    quy.ngo

    After looking at this problem, I am still stumped. Maybe if I provided more detail, as to what I am trying to accomplish, it would help.

    I am trying to update an address field so that it can be displayed on Google Maps. When I attempt to pass "1234 Test Street" the spaces cause an issue, and I would like to replace them with "+" symbols instead. Thus, it would look like "1234+Test+Street".

    Without manipulating the data itself, is there some way to do this?

Please sign in to leave a comment.
Powered by Zendesk