Using Modify to update partial value in field

[lfenimore]

Hello!  Can't find this exact issue in the help.  I'm looking to update part of an address record.  We have a number of street addresses (Primary Street) [Billing Street] where there is a value of "/r" which was added from a vendor file and never cleaned up.  Is there a way to use Modify to only change this part of the street address, removing the "/r" value but keeping the rest of the street address the same?  I know the fields in Demand Tools can be edited in the query view individually, and that the whole list can be exported, updated and then imported back in...but wondered if there's a way to use Modify to make it an easy change.  

Thanks!

[AnthonyValidity · Accepted solution]

Hi @lfenimore ,

Hope you're doing well!  Modify can definitely do this for you.  Does the /r have a space after it or does it trail right into the actual address?

You will use the Formula action in the Modify module.  In the Formula window, select the street address field on your object, and then put the formula in the formula editor box.  You can also use the Sample Data tab to test.

Here's the formula you would use:

StringReplace(string_value, "find_value", "replacement_value")

There's actually others you could use from spreadsheet formuls or RegEx but this is the simpliest.

Here are two formulas using the street address of the lead object, one with a space after it and one without:

StringReplace(${Street}, "/r", "")

StringReplace(${Street}, "/r", "")

Hope this helps,