1 2 Previous Next 16 Replies Latest reply on Oct 20, 2015 3:31 PM by beverly

    Strip " ' " from import fields

    soco1509

      Hi

       

      I am importing .txt outputs from 3rd party all fields are prefixed and suffixed with " ' " .

       

      ie - '12345'

       

      I use the substitute function to remove the single quotes on all fields with no problems except on dates the date fields still return

      '12/05/07'

       

      help would be greatly appreciated

       

      Stephen

        1 2 Previous Next