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?
You can use straight Python file handling, here is an example for a csv file:[code]file = open(‘c:\file.csv’, ‘r’)
for line in file.readlines():
data = line.split(",")
num1 = data[0]
num2 = data[1]
num3 = data[2]
print num1, num2, num3[/code]That will read a multi-line csv file. If you want to read just one line remove the loop and just do line = file.readlines(). The line.split will split the line on some character. If you wanted a tab instead do “\t”.
Travis,
Thank you, this is a great start. However, how can I have the code ignore commas that are in text surrounded by quotes (like in an address line, for instance)?
Right now, the line:
“One, two”,“Two, three”,“Three, four”
gets split into:
num1 = “One
num2 = two”
num3 = "Two
where I’d like it to be:
num1 = One, two
num2 = Two, three
num3 = Three, four
The csv module in python would be great, however we don’t include that module in Ignition. The csv module depends on other libraries that we don’t have as well. So, if you can find a lighter weight one you can use that.
