Bureaucrats, editor, reviewer, Administrators
13,554
edits
Changes
Jump to navigation
Jump to search
no edit summary
Go to Menu ''Database'' → ''New'', choose the ''Parsing'' tab and activate "csv" in the input format combobox.
You can set the following options for parsing CSV documents: (<font color="orange">Version 6.5.1</font>):
;Header
: activate Activate this option if the incoming CSV file has files have a headerline.
;Column Separator
: choose Choose the column separator of the CSV file (possible: <code>comma</code>, <code>semicolon</code>, <code>tab</code>).
;XML format
: choose Choose the XML format (possible: <code>verbose</code>, <code>simple</code>).
==Command Line==
Turn on the CSV Parser before parsing documents: <code>SET PARSER csv</code>.Next, use <code>[[Options#Database_options|PARSEROPT]]<br /code>Additionally, the above to set parser-specific options can be set e(<font color="orange">Version 6.5.g1</font>). Example: <code>SET PARSEROPT header=trueyes, format=simple, separator=tab <font color="orange">Version 6.5.1</fontcode>
=Text Parser=
Go to Menu ''Database'' → ''New'', choose the ''Parsing'' tab and activate "text" in the input format combobox.
You can set the following option for parsing text documents: (<font color="orange">Version 6.5.1</font>):
;Lines
: activate Activate this option to create a <line> element for each line of the input text file.
==Command Line==
Turn on the Text Parser text parser before parsing documents: <code>SET PARSER TEXT</code>.The above option is specified via the Next, use <code>[[Options#Database_options|PARSEROPT]] option</code> to set parser-specific options (<font color="orange">Version 6.5.1</font>).
Example: <code>SET PARSEROPT lines=trueyes<code>
[[Category: Internal]]
