AnsweredAssumed Answered

Substitute Microsoft Word Special Characters like “ , ‘

Question asked by Aad on Jun 8, 2017
Latest reply on Jun 8, 2017 by 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.

 

Outcomes