This site requires JavaScript to be enabled


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
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

Error using CALC function. How get the length from a String?

I am trying get the length from a String in a buffer or attribute from TestCaseDesign.
I was using this function: {CALC[LEN("""{B[Buffer]}""")]} and it's worked for me in the begins, but it is not working with length above 150 characters.

Message error: Error during evaluation of the expression 'LEN("...")' with MS-Excel.
I tryed {CALC[LEN("{B[Buffer]}")]} and {CALC[LEN(""""{B[Buffer]}"""")]}... The same error! 

I need get the length from bigger Strings, 300, 400 characters.

Another way to help me, would be a way to do the same that "split" in Java.
I have a big String, like this: "Value 1;Value2;Value3....Value50;Value51"
I need split, for use each value at a time. With the Length i can do it! Have another way to do this?

0 0

Johannes Zwart

Created: 2017-10-03 14:31:46

Hi Davi, did you find an answer to your question yet?

I tried to reproduce your problem, but it turns out that on my machine, CALC works fine with long strings (200+ characters). However, when I have a special character (like ") in the buffer, CALC fails. Does your buffer perhaps contain any such characters?

Kind regards,

Johannes Zwart


Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial