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
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
This topic was modified 9 years, 4 months ago by 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.