https://community.splunk.com/t5/Getting-Data-In/Escape-special-characters-in-DB-Connect/m-p/573022#M101372 <P>Pulling database events with Splunk DB Connect I noticed that:<BR /><BR />1. New (non-existing) fields are created<BR />2. text fields containing special characters&nbsp; are cut<BR /><BR />The only reason I have been able to identify consists in the presence of special characters of the kind:<BR />( ) " :<BR />... in fields like "SQL _Text", that by their nature can contain quotes, brackets and else.</P><P>How can I escape these problem-causing characters ?<BR />This done inside Splunk - and not anywhere on the DB side, or the SQL command for pulling records.<BR /><BR />What are the characters that must be escaped?<BR />Asking the later because when working&nbsp;in a previous project with ingesting events from a DB to Splunk via TCP Data Input, I noticed that not all special characters where causing same problem as above - but only few of them.<BR /><BR />best regards<BR />Altin&nbsp;</P> Fri, 29 Oct 2021 19:25:41 GMT altink 2021-10-29T19:25:41Z https://community.splunk.com/t5/Getting-Data-In/Escape-special-characters-in-DB-Connect/m-p/573022#M101372 <P>Pulling database events with Splunk DB Connect I noticed that:<BR /><BR />1. New (non-existing) fields are created<BR />2. text fields containing special characters&nbsp; are cut<BR /><BR />The only reason I have been able to identify consists in the presence of special characters of the kind:<BR />( ) " :<BR />... in fields like "SQL _Text", that by their nature can contain quotes, brackets and else.</P><P>How can I escape these problem-causing characters ?<BR />This done inside Splunk - and not anywhere on the DB side, or the SQL command for pulling records.<BR /><BR />What are the characters that must be escaped?<BR />Asking the later because when working&nbsp;in a previous project with ingesting events from a DB to Splunk via TCP Data Input, I noticed that not all special characters where causing same problem as above - but only few of them.<BR /><BR />best regards<BR />Altin&nbsp;</P> Fri, 29 Oct 2021 19:25:41 GMT https://community.splunk.com/t5/Getting-Data-In/Escape-special-characters-in-DB-Connect/m-p/573022#M101372 altink 2021-10-29T19:25:41Z