3 Replies Latest reply: Apr 10, 2018 6:06 PM by Val Weiland RSS

    Replace a quote (') with a blank

    Val Weiland

      How do I replace a quote (') in a text field with a space ( )? I want to lookup the city, but my lookup file contains 'O Fallon' for the city O'Fallon. I tried to use replace([City],''',' ') but that did not work. Is there an escape character?