Working with delimited files (CSV/TSV/Other delimited) – ACCELQ

Comprehensive support is available in ACCELQ to test delimited files (CSV/TSV/Other delimited). Multiple commands are available to read, verify or update content in fixed-width files. These commands are also helpful in the ETL testing environment.

Get row count from Delimited file

Returns the row count from a given delimited file. On error -1. Supports CSV (comma separated), TSV (tab separated), or any other custom delimiter files.

file format

field delimiter

delimited file path

file format

field delimiter (only for 'custom' format)

delimited file path 
(can be absolute path or relative path from Agent's user_data folder)

Get column count of Delimited file

Returns the column count of a row from a given delimited file. On error -1. Supports CSV (comma separated), TSV (tab separated), or any other custom delimiter files.

row number

file format

field delimiter

delimited file path

row number to get col count from (starts from 1)

file format

field delimiter (only for 'custom' format)

delimited file path 
(can be absolute path or relative path from Agent's user_data folder)

Get cell text from Delimited file

Gets the cell text from a given delimited file. Supports CSV (comma separated), TSV (tab-separated), or any other custom delimiter files.

file format

field delimiter

delimited file path


row number

column type

column

file format

field delimiter (only for 'custom' format)

delimited file path
(can be absolute path or relative path from Agent's user_data folder)

row number to get cell text from (starts from 1)

select column type from options (column number, column name)

Column number or column name based on column type parameter.
Column number starts from 1 and Column name is assumed from first row

Get row text from Delimited file

Gets the content of a row from a given delimited file. Supports CSV (comma separated), TSV (tab separated) or any other custom delimiter files.

file format

field delimiter

delimited file path


row number

file format

field delimiter (only for 'custom' format)

delimited file path
(can be absolute path or relative path from Agent's user_data folder)

row number to get text from (starts from 1)

Get row containing text in Delimited file

Finds records in a given delimited file that match the given criteria. Supports CSV (comma separated), TSV (tab separated), or any custom delimiter files.

is return all matches


file format

field delimiter

delimited file path


matching column criteria

column type

column



column value

column value match criteria

column data map type

column values match criteria

column data

Decide if all matching records, or just the first matching record
to be returned

file format

field delimiter (only for 'custom' format)

delimited file path
(can be absolute path or relative path from Agent's user_data folder)

If the match is based on one column or multiple columns

select column type from options (column number, column name)

Column number or column name based on column type parameter.
Column number starts from 1 and
Column name is assumed from first row

column value

match criteria to evaluate

Type of Map for specifying the match criteria (for multi-column)

match criteria to evaluate

data to be used for finding matching records.
Supplied as a Map (collection)

Verify cell text in Delimited file

Verifies whether the text in the specified cell is as expected in a given delimited file. Supports CSV (comma separated), TSV (tab separated), or any other custom delimiter files.

file format

field delimiter

delimited file path


row number

column type

column



expected cell text

text match criteria

failure action

file format

field delimiter (only for 'custom' format)

delimited file path
(can be absolute path or relative path from Agent's user_data folder)

row number to get cell text from (starts from 1)

select column type from options (column number, column name)

Column number or column name based on column type parameter.
Column number starts from 1 and
Column name is assumed from first row

expected cell text

match criteria to evaluate

continue or abort test case

Add a new row to Delimited file

Adds a new row to the given delimited file with matching criterion. Supports CSV (comma separated), TSV (tab-separated), or any custom delimiter files.

file format

field delimiter

delimited file path


is end of file

row number

cell values

file format

field delimiter (only for 'custom' format)

delimited file path
(can be absolute path or relative path from Agent's user_data folder)

decide if the new record goes at the end of file

row number to insert at (starts from 1)

cell values for the row, as a List (collection)

Update cell text in Delimited file

Updates the cell(s) content of a row in a given delimited file. Supports CSV (comma separated), TSV (tab-separated), or any other custom delimiter files.

column selection criteria

file format

field delimiter

delimited file path


row number

column type

column



updated value

column data map type

column data

column selection criteria

file format

field delimiter (only for 'custom' format)

delimited file path
(can be absolute path or relative path from Agent's user_data folder)

row number to update (starts from 1)

select column type from options (column number, column name)

Column number or column name based on column type parameter.
Column number starts from 1 and
Column name is assumed from first row

updated value (for single cell update)

column data

Updated data to be provided as a Map (collection).
Applicable for multi-cell update

Delete row from Delimited file

Deletes the row from a given delimited file. Supports CSV (comma separated), TSV (tab separated), or any other custom delimiter files.

file format

field delimiter

delimited file path


row number

file format

field delimiter (only for 'custom' format)

delimited file path
(can be absolute path or relative path from Agent's user_data folder)

row number to delete row from (starts from 1)