convert log csv file to user-friendly csv and json file
-
original csv file
[TsDigitalMultiMeterViewer Ver.11.4.0 : [OWON B35/B35T (Bluetooth2.0)] : Date 2021/05/05 16:11:45],test Fig,test Meter Title Elapsed time | Main Value | Mode | Date Time 0:00'00"12 , DC , 356.80 , mV , , 2021/05/05 15:46:57, 0:00'00"64 , DC , 355.90 , mV , , 2021/05/05 15:46:57,
-
output csv file for main data
Elapsed time,Elapsed sec,Mode,Main Value,Unit,Mode,Date Time 0:00:00.12,0.12,DC,356.80,mV,,2021/05/05 15:46:57, 0:00:00.64,0.64,DC,355.90,mV,,2021/05/05 15:46:57,
- remove blank
- change date format from
hh:mm'ss"uuu
tohh:mm:ss.uuu
- add
Elapsed sec
field
-
output json file for meta data
{ "Version": "TsDigitalMultiMeterViewer Ver.11.4.0", "Meter": "OWON B35/B35T (Bluetooth2.0)", "Save Date": "2021/05/05 16:11:45", "Fig Title": "test Fig", "Meter Title": "test Meter Title" }
- Open this page in github pages and just drag&drop
.csv
file into browser- or clone this repository and open
index.html
locally
- or clone this repository and open
- Only tested on voltage & tempreture meter logfile.