bind grid to csv data

[joshParticipant]

Hi community,
I have a csv file that was poorly formatted from original source.
for instance,at some point it contains a sequence of three commas following each other so the system would assume it for a delimiter and hence the resulting grid does not align the fields correctly.
here is a sample data from the csv
`joshua,peter,amos,,alexander,,,hamon,jairus,rogers,,david,
is there a way the grid sytstem can eliminate this or remove the extra commas?
and I would want it to skip the header row as well when writing the grid.
your assistance will be much appreciated

[DimitarParticipant]

Hello josh,

The comma is the delimiter in CSV data and you would have to remove the extra ones if you wish your grid to be loaded correctly.

And could you, please, clarify your second query, about skipping the header row?

Best Regards,
Dimitar

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

[joshParticipant]

Hi Dimitar,
My second question is I want to skip the first row when writing to grid as this is the header row of the csv.

[DimitarParticipant]

Hi josh,

When loading the data through data adapter, you can modify the loaded records in the beforeLoadComplete callback function (in this case – remove the first record). For more information, please refer to the jqxDataAdapter documentation.

Best Regards,
Dimitar

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

[Author]

Posts