Filter löschen
Filter löschen

How to locate character string in a csv file and skip it

3 Ansichten (letzte 30 Tage)
Tina Zhao
Tina Zhao am 17 Jun. 2016
Bearbeitet: Walter Roberson am 17 Jun. 2016
I'm reading a csv file, however, somewhere in the file, (unknown location, so the row, column for this character), an unrecognizable or non-numeric character string (for example, Fö£a´]=Õê´‡X¼Ð, which is generated by binary to ascii conversion process) will be encountered, so the format specification in textscan cannot be used (because of the unknown location). So I saw the error in the following. Is there any way to use textscan or even csvread to process this kind of csv file, without compromising the speed? Many thanks.
"Mismatch between file and format string.
Trouble reading 'Numeric' field from file (row number 1096608,
field number 110) ==> Fö£a´]=Õê´‡X¼Ð , , , ,$, , , , , , , , ,
, , , , , , , , , , , , , , , \n
Error in LoadDumpDataCSV_V2 (line 53)
dataArray = textscan(fileID, formatSpec, 'Delimiter',
',', 'MultipleDelimsAsOne', false, 'ReturnOnError',
  4 Kommentare
Guillaume am 17 Jun. 2016
If the file starts as binary, why not parse it as such rather than have an expensive binary to text conversion and an expensive parsing afterward?
Tina Zhao
Tina Zhao am 17 Jun. 2016
Bearbeitet: Walter Roberson am 17 Jun. 2016
Thanks for everyone's response. The file is pretty big, this is our internal tool data, up to a few hundred MB data.
I searched on others' post, and found this can solve my problem:
a2 = textscan(fileID, formatSpec, 'Delimiter', ',','HeaderLines',1,'CollectOutput',1);
% dataArray = textscan(fileID, '%f');
dataArray = [dataArray;a2{1}];
I think it skipped the whole row if there's a character, so my bad data can be much smaller.

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by