I am facing an issue in which there is a csv file (attached below) stored in SD CARD which is connected with my ESP32. Data has been given in row and column which screenshot is attached in picture. the row value like "7.8" comes in string form from sensor & similarly column value like "3.1" also comes from sensor. now i have to fetch data which has been on the junction point of row and column value as marked in picture. kindly help.....
in your csv file you have 77 columns and 27 rows and data are a string : it don't help because B4R work with array single dimension and don't like strings !
i think it should be good to optimize your file at start:
- each data can be converted from string like "14.6" to equivalent in float format like "14.6"
- and new data can be stored in several files corresponding at each column
=> for 77 columns you will have 77 files with name like input value
=> in each file you will have 27 values in float format corresponding at row values
=> each value will be original value but in float format "14.6"