If you have a Mac (and maybe can do some shell-scripting), you might look at the following attachments:
- rcCVStoVBO.sh : a shell script that can transform CSV telemetry data into VBO format ... I developed this for use with the CSV data from a RaceCapture device, but it can easily be adapted for Harry's CSV format (if any adaptation is needed, aside from the setup tables documented inside the script)
- addVideoToVBOdata.sh : a shell script that reads a .vbo file exported from the rcCSVtoVBO.sh script or from Harry's LapTimer and adds indexing data for a corresponding MP4 or AVI video file so the video can be shown by RaceLogic's Circuit Tools application
- extractCSVdata.sh : This script reads a file that contains line-item/record entries in CSV format.
If it can locate the field-header entry, it then:
- determines the fields in the source CSV file
- gets the selection of fields to be included in the results file
- ignores/reports any entries that do not have the correct number of fields
- creates a separate results file containing only the specified fields in the
order specified via the supplied/entered field list
- optionally sorts the records using a specified collection of sorting fields
- optionally, "copies forward" previous field values to produce a CSV file
where all records have no empty fields
- optionally, ignores record entries that do not have a value for any field
that is identified via a "required fields" list
- optionally, formats the data fields in the result file
- optionally, transposes data by applying formulas to specified fields
- optionally, transposes CSV header field names to new field names used in the
results file header record
- optionally, joins one or more fields into a single field (e.g., date & time)
- optionally, changes tab/space/other character to be a comma field-separator
- optionally, produces statistics about the selected records and fields
- places results in a separate file named:
<processed file name>-<results suffix>.<processed file suffix>
where "-rs <results suffix>" argument overrides the default "-selected" value
Documentation is obtained by running the script with the "-h" option. The initial versions of these scripts were used with MacOS X 10.8.5 (!), later with macOS 10.12.6 and currently with macOS 15.4.1 (on an Apple silicon Mac).
OK, being unable to attach a ".sh" file, I changed the suffixes to ".txt" ... so, to use them, you'll need to change the suffix back to ".sh" (and set the permissions to make them executable: chmod 755 <filename(s)>).