How can I extract numbers between $ symbol using UiPath?

0 votes

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?
 

Mar 18, 2019 in RPA by avani

edited Mar 18, 2019 2,689 views

1 answer to this question.

0 votes

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:

answered Mar 18, 2019 by Pratibha
• 3,690 points

Related Questions In RPA

0 votes
0 answers

How can I extract data from multiple different PDFs from same folder using config file in uipath ??

How can I extract data from multiple ...READ MORE

Nov 4 in RPA by anonymous
• 19,570 points
29 views
0 votes
2 answers

How can I check if an element or window exists using UiPath Studio?

Element Exists help you READ MORE

answered Jun 24, 2019 in RPA by anonymous
9,781 views
0 votes
1 answer

How can I automate drag and drop in a web page using UiPath?

Hi @Manish, drag and drop task can ...READ MORE

answered Mar 20, 2019 in RPA by Anvi
• 14,110 points
2,816 views
0 votes
1 answer

Identify a Column in a database in UiPath Studio

There are two options to identify a ...READ MORE

answered Feb 11, 2019 in RPA by Sahiti
• 6,320 points
1,389 views
0 votes
1 answer

Which edition of UiPath is more suitable for individual use, Enterprise Platform or Community Edition? Why?

UiPath’s Community Edition (CE) is the version which is ...READ MORE

answered Mar 7, 2019 in RPA by Mishti
• 480 points
818 views
0 votes
1 answer

Write multiple line message using message box

@Rashmi Message Box activity in UiPath does ...READ MORE

answered Mar 4, 2019 in RPA by Abha
• 27,950 points
4,989 views
0 votes
1 answer

How to connect to MySQL database using UiPath?

Follow these simple steps to connect to ...READ MORE

answered Mar 7, 2019 in RPA by Mishti
• 480 points
5,453 views
0 votes
1 answer
+2 votes
1 answer

How can I display current date in "dd-MMM-yy" format in UiPath Studio?

Hi Shilpa, if you want to display ...READ MORE

answered Mar 18, 2019 in RPA by Pratibha
• 3,690 points
9,567 views