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.....
-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
B4R Question How to read data from a matrix which row and column data value is given..
- Thread starter embedded
- Start date
-
- Tags
- b4r sd card esp32
- Similar Threads Similar Threads
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"
it is just a first look from my understanding
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"
it is just a first look from my understanding
Upvote
0