Loading

Problem with separating the columns in csv file

Nel

12y1.1k.NET

Hi,

I have this code for separating the row in coulmns in csv file I want to separate the columns where there is " to " " in " and ":" but I don't know how Cana nybody help me please?

var csvRows = []
                for (var n = 0, l = csvData.length; n < l; ++n) {
                    csvRows.push(csvData[n].join(' to '));   // unquoted CSV row

                }
                csvString = csvRows.join('\n');

}
exportCSV();

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nel12y ago
Thanks, but I get some errors when I try this Anyway, I solved it with taking only the last two columns Thanks a lot for the try
0
Jignesh Trivedi12y ago
hi,
you can use split function separating the columns in csv file text
for example
string a = "this to sdsd in dfdfd : sdsd";
var test = a.Split(new string[] { " to ", " in ", ":" }, StringSplitOptions.None);
hope this will help you.
0