<< Click to Display Table of Contents >> Navigation: Actions > CSV Data > CSV Get Data Information |
This action retrieves general information about the loaded data: the number of records and the number of columns.
General
Enter the variable names to store the data. Fields can be left empty. In that case, the information will not be saved.
CSV Source
There are three options to choose from:
•Previous CSV actions - use the data opened in previous actions. If you need to load new CSV data, select the File or Text options.
•File - read data from a file. Specify the file name below and select the encoding format. The most popular encodings are available for selection.
•Text - load data directly from the specified text. You can provide the text explicitly or using variables.
Note that if you choose File or Text as the source and CSV data has been loaded previously in the previous task steps, the data will be overwritten. You can only use one set of CSV data within one task.
Skip first lines
Specify how many lines need to be ignored from the beginning of the text.
Skip empty lines
Enable this switch if you want to ignore empty lines. This parameter is enabled by default.
Skip lines starting with
Ignore comments. There is no standard for comments in CSV texts. The action will consider a line as a comment if it starts with the specified combination of characters. You can choose an option or specify your own combination.
First row is column headers
The CSV text may start with a row of column headers. Enable this switch if the first row of the data array is the header.
Editing the CSV format for loading is available if File or Text is selected as the source.
Specify the format of the CSV data: delimiter, quote character.
Note that if the "Strict delimiter" switch is not enabled, spaces are also considered delimiters. And all fields containing spaces must be enclosed in quotes.
Reset to standard format
Sets the standard parameters:
•Delimiter: Comma (,)
•Quotes: Double quotes (")
•Non-strict delimiter (spaces are also considered delimiters)
Reset to Excel format
Sets the parameters used by MS Excel by default:
•Delimiter: Semicolon (;)
•Quotes: Double quotes (")
•Strict delimiter.
Related Topics
Note: This feature is available for Business license only |