Struggling with variable trimming

[Pmm]

Hello,

I am a RPA beginner and I would like to kindly ask you for help.

My goal is to read and extract information from a web site as a string value, trim it to gain a single number, then declare it as an integer variable.
The string value provided by the selector is like this: “1of7Records:66T” or “Records:2T”

I am using .remove and .replace options to trim the string, but all I get is “1of7Records:66” or “66T” what leads to string to integer conversion failure.

Could somebody advise me how to compose the .remove/replace or regex to get a simple number value?

Thanks in advance

Peter

[Parvathy (PS Parvathy)]

Hi @Pmm

Input = "1of7Records:66T"

Output = System.Text.RegularExpressions.Regex.Match(Input,"(?<=\:)\d+").Value.Trim()

Let me know if you have any queries

Hope it helps!!

[rlgandu (Rajyalakshmi Gandu)]

@Pmm

System.Text.RegularExpressions.Regex.Replace("1of7Records:66T","\d+\s*of\d+\s*Records:","")

[Pmm]

Hello @Parvathy ,

thanks for reply, I am trying to fit your expression to my workflow, but looks like I am doing something wrong:

Extracted_string - declared string variable with the string extracted from the web site.
StringVariable - declared int32 variable to be filled with the trimmed number.

Assign activity:
StringVariable = System.Text.RegularExpressions.Regex.Match(Extracted_string,“(?<=:)\d+”).Value.Trim()

is giving me compiler error the strict on option does not allow conversion string to double

What I am doing wrong please?

P.

[Parvathy (PS Parvathy)]

Hi @Pmm

Try this:
StringVariable = CInt(System.Text.RegularExpressions.Regex.Match(Input,"(?<=\:)\d+").Value.Trim().ToString)

Regards

[ashokkarale]

@Pmm,

Here is more beginner friendly approach.

1. Let’s just take out the useful string from the whole input string using Split with : as separator.

2. Then take out the desired number using RegEx.

Output:

Thanks,
Ashok

[Pmm]

Thanks for the proposed solutions. I will test it and will let you know.

P.

[Pmm]

Thanks for the patience with me, unfortunately I getting “Directive option strict on” does not allows this error.

[Pmm]

Hello @ashokkarale ,

Could you be so kind and show me the value of the strUsefulPart please?

Thank you.

[ashokkarale]

@Pmm,

It’s strInput.Split(":")(1).Trim()

Thanks,
Ashok