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

null
    • Sean
    • 5 yrs ago
    • Reported - view

    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

  • 5 yrs agoLast active
  • 1Replies
  • 1970Views