https://community.qlik.com/t5/Talend-Studio/Problem-with-insert-having-quot-quot-character-on-my-database/m-p/2371917#M134808 <P>in tXMLmap,trie to remove the special charters.</P> Wed, 21 Feb 2018 08:47:07 GMT manodwhb 2018-02-21T08:47:07Z https://community.qlik.com/t5/Talend-Studio/Problem-with-insert-having-quot-quot-character-on-my-database/m-p/2371916#M134807 <P>Hello, I have a problem when I insert on my database simple texte, I have " ¿ " character befor the first character , why I have this ?</P><P>&nbsp;</P><P>I extract my file with a tSOAP (getting file name) and get the file with tHttpRequest (url + file name) and i extract the data with tXMLmap and insert in my DB.</P><P>&nbsp;</P><P>On tLogRow I don't have the "¿" but I have it on my DB, do you solved this ?</P> Wed, 21 Feb 2018 08:12:58 GMT https://community.qlik.com/t5/Talend-Studio/Problem-with-insert-having-quot-quot-character-on-my-database/m-p/2371916#M134807 Anonymous 2018-02-21T08:12:58Z https://community.qlik.com/t5/Talend-Studio/Problem-with-insert-having-quot-quot-character-on-my-database/m-p/2371917#M134808 <P>in tXMLmap,trie to remove the special charters.</P> Wed, 21 Feb 2018 08:47:07 GMT https://community.qlik.com/t5/Talend-Studio/Problem-with-insert-having-quot-quot-character-on-my-database/m-p/2371917#M134808 manodwhb 2018-02-21T08:47:07Z https://community.qlik.com/t5/Talend-Studio/Problem-with-insert-having-quot-quot-character-on-my-database/m-p/2371918#M134809 <P>I replacing allready the ' by space, cause in my sql query ' end the query</P> <PRE>StringHandling.EREPLACE(row2.html," ' "," ")</PRE> <P>How can I using again EREPLACE function ?</P> <P>&nbsp;</P> Wed, 21 Feb 2018 09:00:11 GMT https://community.qlik.com/t5/Talend-Studio/Problem-with-insert-having-quot-quot-character-on-my-database/m-p/2371918#M134809 Anonymous 2018-02-21T09:00:11Z