topic Re: tAccessOutput(Access) with comma in field value in Talend Studio

tAccessOutput(Access) with comma in field value

Si4 — Mon, 08 Jun 2020 15:19:03 GMT

This componant seems to be giving me grief. I am constantly getting index violation warnings when writing to access unless I remove the commas.
I am unsure how to "escape" those commas.

For example value:cn=one,ou=two

causes issues

Try escaping with \, - no change

Try enclosing with quotes "\"" works except the quotes are written to the database

Is this possible?

Re: tAccessOutput(Access) with comma in field value

ppatel — Fri, 03 Jun 2022 04:45:56 GMT

Hi,

Would you please check if you've configured the component as mentioned in the Talend help document: https://help.talend.com/r/en-US/7.3/access/taccessoutput

For now, I am sharing the help document for Talend version 7.3 but based on your Talend version you can select the version and go through the document.

Regards,

Pooja Patel