0
    
          
  
  
    
            Find and replace
After importing data, I'm seeing content in several fields where an unusual character lives where an apostrophe should be. For example, this song title: Climb EvÕry Mountain should be Climb Ev'ry Mountain. I am trying to use the Update Multiple Records to replace this, but I cannot seem to get the replace text syntax correct. This is occuring in several fields in multiple tables. One field is "Selection Title" -- can you provide the syntax needed in that field? Thank you.
1 reply
- 
  
When you select the field you want to change in Update Multiple Records, select Assign calculated value and use this as the formula...
replace(YourField, "Õ", "'")
 
Content aside
- 6 yrs agoLast active
 - 1Replies
 - 2007Views
 
