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,898 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, 2020 in RPA by anonymous
• 19,590 points
125 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
12,061 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,150 points
3,394 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,380 points
1,612 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
888 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
• 28,040 points
6,172 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,968 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
10,820 views