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

Change a string to lower or upper case


How to convert a string "ABCDE" to lower case or string "abcde" to upper case?

Thank you



9 0

Can Tom Özdogan

Created: 2016-06-30 23:25:39 , Updates: 1, Last Update: 2016-06-30 23:26:24

Hi Vinay,

you can use the following expressions for such a use case:

 {CALC[LOWER("ABCDE")]} or {CALC[UPPER("abcde")]}

Please beware though that CALC expressions only work in TBox starting with Tosca 9.1 and can only be used in classic TestSteps prior to that version.

Kind regards,
Can Tom Özdogan

0 0

Rakesh Kumar

Created: 2017-02-28 19:05:13

When I translate this value {CALC[UPPER("abcde")]} in TOSCA 10, it gives me 1.Value: '-2146826259'

Theja Bollini

2017-03-01 05:01:45 , Updates: 1, Last Update: 2017-03-01 05:02:49

Hi Rakesh, in Tosca 10, for TBoX you have to escape the "" in the value. The best way to escape the quotes is having 4" on either side. So try {CALC[UPPER(""""abcde"""")]} and you will get the desired output. 

0 0

Khushal Chate

Created: 2017-08-02 20:17:10

Or try three quotes

1 0

Aadhavan Diaz

Created: 2017-08-21 08:07:35

How to convert a value in buffer to upper or lower case


1 0

Laxmi Rathaur

Created: 2017-08-24 11:36:29

To convert a string in upper case/ lowercase, CALC can be used in Tbox module of Tosca 10.

If you have direct input string, use 3 set of double inverted comma's {CALC[UPPER("""Input""")]}.

But if your input string is in a buffer, then use four set of double inverted comma's  {CALC[UPPER(""""{B[Input]}"""")]}.

0 0

Jelena Jovanovic

Created: 2018-06-13 11:34:41

Thank you all for the comments, this helped me a lot. I needed to set value of a date 2 months before today, in a format e.g. 01-JAN-2000, and below is the final solution thanks to your help :)

Solution: {DATE[][-2M][dd-{CALC[UPPER(""""{AMONTH}"""")]}-yyyy]}

p.s. Having notes on historical points is quite usefull as well :)

Vijay Kurre

2018-08-02 09:24:02

Nice answers

Vijay Kurre

2018-08-02 09:24:06

Nice answers

0 0

Rumana Kauser

Created: 2018-11-30 19:58:26

How to use camel casing in tosca? For example, I would like to convert RENO to Reno

2 0

Jay French

Created: 2018-12-20 20:56:16

Use: proper

{CALC[proper("""abcde""")]}        <-- this will be 'Abcde'                 



Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial