B4R Question How to read data from a matrix which row and column data value is given..

embedded

Active Member
Licensed User
Longtime User
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.....
 

Attachments

  • coww_parameter.JPG
    coww_parameter.JPG
    385.1 KB · Views: 131
  • WhatsApp Image 2023-06-08 at 20.25.29.jpeg
    WhatsApp Image 2023-06-08 at 20.25.29.jpeg
    191.1 KB · Views: 130
  • coww.rar
    646 bytes · Views: 127

teddybear

Well-Known Member
Licensed User
Don't understand what is the data which has been on the junction point of row and column value
 
Upvote 0

candide

Active Member
Licensed User
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
 
Upvote 0
Top