StudioX only: How to properly get desired Text to save as variable? Remove spaces and SGD from $ figure?

[Chaaza (Chaaz)]

I have obtained the total cost “3,911,324.86 SGD” which comprises the value + 3 spaces + SGD. I need to use [Text to Left/Right] to convert this into a variable that contains ONLY the value. Appreciate any advice with detailed steps on how do I do that in StudioX?

My steps thus far

Add [get text] action, highlighted the field “3,911,324.86 SGD” in html browser, saved to new variable “figure”

What is next? If I write this variable “figure” into my excel cell, I will get “3,911,324.86 SGD” which is not what I want.

I want to be able to write simply “3,911,324.86” alone without any further spaces or currency.

Thank you!

[Ahmad_Rais (Ahmad)]

HI
try assign =
variable Figure= System.Text.RegularExpressions.Regex.Replace(“string_Variable”,“\D”,“”)
if white space still there can use .Trim

Or another solution

regards ahmad

[Yoichi]

Hi,

How about the following?

Regards,