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.

line-feed

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

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:

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments
  • How To Disable the Quicken Registration Prompt (15)
    • Charlie Fellenbaum: Yay, thanks, and that worked for Quicken 2006 as well.
    • Ken: This didn’t work for me. I have 2006. I installed on a new laptop. I must have registered before, don’t remember. I tried to register this time, but got an error message. I’d rather not registered, though. I use...
    • Neil Murphy: I discovered that early on. I’m using 2001.
    • Jeremy: Thank you so so so much. I am still using Quicken 2010 because Intuit didn’t want to properly support users abroad anymore (never mind that they only link to US banks for transaction downloads; they didn’t want my...
    • Richard: I have Quicken 2016 Home & Business and when I use Shift + CTRL I can’t see any Tools option; All I can see is the original menu items of File & About. Might you be able to offer any advice?
  • Quasi Performance/Load Testing with Katalon Studio (1)
    • Anthony: I have done this with 100 plus machines at the same time and it worked well and provided some useful feedback.
  • A Try Catch example in Katalon Studio (3)
    • Venkatesh: Hi Don Pedro Can you share me sample project ….which consist of basic to advanced stuff…If your github or gitlab url aso present please share… As I am beginer to this I need to learn lot
    • Don Pedro: Hi Lucas. Thank you for the kind comments. I would be happy to help. Let me know how I could be of assistance.
    • Lucas: Thanks for sharing a lot of Katalon tips and tricks. The Katalon team highly appreciate your support and feedback. To make Katalon Studio better and be the best free automation solution for testing community, we wish to coordinate...
  • Securely storing passwords and login details with Set Encrypted Text in Katalon Studio (1)
    • Agus: Hi Don, Is there a way to set the encrypted text to be used in the ‘WebUI.authenticate̵ 7; method? Basically I am trying to encrypt the password that is passed to the ‘WebUI.authenticate̵ 7; method. Thank you.
  • Katalon Studio – Manual View – The start of a test script (2)
    • ben: Hello Don Great Website. Keep up the work. I learnt a lot. cheers Ben.
    • Lucas: Hi Don Pedro, Thanks for sharing a lot of great articles related to Katalon Studio and Selenium. I am Lucas from Katalon team. From your point of view, we’ve learnt alot to improve our product and add more valuable features...
  • Another success with Katalon Studio (1)
    • Mahesh Joshi: Hi Don, I just started following your blog in regards to katalon. I want to introduce katalon studio at my work we do manual testing at work at the moment. What approach I should use for proof of concept with katalon for...
  • What went wrong with Crime City? (34)
    • G D: One thing I have noticed is the awkwardness of items and the attack points and how you can earn them. I was pretty pathetic with attack points and then I played that limited time boss and got weapons that had attack points in the...
  • Disable the Quicken 2012 Registration Prompt (1)
    • Scott: Thanks this worked great and is better then having to upgrade to a subscription!