We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Split issue in ExecuteQueryCSV using .net

Accepted answer
6
Views
4
Comments
edited Nov 8, 2016 7:58AM in UI Extensibility 4 comments

Content

Hi, 

I have executed query by using ExecuteQueryCSV  function. but when it will return the result the columns are splitting by ';'. so i need to take each column value by calling the function of Split(';'). The issue is here if the column values itself contain the ';', I couldnt split the column by ';'. Please help on this. Thanks.

Result of Query: Name;<div style='border:1px;'>Text</div>;DateTime

Code Snippet

              CSVTable[] acctInfocsvTables = ExecuteQueryCSV(SQL);
  _row["Name"] = acctInfocsvTables[0].Rows[i].Split(';')[1].ToString();
_row["Message"] = acctInfocsvTables[0].Rows[i].Split(';')[2].ToString(); 
        

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!