Hi guys! I’m working on web form automation i.e. want to input data from excel into a web form. I have a data like this in this column: [image] and only want to input the USD and price part in the form field, leaving out the “paid” word. How do I parse it?

@ani_panch , USe a for each row activity for the input excel and inside the Loop 2. Use assign activity and provide RequiredValue= Split(CurrentRow("paid").ToString,"Paid")(1) Then you can type into the output USD 528.00 Regards,

How to parse data?

Help Studio

ppr (Peter Preuss) April 20, 2023, 10:43am 3

Regex can help:
grafik
referring to groups
grafik
after extraction, we would trim the value
[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

Topic		Replies	Views
String Text Extract Studio studio , question , activities_panel	5	525	September 19, 2022
String to integer parse Help	4	8097	October 29, 2018
String/Data Manipulation Help	12	1137	October 24, 2019
How to get only the number? Help	9	1888	July 6, 2022
Split numbers in a web extracted datatable and separate columns Help datatable , studio , data_scraping , question	6	997	April 24, 2020

Most Active Users - Yesterday
Anil_G
mukesh.singh
postwick
anjani_priya
Anelisa_Bolosha1
More details...

How to parse data?

Related Topics