Topic
Import of CSV-File
- This topic has 2 replies and 2 voices and was last updated 14 years, 6 months ago ago by Florian Bleymann.
-
AuthorPosts
-
29.10.2010 at 19:15 #33157Florian BleymannParticipant
Hello,
I have a problem to import a csv and copy the data to a datamatrix. Following code works:
csv1 = ChooseFile(” “, “CSV_1″,”C:UserslaborDocumentsFlexproI-U-Messung – CSV_Merge”, _
“Datendateien (*.csv; *.xls; *.xlsx)|*.csv;|Textdateien (*.txt; *.asc)|*.txt; *.asc*.xls; *.xlsx|Alle Dateien (*.*)|*.*||”)ReadTextFile(csv1, 1, 0, 0, 6, True,TYPE_FLOATINGPOINT64, True, “;”,False)
The csv is read in but the data arranged in 7 columns is only visible in the window “Überwachung”. How do I get the csv data in a correspondent datamatrix for further data manipulation?
Thanks.
29.10.2010 at 19:15 #33159Florian BleymannParticipantHello,
I have a problem to import a csv and copy the data to a datamatrix. Following code works:
csv1 = ChooseFile(” “, “CSV_1″,”C:UserslaborDocumentsFlexproI-U-Messung – CSV_Merge”, _
“Datendateien (*.csv; *.xls; *.xlsx)|*.csv;|Textdateien (*.txt; *.asc)|*.txt; *.asc*.xls; *.xlsx|Alle Dateien (*.*)|*.*||”)ReadTextFile(csv1, 1, 0, 0, 6, True,TYPE_FLOATINGPOINT64, True, “;”,False)
The csv is read in but the data arranged in 7 columns is only visible in the window “Überwachung”. How do I get the csv data in a correspondent datamatrix for further data manipulation?
Thanks.
29.10.2010 at 19:21 #33158Bernhard KantzParticipantThe FPScript formula returns the imported values. Either you can manipulate the data in the same FPScript formula or you can create a second FPScript formula and access the first formula using the name of the first formula.
-
AuthorPosts
- You must be logged in to reply to this topic.