https://community.splunk.com/t5/Dashboards-Visualizations/Text-Analytics/m-p/24967#M955 <P>Hi , <BR /> I have a sample data with ~ as a seperator. The format of data is as follows.</P> <P>"Request_ID~Submitter~Create_Date~Assigned_To~Last_Modified_By~Modified_Date~Status~Short_Description~tmp_PopUp_GUID~Category~Type~Item~Summary~Pending~Escalated~Closure_Code~MSISDN~Address~First_Name~Priority~Region~Surname~tmp_RegionID~Postal_Code~Date_of_Birth~ID_Number~Password~tmp_GroupSet."</P> <P>I am unable to load data to splunk and extract the fields.I tried changing config files props and transforms but no results,I tried with IFX also.</P> <P>While loading data to splunk , the following error is generated:<BR /> "Your entry was not saved. The following error was reported: SyntaxError: JSON.parse: unexpected character"</P> <P>Can some one help me in resolving this?</P> Mon, 28 Sep 2020 13:50:12 GMT kavyatim 2020-09-28T13:50:12Z https://community.splunk.com/t5/Dashboards-Visualizations/Text-Analytics/m-p/24967#M955 <P>Hi , <BR /> I have a sample data with ~ as a seperator. The format of data is as follows.</P> <P>"Request_ID~Submitter~Create_Date~Assigned_To~Last_Modified_By~Modified_Date~Status~Short_Description~tmp_PopUp_GUID~Category~Type~Item~Summary~Pending~Escalated~Closure_Code~MSISDN~Address~First_Name~Priority~Region~Surname~tmp_RegionID~Postal_Code~Date_of_Birth~ID_Number~Password~tmp_GroupSet."</P> <P>I am unable to load data to splunk and extract the fields.I tried changing config files props and transforms but no results,I tried with IFX also.</P> <P>While loading data to splunk , the following error is generated:<BR /> "Your entry was not saved. The following error was reported: SyntaxError: JSON.parse: unexpected character"</P> <P>Can some one help me in resolving this?</P> Mon, 28 Sep 2020 13:50:12 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Text-Analytics/m-p/24967#M955 kavyatim 2020-09-28T13:50:12Z https://community.splunk.com/t5/Dashboards-Visualizations/Text-Analytics/m-p/24968#M956 <P>So if I understand you correctly you have regular CSV-formatted data with "~" as a delimiter. You could simply use DELIMS in transforms.conf:</P> <PRE><CODE>[getmyfields] DELIMS = "~" FIELDS = "field1", "field2", "field3", ... </CODE></PRE> <P>(change FIELDS to the fields in your specific dataset - Request_ID, Submitter, Create_Date and so on)</P> <P>Then in props.conf:</P> <PRE><CODE>[yoursourcetype] REPORT-myfields = getmyfields </CODE></PRE> Mon, 28 Sep 2020 13:50:15 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Text-Analytics/m-p/24968#M956 Ayn 2020-09-28T13:50:15Z