how to format complete grid data extracted

[Raj DesaiParticipant]

Hi Team,

var data = \$("#jqxgrid").jqxGrid('exportdata', 'csv');
console.log(data);

By using the above code, i have taken my entire grid data in variable ‘data’. When i do console.log(data), i see this at the console….

"Number","Id","Name"
"1.00","345.00","Dimitar"
"2.00","475.00","Ivailo"
"3.00","605.00","Ashwin"

I want to ensure that i remove the double quotes which i get for each row. How do i achieve this ? Also, is it possible to remove the first column header from the variable data. Since all these rows are together present in the variable ‘data’, i am finding it difficult to do so. Please help !!!!!!

[Raj DesaiParticipant]

I want my final variable ‘data’ to look like this.

1.00,345.00,Dimitar
2.00,475.00,Ivailo
3.00,605.00,Ashwin

[Peter StoevKeymaster]

Hi Raj Desai,

It’s not possible to remove the ” when you export to CSV. The third parameter of the exportdata method is optional and determines whether to export the column’s header or not.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Raj DesaiParticipant]

I know of a function in javascript which will replace all the (double quotes “)

var data1 ='""ada""da';
var data2= data1.replace(/\"/g,'');

But this will be for string. How can i achieve it for the above data. which i guess is an array…..

[Raj DesaiParticipant]

Hi Peter,
Is it possible to remove ” when i export to any other format rather than csv ?

[Peter StoevKeymaster]

Hi Raj Desai,

I already wrote you that this is not possible to export data to CSV without double quotes. They are added by our code and they are added by design.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Raj DesaiParticipant]

Peter,
got it. i cannot see the documentation for the exportdata method is optional and determines whether to export the column’s header or not. can you please let me know how i can use it ?

[Peter StoevKeymaster]

Hi Raj Desai,

The exact sentence from my post is copy-paste from the Grid’s API about this method. You can find it there.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts