Forum Engagement Daily Reports

[system]

Daily Forum Report | 25 February 2022

Top 3 Topics with Most Views

How to force close a chrome tab? made by @Rohit_Nandwani with 56 views.

Database Filter, not catching last row made by @daryl_pressley with 44 views.

How to extract Date and Usd Rates Form string using regex? made by @Ashok_kumar7 with 41 views.

Top 3 Topics with Most Replies

"Some features in your workbook may be lost if you save it as a CSV (comma delimited) manual , However, when Robot Simulate click "Save" button, did not pop up that window, Someone can help me? made by @Lori with 18 replies.

I want it to pass the result that was not found in the automatic search made by @A_Zyzz_Man with 17 replies.

How to force close a chrome tab? made by @Rohit_Nandwani with 15 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 48 posts!

@Gokul001 made 38 posts!

@Shikhar_Tandon made 24 posts!

Top 3 Most Liked Posts

This post made by @rashmi.nc received 3 likes!

Ways to extract raw data

Hi @SSavickas , You can convert files from MVN to other formats with the help of the processgold.bat command. -Convert in=Due_dates_base.mvn out=Due_dates_base.csv [dsn=…|cs=…] [query=…] [user=…] [pass=…] [queryfile=…] [sheet=…] [firstrow=…] [firstcolumn=…] [delim=…] [quote=…] [hasheader=…] [encoding=…] for example : processgold.bat -dataserver -Convert in=Cases_base.mvn out=Case.csv [mvn_to_csv] You can open a command line and type processgold.bat -dataserver -? to see different commands …

This post made by @Gokul001 received 3 likes!

How to extract Date and Usd Rates Form string using regex?

HI @Ashok_kumar7 Try this below expression Use assign activity LHS → Create an variable RHS → System.Text.RegularExpression.Regex.Match(InputString,“(?<=Indicative\sINR\srates\sas\son\s)(\d.{2}\w.{3}\d{2})”).Tostring [image] Use assign activity LHS → Create an variable (Test) RHS → System.Text.RegularExpression.Regex.Match(InputString,“USD\s(\d.+)”).Groups(1).Tostring Output → 73.04 77.56 Pass this out variable in the next assign activity to get the 77.56 Use assign activity LHS…

This post made by @lakshman received 3 likes!

UIPATH Robot and Agent Missing from Latest Community version

@benajir Welcome back to our UiPath community. UiPath Robot or Agent has new interface now and it is renamed to UiPath Assistant. You can find all earlier functions here along with some new features.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

How to extract Date and Usd Rates Form string using regex?

HI @Ashok_kumar7 Try this below expression Use assign activity LHS → Create an variable RHS → System.Text.RegularExpression.Regex.Match(InputString,“(?<=Indicative\sINR\srates\sas\son\s)(\d.{2}\w.{3}\d{2})”).Tostring [image] Use assign activity LHS → Create an variable (Test) RHS → System.Text.RegularExpression.Regex.Match(InputString,“USD\s(\d.+)”).Groups(1).Tostring Output → 73.04 77.56 Pass this out variable in the next assign activity to get the 77.56 Use assign activity LHS…

This solution provided by @lakshman received 3 likes!

UIPATH Robot and Agent Missing from Latest Community version

@benajir Welcome back to our UiPath community. UiPath Robot or Agent has new interface now and it is renamed to UiPath Assistant. You can find all earlier functions here along with some new features.

This solution provided by @Yoichi received 2 likes!

Start (re-start) processing Excel on Row# (Prompt User)

Hi, If we can know number of rows to skip, the following will work. First, read whole data with header as datatable using ReadRange activity (Let’s say dt) Then, if we want to skip 5 rows, for example, dt = dt.AsEnumerable.Skip(5).CopyToDataTable Hope this helps you. Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.