We are about to switch to a new forum software. Until then we have removed the registration on this forum.
Hi! I'm making a sketch where I use excel to create a csv, but when I save it as a csv from excel it seperates the cells with ';' instead of a comma. That's actually a great idea, because then you can have sentences with comma in the cells. But processings loadTable() function uses the comma to separate instead of the semi-colon. Is it possible to change this? Can I make processing use the semi-colon instead?
Answers
I found the method in the PApplet, but I'm not sure how to use it...:
https://processing.org/reference/loadStrings_.html
https://processing.org/reference/split_.html
I tried your solution @GoToLoop, but It's a bit messy. I want a table because it has cells, so I tried to do this:
Basically just making a 2d array of the strings. But I'm getting a NullPointerException highlighting line 8.
You haven't even initialized your 2D array; merely just declared the variable.
Regardless, that's not a good move. You're better off creating some class in order to represent each row that was read from your file: https://Processing.org/examples/loadfile2.html