mbh
05/17/2023, 5:10 AMfunction jsonlToArray(jsonl) {
var result = [];
var lines = listToArray(jsonl, chr(10));
for (var line in lines) {
result.append(deserializeJSON(line));
}
return result;
}
function isJSONL(content) {
// Split the file contents by line
lines = listToArray(content, chr(10));
// Check that each line is a valid JSON string
for (i = 1; i <= arrayLen(lines); i++) {
if (!isJSON( lines[i].trim() ) ) {
return false;
}
}
// If we made it this far, it's a valid JSONL file
return true;
}
zackster
05/17/2023, 6:45 AMadam.euans
05/17/2023, 8:33 AMarray = deserializeJson('[' & fileRead('file.jsonl').replaceAll('[\n\r]+', ',').replaceAll(',$', '') & ']');