Hi, everyone. I would like to use FPMI to open a .csv (comma delimited) or a .txt (tab delimited) file and parse each element into a text box on a FPMI window.
Imagine the simplest case: A file called Numbers.csv has thefollowing text: 1,2,3
I want the user to open the file with the “fpmi.file.openFile()” command followed by the “fpmi.file.readFileAsString(path)” command. But then I want the 1 to go into one textbox on the window, the 2 to go into another, and the 3 to go into a third textbox.
It might get a little more complicated when we have multi-line CSV files with quotation marks, embedded commas, etc. (see attached files as examples)
I also want to be able to do the same with a tab delimited file.
How should this best be done? Assume I have more than enough discrete text boxes to hold all of the entries in the file. Perhaps there’s a magic parsing command in Python?