I came across an interesting situation where data being imported from a csv file is not being parse into the correct attributes due to the data having commas in it. Below is a screenshot of the issue, of the data from the csv file and lastly the grid including headers from the GraphStudio “Add data file” screen.
I understand how this is tricky using delimiters as you can’t control what content will be added to the csv cells, especially if you’re importing data from a web scaping process. I’ve had the same issue in my own app so when working with Excel data I looped through each row and then each cell in each row grabbing the content as a single string object. I don’t know if this is possible with csv files and if you are importing millions of rows it might be really slow.
Hope this helps.
