How can I extract numbers between symbol using UiPath

Question

I have strings like “$6.97$6.97 $9.35$9. 35” or “$3.11$3.11 $5.99$5.99”. Now I want to extract numbers between $ symbols and display them separately. How can I do that using Uipath?
 

Answer 1

Hi Avani, you can extract the numbers from these strings using Split function of String variable. In UiPath, first use Assign activity to assign the string "$6.97$6.97 $9.35$9. 35" to Price variable. Now use Price.Split({"$"}, StringSplitOptions.None)(1) to split the string and extract the first price value i.e. 6.97. Refer to the following screenshot to understand better: