This site requires JavaScript to be enabled
IE BUMPER

Logo

Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
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).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
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

Removing just one quotation mark from a .csv file for row by row comparison

Hi everyone,

I am having an issue when running the row by row comparison in Tosca BI where I am comparing a database to a .csv file. 

The .csv file is using quotation marks to indicate each column's values and therefore I am using Trim[""""]  to get rid off the quotation marks so it can be compared with the values in the database. However, I have a value that ends with quotation marks (and therefore in the .csv file it has two quotation marks at the end). Both of these quotation marks get removed and I get an error that the values are not matching.

I have also tried TrimStart[""""] and TrimEnd[""""], however I get the same result.

Is there any way to just remove the last quotation mark and leave the other?

Thank you!

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial