iOS Question LoadCSV : out of bounds

[voxel]

Hi,
I use this code with B4A I don't have a problem, but with B4I I get this error when there is too much data. I don't understand, should I recode the loading of a CSV file and not use LoadCSV ?

Error occurred on line: 2791 (B4XMainPage)
-[__NSCFString substringWithRange:]: Range {5497, 18446744073709546118} out of bounds; string length 70968

Dim su As StringUtils
Dim list As List

list.Initialize
list=su.LoadCSV(File.DirLibrary, "api.csv",";")

Thanks for your help.

 

[emexes]

18446744073709546118 looks like -5498 misinterpreted as a 64 bit unsigned.

But if the problem is occurring within the LoadCSV call, then it's hard to see how your code would cause that eror.

What is the length of the file api.csv?

Is it pure ASCII, or does it contain some high-bit characters eg UTF-8?

 

[emexes]

Also, check the line termination characters:

are they consistently CR, CR+LF, or LF?

is the last line terminated?

 

[emexes]

And does the error still occur with a smaller simpler test CSV?

 

[emexes]

but with B4I I get this error when there is too much data

if m lines read ok and n lines don't,
then use a binary search to locate which line number m+1 .. n the problem begins at,
then have a very close look at that line

 

[voxel]

Thank you for your different ideas, I will look for them.

 

[voxel]

And does the error still occur with a smaller simpler test CSV?

With less data it works, that's why I think there may be a memory allocation problem with LoadCSV.

 

[Erel]

1. worth trying with: [B4X] CSVParser - CSV parser and generator
2. I don't think that it is related to the size, but rather to something invalid in the larger file.

 

[voxel]

I may have found a difference in the file, the 1st column is empty on 2 lines, is this the reason for the LoadCSV crash?

"7.5";"2023-03-22T08:48:00Z"
"7.4";"2023-03-21T13:18:00Z"
"7.5";"2023-03-21T13:18:00Z"
"7.6";"2023-03-20T13:45:00Z"
"8.0";"2023-03-20T13:45:00Z"
"7.6";"2023-03-17T10:30:00Z"
"";"2023-03-17T10:30:00Z"
"";"2023-03-16T12:21:00Z"
"7.6";"2023-03-16T12:21:00Z"
"7.4";"2023-03-15T11:30:00Z"
"7.5";"2023-03-15T11:30:00Z"
"7.6";"2023-03-14T12:42:00Z"

 

[voxel]

1. worth trying with: [B4X] CSVParser - CSV parser and generator
2. I don't think that it is related to the size, but rather to something invalid in the larger file.

I just tried CSVParser, it works great. THANKS.

 

[emexes]

the 1st column is empty on 2 lines, is this the reason for the LoadCSV crash?


"8.0";"2023-03-20T13:45:00Z"
"7.6";"2023-03-17T10:30:00Z"
"";"2023-03-17T10:30:00Z"
"";"2023-03-16T12:21:00Z"
"7.6";"2023-03-16T12:21:00Z"
"7.4";"2023-03-15T11:30:00Z"

You're the one already set up to answer that good question: remove those two lines from your test file; run your app; let us know.

 

[voxel]

You're the one already set up to answer that good question: remove those two lines from your test file; run your app; let us know.

It is difficult to modify this file because this data comes directly from an API. I no longer have a problem using CSV Parser. I think there is a bug on LoadCSV on B4i because on B4a, I have the same code and I have no problem.