Import of CSV-File

SupportCommunity FPScript Import of CSV-File

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Autor
    Beiträge
  • #12456

    Hello,

    I have a problem to import a csv and copy the data to a datamatrix. Following code works:

    csv1 = ChooseFile(” “, “CSV_1″,”C:\Users\labor\Documents\Flexpro\I-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.

    #8133

    Hello,

    I have a problem to import a csv and copy the data to a datamatrix. Following code works:

    csv1 = ChooseFile(” “, “CSV_1″,”C:\Users\labor\Documents\Flexpro\I-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.

    #8752
    Bernhard KantzBernhard Kantz
    Moderator

    The 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.

    support@weisang.com

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Du musst angemeldet sein, um auf dieses Thema antworten zu können.