So I’m working with uploading CSV files, and I’m trying to find a way to split a string by commas. The problem is, when my CSV comes back, each item is just one long string, with each data variable being separated by a string. Inside each variable, a string could contain a comma. So how do I delineate which comma I would need to separate by? For example, when console logging a file, I’ll get a response like this:
So as you can see, each item comes back as one long string. When I break it down by each item in the array it looks like this:
(when there are multiple commas in a row, it just means that the field is empty)
Is there a way to maybe change the separator that is being used when the csv file is being read? Or how do I go about dictating the correct comma to separate by?