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	591	September 19, 2022
String/Data Manipulation Help	12	1217	October 24, 2019
How to get only the number? Help	9	2020	July 6, 2022
How to split a value after some places in excel row Help excel , studio , question	17	2269	December 1, 2019
Required expertise on Regex Activities excel , activities , question	11	510	October 10, 2023

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
Nitesh
furkan.cosan
Matias_Clemente.Arg
shubham.jadhav
Ernest_Ndifor1
MT8888
fred.bullmer
More details...

How to parse data?

Related topics