Stripping away characters with ReplaceAll in Katalon Studio
After reading in text, it’s a common need to replace some of the text or get rid of it entirely. There may be a need to remove a comma, a dollar sign, take off a parenthesis etc.
While ReplaceAll is a simple command, there are some tricks to it, especially when using special characters like $ and ().
As an example, almost all the values on the site I’m working with have $ , and % in the number. In order to manipulate them, those characters need to be removed. It’s common that after a GetText command, there is a ReplaceAll command. Since the $ is a special character, the Groovy interpreter needs to know it’s coming by using a \ before the $
To remove a $ and , from a dollar figure, the following ReplaceAll will work.
tempText=tempText.replaceAll(“[\$,]”, “”) – The $ must have a single \ in front.
The same will be true for other characters like a line feed or return.
In the following table, the text for sales and the figure are read as a single cell, but are really separated by a line feed. When I try to print the result, it comes out as two separate lines. In order to put them together as single entry, the ReplaceAll will remove those characters and put in a hyphen.
//Replace the CR LF from a line of text so it can be printed on one line. Text will be separated by a hyphen
variable = variable.replaceAll(‘\\n|\\r’, ‘ – ‘) – Note the | between the two “escape” sequences.
Another example that’s come up is the parenthesis, as in:
(1/26/2018 – DAY 19 OF 22)
To remove the open and close, it could be done as two commands:
// The first part of the string is the import date with the opening parenthesis removed
importDate = parsedDate.replaceAll(‘\\)’, ”)
importDate = parsedDate.replaceAll(‘\\(‘, ”)
Or, using the syntax above, use the pipe | to separate the sequence
importDate = parsedDate.replaceAll(‘\\(|\\)’, ”)
Note the ” is two single quotes, rather than the opening double quote. This is the null string and means to remove the characters stated and replace them with nothing.
Another use for ReplaceAll is to get the number of results found. On several pages we display the number of results as 56 Results found.
It’s easy to get the number by using:
returnedResults = returnedResults.replaceAll(‘ Results found’, ”)
This gets rid of the space and the text, leaving just a number.
Since Katalon uses Groovy, the ReplaceAll command is very well documented, but these special cases took a little time to find yet are probably the most common to use.
Other articles of interest:
- Parsing Strings in Katalon – Split, Substring and Readlines
- Convert from String to Integer to Float and back again
- Getting the Length of a String and the Size of a List
- Filling forms with random numbers in Katalon Studio
- Using TypeIt4Me with Katalon Studio
- Waiting for Elements to appear in Katalon Studio
- Reviewing the Execution Logs of Katalon Studio
- Entering and reading text GetText, SetText and SendKeys in Katalon Studio
- Passing multiple variables to an object in Katalon Studio
- Checking to see if search results contain the search criteria