1 Reply Latest reply on May 16, 2009 3:15 PM by raybaudi

    Remove symbols from a text field

    dannyred

      Title

      Remove symbols from a text field

      Post

      I am trying to remove various symbols like the symbols for;' trademark', 'registered' etc from a text field.

      Data is input via csv file provided by a third party and I need to upload data to website without the symbols.

       

      Thanks for any assistance

        • 1. Re: Remove symbols from a text field
          raybaudi
            

          Hi dannyred

           

          give to your field ( where you import from the csv file ) the option of auto-enter a calculation like this:

           

          Substitute ( Self
          ;[ "©" ; "" ]
          ;[ "®" ; "" ]
          ;[ "™" ; "" ]
          )

           

          ( add a new line for every char to delete )

           

          If you have to work with Data just imported, insert the cursor into that field and use the replace with calculation:

           

          Substitute ( YourField

          ;[ "©" ; "" ]
          ;[ "®" ; "" ]
          ;[ "™" ; "" ]
          )