Read Csv File

Read the csv file.

Read CSV data from a specified CSV file or variable.

Input

• Column Delimiter : String Argument The column delimiter to be read.

{comma}, {pipe}, {tab}, {colon}, {semicolon}, {space} are predefined characters. Enter custom delimiters between braces. Example - {##} specifies ## as the delimiter.

• Column Header : The column header to be read.

  • True - The first row of the CSV file that is considered as the column name of the data table.

  • False - The default names will be the column names of the data table.

• File Encoding : Specifies the encoding method to be read.

  • utf-8

  • utf-16

  • utf-16BE

  • utf-32

  • utf-32BE

  • us-ascii

  • iso-8859-1

  • utf-7

• Csv Content : String Argument Required The full path of the file name to be read or variable that contains CSV data.

• Row Limit : Integer Argument The row limits to be read.

Output

• Output : DataTable Variable Required Represents the output Data Table that contains the information obtained from the CSV file.
• Number of Rows : Integer Variable Represents the output variable that contains the number of rows obtained from the CSV file.