The data was like: "1,00:30,2021-09-09 10:35:31.804,Fire Scout A,UAV,7,360,-1420,Find the two cars parked next to each other, isolated from the group,correct". The extra comma, in this case, being "other, isolated". The issue was that not all entries have the extra commas, and there are 30 participants with 3 logs each, each log containing 20-40 entries. I ended up using gsub() and some loops to replace the extra commas with just a space and then I was able to use the appropriate commas as the delimiters to separate them into columns.