This site requires JavaScript to be enabled

IncidentLookup using list
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

Steer CSV files with TBox DB Expert Module

Steering a CSV file in TBox without any classic modules like “Excel Engine” or “TextStream Engine”.


You must steer a CSV file named “test.csv” but can not use any classic engines.


! This will only work with Tosca v11.3+ at the time of writing !

You could use the “TBox DB Expert module” and you must have to deliver in the connection string the folder where your file is, where at the SQL Statement the filename itself is needed. 

Please have a look at the example parameter:
Open Connection: Select
Connection string: "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=C:\temp\;Extensions=asc,csv,tab,txt;"
Driver: Generic ODBC
SQL Statement: SELECT * FROM [test.csv]


Now you can steer in your csv file and verify/buffer/… values like in a table.


Change the delimiter

If you want to change the delimiter, then you must create a file named "Schema.ini" which must exist in the same folder as the to-be-steered csv file.

Example with semicolon


Example with tab



- It is only one delimiter per file possible
- Tables have a max size of 255x255 fields
- One fieldname can only have a max. length of 64 characters
- field widths are limited to 32766 characters
- the file is limited to 65000 bytes
- the file can only be opened by one user

In-depth details
Textfile format:


0 0

Sujata Maske

Created: 2018-09-17 12:32:36

Thank you for the example and approach but getting error as


"Error while connecting to data base. Please check if your Connection string is valid."

Sujata Maske

2018-09-17 10:39:32

we have 11.1 installed on machine but :(

Dominik Duhs

2018-09-17 14:35:47 , Updates: 1, Last Update: 2019-08-30 08:43:43

Did you also have installed at least Patch07 for Tosca v11.1?

It will only work with Tosca 11.3 onward.

Paul Revilla

2019-11-14 23:04:35

i had this issue and solved it by installing a 64version of ODBC on the DSN i use

0 0

Sujata Maske

Created: 2018-10-04 06:44:33

Dominik I have patch08 installed on machine now. can you help me with code/script please with attachement .

Thank you in advance.

1 0

Dominik Duhs

Created: 2018-10-04 12:53:16

Please open an incident if you need assistance. Then we can have a look at it.

Sujata Maske

2018-10-11 05:59:33

Issue has been resolved now for querying csv file. Thank you for the support Dominik :)




0 0

Melody Monterona

Created: 2018-12-11 09:09:07



May I know how the issue "Error while connecting to data base. Please check if your Connection string is valid." was resolved? I have Tosca11.3 P9 installed. Thank you.

0 0

Shilpa Munukuru

Created: 2020-09-14 20:19:51


I have one doubt in CSV file .

i have followed teh same steps which has mentioned above but my concern is how to valiadte row values in CSV table.

since i have CNUM="1234" and TotalAmount="4562"

Now i have to verify in CSV file has these values or not and not sure these data contains in which Row ?

can any one please help me.