2 Replies Latest reply on Jun 8, 2017 11:56 AM by Aad

    Substitute Microsoft Word Special Characters like “ , ‘

    Aad

      Dear Community Members,

       

      I need to push text field into DB2 database using ODBC driver.

      Most of the time text contents are cut copy from the word document and

      it contains microsoft specific character set like “ , ‘ .......

       

      I am using substitute function to achieve it.

      Substitute(text;["‘";"'"];[",";","];["”";"""])

      It fails for [""";"""] is there any other method to achieve this so that

      text can be store in Database without using substitute.

       

      Thank you

      Kamal.