Parsing Strings in Katalon – Split, Substring and Readlines

Once text has been read from the page, it’s time to do something with it. In many cases, only a portion of the text is needed. For example, you may need the first part of a text string, or the last part. An example text string would be:

(1/26/2018 – DAY 19 OF 22)

The first thing is to read in the entire string into a variable:

importDate = WebUI.getText(findTestObject(‘Page_/Sales Dashboard/mtd_Sales_Dashboard_Import_Date’))

Since I want the text to the left of the hyphen, I can use that in my split command. The [0] at the end indicates I want text to the left. If I change it to [1] it would be text to the right.

parsedDate = (importDate.split(‘ – ‘)[0]) – returns (1/26/2018

parsedDate = (importDate.split(‘ – ‘)[1]) – returns DAY 19 OF 22)

From there I can manipulate the text further for my needs.

It’s also possible to break the line at the hyphen and return the resulting two strings into a List.

String[] parsedDate = importDate.split(‘ – ‘)

Since it is now a list, it can be referenced by index:

importDate = parsedDate[0] – sets importDate to the text  (1/26/2018

businessDays = parsedDate[1] – set businessDays to the text DAY 19 OF 22)

The above commands accomplish the same thing, the the first uses a single variable, the second uses a List.

The List comes in handy for something like an address. If the address is Charlotte, NC 28203, the address can be split at the comma.

String[] splitAddress=branchAddress.split(‘, ‘)

splitAddress[0] – set to Charlotte

splitAddress[1] – set to NC 28203

Instead of splitting a string at a predetermined character, you may need to split the string after a certain number of characters. For example, Branches are listed as:

Branch #123 – Charlotte, NC

Branch #140 – Huntersville, NC

Branch #005 – Rock Hill, SC

For this example, I need the Branch number. Since the first part of the string is always the same, the Substring command can be used to retrieve X number of characters. Substring starts at position 0.

branchName=tempBranchName.substring(0,11) – Returns 11 characters – Branch #005

If I only wanted the number of the branch, I would start at position 7, the space after branch and read to position 11, the end of number.

branchName=tempBranchName.substring(7,11) – Returns – #005

The .readlines() command performs parsing on multiple lines worth of text from a cell and breaks them into individual lines. An address in a textbox would be a use of .readlines()

For example, the full text would be:

1313 Mockingbird Ln

Charlotte NC, 28203

Since all of that comes in as one block of text, it needs to be parsed into lines. Once the text has been set to a variable using the GetText command, the following commands can parse through it.

branchAddress=WebUI.getText(findTestObject(‘Page_/Search Branch/Branch Profile Address’))

//Get the Branch Profile Address from the return results and parse it into multiple lines

//The address will be compared to the address from the Search Results page

branchProfileAddress = branchAddress.readLines() – Is a list consisting of the two lines of the address

branchProfileStreetAddress=branchProfileAddress[0] – Returns 1313 Mockingbird Ln

branchProfileCityState=branchProfileAddress[1] – Charlotte NC, 28203

Other articles of interest:

4 Responses to Parsing Strings in Katalon – Split, Substring and Readlines

  • Ellen says:

    Thanks for sharing!! I like your contributions to Katalon topics.

  • Anjana says:

    Hi,
    I tried the same thing to split the string, but does not work for me, Could you plz point out whats wrong
    Variable var_CampaignDuration has value “05/13/2019-06/07/2019”
    String[] parsedDateRange = (var_CampaignDuration.toString().split(‘–’))
    log.logInfo(parsedDateRange[0])
    It prints “05/13/2019-06/07/2019”, it is not splitting with ‘-‘

  • Don Pedro says:

    I’m not really sure what the difference is, but I don’t think the “-“ in the split is the same as the one in the date.

    String var_CampaignDuration = “05/13/2019-06/07/2019”
    String[] parsedDateRange = var_CampaignDuration.split(“-“)
    println parsedDateRange[0]
    println parsedDateRange[1]

  • Anjana says:

    Hey thanks for the response
    It is quite strange but initializing variable for delimiter and it worked
    String splitFormat = ‘-‘
    WebUI.println(var_CampaignDuration.toString().split(splitFormat)[0])
    WebUI.println(var_CampaignDuration.toString().split(splitFormat)[1])

Leave a Reply

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

Recent Comments
  • Output status messages and test information by writing to the Log File Viewer in Katalon Studio (4)
    • Don Pedro: That is correct. You will need to add KeywordUtil.markFailed to change the Failures count. Other commands in the library are: KeywordUtil.markPassed KeywordUtil.markFailed KeywordUtil.markError KeywordUtil.markWarning
    • Nadim: This is really helpful … the only problem when log.logFailed executed it doesn’t update the results Failures count … still show Failures: 0
  • Working with Dates and Date Formatting in Katalon Studio (7)
    • Sharma: I want to choose date from any of the 12 months but I am not abel to do the same.
  • Securely storing passwords and login details with Set Encrypted Text in Katalon Studio (2)
    • sowmya: hi can u please help me how to read data from text file in katalon studio?
  • Custom Keywords for Custom Functions (1)
    • Sarah: Thank you for this. It helped me understand these better.
  • How To Disable the Quicken Registration Prompt (26)
    • Denise Defoor: I have a Quicken SE Version 6 .. My computer crashed a few weeks ago and I finally got it up and running. Now Quicken is telling me I must registered it. What? I have had this program for 20 years. How can I disable the...
    • Greg: For me, holding the *LEFT* CTL + Shift then clicking Online, One Step Update worked. I originally tried holding the right CTL + Shift, and it didn’t work. I’m using Quicken 2006, so I don’t know if it will work...
    • Joe SR>: My monthly income is deposited into my Credit Union account. I use debit whenever possible. I write checks manually and mail them. I use Quicken 2012 off-line only. I have entered all my money and investment accounts. I...
    • Prtet: Never say never….every time I swear I will never use Quicken again, I discover that there are still no viable alternatives. Amazing that there is no decent personal finance software.
  • Parsing Strings in Katalon – Split, Substring and Readlines (4)
    • Anjana: Hey thanks for the response It is quite strange but initializing variable for delimiter and it worked String splitFormat = ‘-‘ WebUI.println(var_CampaignDura tion.toString().split(splitFor mat)[0])...
    • Don Pedro: I’m not really sure what the difference is, but I don’t think the “-“ in the split is the same as the one in the date. String var_CampaignDuration = “05/13/2019-06/07/2019&# 8221; String[] parsedDateRange =...
    • Anjana: Hi, I tried the same thing to split the string, but does not work for me, Could you plz point out whats wrong Variable var_CampaignDuration has value “05/13/2019-06/07/2019&# 8221; String[] parsedDateRange =...
  • How to Block games by Title and Tag on Steam (2)
    • Marcus861: I made an acc just to say: Same bro
    • JACK: Thanks, same just wanted to block anime games in my discover
  • Create a new and random UUID for an API call (1)
    • Anonymous: Hi ! I found this blog few weeks ago and it’s really helping me out with my tests! Thanks a lot for the Katalon tips and tricks ! Keep up the good work 🙂