Get a substring of string after a particular character

Hi Raunak,

You can use Sub_String command. Here are the instructions/example for the command:

https://subject7.atlassian.net/wiki/spaces/SD/pages/879493583/SUB+STRING+Command

Based on the example mentioned, you can use 46-53 to produce the requested result:

Regards,
Subject7 Team

In my scenario, the string is dynamic, for eg:

String 1 : "Date: 11‑30‑2021, Complete, Due: 12‑10‑2021, $500.00, Unpaid: 3, $500.00"

String 2 : "Date: 11‑30‑2021, Pending, Due: 12‑10‑2021, $23, Unpaid: 1, $1,765"

In string 2, I would just like the 'Unpaid' amount, i.e. 1765.

If I used the Sub_string command, the index would keep on changing as the string is dynamic. One thing that remains constant is that I need to get only the 'Unpaid' amount (mentioned right at the end).

One solution that I have tried is to use the Execute_Javascript with the following piece of code:

string = Date: 11‑30‑2021, Complete, Due: 12‑10‑2021, $500.00, Unpaid: 3, $500.00

string.substring(string.lastIndexOf('$') + 1)

Although this code works fine, I am unable to figure out how to pass the variable 'string' onto the Execute_Javascript command, its being fetched from the UI in the previous step using Get_Web_Value with variable 'string'. 

Hi Raunak,

We're glad you figured out the right code. You can basically use the same variable from your Get_Web_Value command that retrieves the whole line and add it as string value in another Get_Web_Value step with Javascript Source Type.

string = "@string"

return string.substring(string.lastIndexOf('$') + 1)

Example:

Please let us know if you require any additional help.

Regards,
Subject7 Team