Forum Engagement Daily Reports

[system]

Daily Forum Report | 22 February 2022

Top 3 Topics with Most Views

How to find URL with Regax made by @Sweety_Nagar with 51 views.

Write range from row.item made by @Rntss23 with 49 views.

How to remove rows whose index are more than 5 made by @HeartCatcher with 41 views.

Top 3 Topics with Most Replies

How to find URL with Regax made by @Sweety_Nagar with 23 replies.

I would like the bot to write to the last empty line in Excel made by @Soudios with 20 replies.

Write range from row.item made by @Rntss23 with 17 replies.

Top 3 Users Who Posted The Most

@Shikhar_Tandon made 36 posts!

@Gokul001 made 25 posts!

@nikhil.girish made 21 posts!

Top 3 Most Liked Posts

This post made by @parvathi_ayanala received 5 likes!

UiPath Community MVP 2022 announcement!

Congratulations rakesh ! I follow your channel . The way you explain with all minute details is really awesome.

This post made by @parvathi_ayanala received 5 likes!

UiPath Community MVP 2022 announcement!

Congratulations everyone!!

This post made by @liu_shubin received 4 likes!

UiPath Community MVP 2022 announcement!

Congratulations, all UiPath MVPs! UiPath MVP is an opportunity for us to learn and contribute to the community. Let’s grow together! [image]

Top 3 Most Liked Solutions

This solution provided by @nikhil.girish received 2 likes!

XLS file can be processed,

Hi @Nancy_Star Welcome to community Yes Bot can process “XLS” files too , kindly drag an excel application scope and provide full file path and carry out operations Thanks

This solution provided by @ppr received 2 likes!

UiPath Deserialize XML Multiple Data Extraction

when deserialzing the XML you will get returned a XDocument when looping over the elements we do set the typeargument to XElement for retrieving the value as done by xDoc.Root.Descendants(“faturaNo”)(0).Value we will get back a string in your screenshot you are mixing up retrieval and looping [grafik]

This solution provided by @ppr received 2 likes!

XML Help please!

Going ahead Serializing the XML: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</productVersion>] } xDoc.Descendants(xnsDefault + "productVersion").First().Value "123" xDoc.Descendants(xnsDefault + "productVers…

---

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.

[system]

Daily Forum Report | 23 February 2022

Top 3 Topics with Most Views

How to find specific string using regex made by @BHARAT_NAGAR with 61 views.

How to Date Convert "Date" to "System date" format? made by @Ashok_kumar7 with 57 views.

Excel Delete Columns from a dynamic sheet tab (Source) made by @CMB80 with 53 views.

Top 3 Topics with Most Replies

Excel Delete Columns from a dynamic sheet tab (Source) made by @CMB80 with 31 replies.

How to find specific string using regex made by @BHARAT_NAGAR with 31 replies.

Trim data made by @daryl_pressley with 22 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 39 posts!

@Shikhar_Tandon made 27 posts!

@gustavo.cervelin made 25 posts!

Top 3 Most Liked Posts

This post made by @Krollythegoalie received 6 likes!

Your feedback on UiPath Apps can earn you a certification voucher

Hello Maciej, and thank you for the opportunity to provide some feedback on UiPath Apps! 1. What integration to an automation platform are you looking forward to see in UiPath Apps and why? Action Center Integration Apps allows for the construction of beautiful interfaces, but it could benefit from Action Center. Showing a user a list of tasks assigned to them, or their group, would be very useful within an App portal homepage. Would like to see improvements around connecting to workflow …

This post made by @Vitor_Merola received 4 likes!

Your feedback on UiPath Apps can earn you a certification voucher

What integration to an automation platform are you looking forward to see in UiPath Apps and why? It would be great if we can find a plugin to integrate Uipath Apps getting data from Sharepoint list directly, without Premium connectors. Once the most of the companies have Microsoft Plataform in place, and not are working with Microsoft Power Automate to automate boring tasks. What controls are missing in UiPath Apps and how would you use this new control? As it is found in several development…

This post made by @Gokul001 received 2 likes!

How to Date Convert "Date" to "System date" format?

Or you can use this too Datetime.ParseExact(“1-Feb-2022”,“d-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MM-yyyy”) [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @gustavo.cervelin received 2 likes!

Why is this written as "=SUM(A1,B1)" in TypeB workflow?

Hi @ydash999, It’s just a different approach usign Excel formula to get the sum of two values. In this case, the formula is written from C1 to C11 because the defined range is "C1:C"+RowsCount Where RowsCount is 11. Then, it will work similar to when you drag a formula. I mean, it will consider the respective row. Are there other ways to do this without formulas? Yes… You could use a for each row activity, get column A value and column B value, covert both of them to Int32, perform the sum …

This solution provided by @THIRU_NANI received 1 likes!

How to Date Convert "Date" to "System date" format?

Hi! Try this: Cdate(DateVariable).ToString("dd-mm-yyyy") Reference: [Date1] Regards, NaNi

This solution provided by @sven.wullum received 1 likes!

Download from storage bucket - Cannot find the requested page

Solution was to install and use Chrome instead of IE11!

---

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.

[system]

Daily Forum Report | 24 February 2022

Top 3 Topics with Most Views

Merge dua datatable made by @KomunitasRPAIndonesia with 61 views.

UiPath academy employee made by @peter.coleman with 48 views.

Set Transaction Progress is not working in Production Orchestrator made by @Shivaraju with 46 views.

Top 3 Topics with Most Replies

How to write the concatenate formula in write cell in uipath made by @Bhargavi_Lokapur with 23 replies.

How to get Json Array values from json format? made by @shuklarchana001 with 20 replies.

Merge dua datatable made by @KomunitasRPAIndonesia with 16 replies.

Top 3 Users Who Posted The Most

@Shikhar_Tandon made 32 posts!

@Gokul001 made 26 posts!

@Nithinkrishna made 23 posts!

Top 3 Most Liked Posts

This post made by @Ioan-Alexandru_Csinady received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, I am new to UiPath, I have started the academy exercises and I’m looking forward to gain experience. I’m trying to get experience in order to automate different processes for myself and why not for other organizations as a freelancer and also contribute to the community with valuable info once i have the necessary experience.

This post made by @Deepak_Krishnamurthy received 2 likes!

How can I clear just 1 category from Outlook mail

Thanks @Nithinkrishna Your recommendation worked. For future reference, I just want to point out how I worked on it based on your idea. Get categories of mail: —> this_var = mail.GetCategories.ToArray() Replace string in Array: —> this_var = this_var.Select(Function(x) x.Replace(“DIST_DATA”,“Processed”)).ToArray() Then use this variable “this_var” for ‘Categories’ in the Set Outlook Mail Categories activity.

This post made by @NIVED_NAMBIAR received 2 likes!

Not to repeat number

I think u can try this logic assign a = “1225333788” Now split the string a into characters b= a.ToCharArray().Distinct Now join it again c = String.Join("",b.ToArray()) Hope this helps Mark it as solution if it helps Thanks and regards Nived N

Top 3 Most Liked Solutions

This solution provided by @RPAForEveryone received 2 likes!

Is there any way to get mails only already read without unread mails?

@THIRU_NANI @Gokul001 I think @Jihwan is trying to achieve the opposite of this feature - i.e. only find messages marked as read, not the unread ones. @Jihwan There isn’t a direct property you can use to achieve this. However, you may use the options discussed above to load all emails (e.g. first 50 including read and unread messages, uncheck both options MarAsRead and OnlyUnreadMessages) Once you have all the emails, you could iterate over each email and check its status. Unfortunately, I…

This solution provided by @nikhil.girish received 2 likes!

How can i search specific mail id in outlook and get latest unread mail

so what is your requirement you want to filter by subject or by sender name for sender name [image] “[SenderEmailAddress] = '”+your variable+"’" for subject “[Subject] = '”+your variable+"’"

This solution provided by @Gokul001 received 2 likes!

PDF Extraction one particular word to another word

Hi @Buvaneshwaran_R Try this expression Use assign activity LHS → Create an variable RHS → Sysytem.Text.RegularExpression.Regex.Match(InputString,"(?s)1\sproperty\sID(.*?)TOTAL\sINCL").Tostring.Trim Regards Gokul

---

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.

[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.

[system]

Daily Forum Report | 26 February 2022

Top 3 Topics with Most Views

Set Public URL for Orchestrator made by @Lakshay_Verma with 44 views.

Click failing if page taking time made by @Franklin_D with 39 views.

Need to differentiate selector (highlight vs highlight greyed out) made by @lynnsong986 with 38 views.

Top 3 Topics with Most Replies

Set Public URL for Orchestrator made by @Lakshay_Verma with 19 replies.

Click failing if page taking time made by @Franklin_D with 8 replies.

Select proposal in given screen made by @Aleem_Khan with 8 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 35 posts!

@Lakshay_Verma made 12 posts!

@nikhil.girish made 9 posts!

Top 3 Most Liked Posts

This post made by @nikhil.girish received 3 likes!

Click failing if page taking time

Hi @Franklin_D welcome to community !! Please try to increase the timeout and make wait for ready property as complete Thanks

This post made by @nikhil.girish received 2 likes!

Robot connected bit unlicensed

Hi @Sandeep_K can you check the machine name associated with your robot record in Orchestrator matches your actual machine/host name if that is perfect Just try to disable & then enable the license for the robot in the orchestrator platform

This post made by @Yoichi received 2 likes!

Consolidate Rows (Type String) in Data Table

Hi, Hope the following sample helps you. [img20220226-1] dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,String.Join(",",g.Select(Function(r) r("Lived Cities").ToString)),String.Join(",",g.Select(Function(r) r("Lived Countries").ToString))},False)).CopyToDataTable() Sample20220226-1.zip (2.5 KB) Regards,

Top 3 Most Liked Solutions

This solution provided by @nikhil.girish received 3 likes!

Click failing if page taking time

Hi @Franklin_D welcome to community !! Please try to increase the timeout and make wait for ready property as complete Thanks

This solution provided by @nikhil.girish received 2 likes!

Robot connected bit unlicensed

Hi @Sandeep_K can you check the machine name associated with your robot record in Orchestrator matches your actual machine/host name if that is perfect Just try to disable & then enable the license for the robot in the orchestrator platform

This solution provided by @Yoichi received 2 likes!

Consolidate Rows (Type String) in Data Table

Hi, Hope the following sample helps you. [img20220226-1] dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,String.Join(",",g.Select(Function(r) r("Lived Cities").ToString)),String.Join(",",g.Select(Function(r) r("Lived Countries").ToString))},False)).CopyToDataTable() Sample20220226-1.zip (2.5 KB) 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.

[system]

Daily Forum Report | 27 February 2022

Top 3 Topics with Most Views

How to Integrate Microsoft Teams chatbot with UiPath orchestrator made by @kirankumar.mahanthi1 with 60 views.

Force browser pages to load before getting text made by @AL1 with 57 views.

Getting error while using HTTP request made by @rajasekhar_Tandasa with 54 views.

Top 3 Topics with Most Replies

How to Integrate Microsoft Teams chatbot with UiPath orchestrator made by @kirankumar.mahanthi1 with 14 replies.

Force browser pages to load before getting text made by @AL1 with 11 replies.

Getting error while using HTTP request made by @rajasekhar_Tandasa with 8 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 25 posts!

@Shikhar_Tandon made 11 posts!

@kirankumar.mahanthi1 made 10 posts!

Top 3 Most Liked Posts

This post made by @tchnavia_marie received 5 likes!

Welcome to our Forum! Please introduce yourself to our Community

I, too, am a newbie, but what I’ve learned thus far has amazed me. Despite the fact that I am still a beginner, I am eager to learn more. My ultimate goal is to automate manual risk management-related business processes in order to scale up and increase efficiency. I discovered this forum while seeking help with copying and pasting data into a range in Excel. This site helped me see the light after what had been a challenge for at least a month, if not longer. Thank you very much!! I’m looking …

This post made by @lakshman received 3 likes!

Keep DataTable Columns Where ColumnName Contains Specific Keyword

@Jugger Welcome back to our UiPath community. First find out all the columns whose header contains specific word as below. arrColNames = (From c in dtInput.Columns.Cast(Of DataColumn) Where c.ColumnName.Contains("specific word") Select c.ColumnName).toArray Here, arrColNames is of type Array of String And then try below expression to fetch only required rows with specific header matching columns. dtOutput = dtInput.DefaultView.ToTable(True,arrColNames) Note: If you want duplicate record…

This post made by @nikhil.girish received 3 likes!

How to checky folder if present or not

Folder_Check.zip (1.3 KB) Its just a 2 step activity , let me know if you are stuck @Darren_Shaw

Top 3 Most Liked Solutions

This solution provided by @lakshman received 3 likes!

Keep DataTable Columns Where ColumnName Contains Specific Keyword

@Jugger Welcome back to our UiPath community. First find out all the columns whose header contains specific word as below. arrColNames = (From c in dtInput.Columns.Cast(Of DataColumn) Where c.ColumnName.Contains("specific word") Select c.ColumnName).toArray Here, arrColNames is of type Array of String And then try below expression to fetch only required rows with specific header matching columns. dtOutput = dtInput.DefaultView.ToTable(True,arrColNames) Note: If you want duplicate record…

This solution provided by @nikhil.girish received 3 likes!

How to checky folder if present or not

Folder_Check.zip (1.3 KB) Its just a 2 step activity , let me know if you are stuck @Darren_Shaw

This solution provided by @Nithinkrishna received 1 likes!

Excel Variables Separation

Hey @ridvanucok You would storing the split values into an array variable. arrStr(0) The above will give you A arrStr(1) The above will give you B and so on. Hope this helps Thanks #nK

---

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.

[system]

Daily Forum Report | 28 February 2022

Top 3 Topics with Most Views

Dynamic download path settings made by @sanjay_gowda with 70 views.

Passing argument to start a job made by @Vicky_Fegan1 with 63 views.

I need to split pdf into multiple pdfs. i had no page numbers in it.Based on the text i need to split into multiple pdfs.can any one help?I had extracted pdf data and tyring to split by regex made by @MitheshBolla with 55 views.

Top 3 Topics with Most Replies

I need to split pdf into multiple pdfs. i had no page numbers in it.Based on the text i need to split into multiple pdfs.can any one help?I had extracted pdf data and tyring to split by regex made by @MitheshBolla with 24 replies.

Uipath in Search speed in automated Web search automation made by @A_Zyzz_Man with 21 replies.

Filter outlook mail made by @TUSHAR_DIWASE with 19 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 32 posts!

@Nithinkrishna made 29 posts!

@nikhil.girish made 20 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 3 likes!

UiPath Community MVP 2022 announcement!

I’m no memer, but I’m going to take the meme idea presented by @PD2 and give it a shot here “at home” These pics are from the beautiful desert sands of Hatta, UAE . I managed to jog up and down a few sand dunes pretty far off into the horizon and away from where our safari vehicle stopped. The wife although was mad at me for scooting off agreed to shoot some pictures of me as i made my way back to the base camp. Feels a lot like how some (or many of us) started with our UiPath RPA journ…

This post made by @Yoichi received 3 likes!

How to get Saturday's and Sunday's of whole year

Hi, FYI, another solution: arrayDateTime = Enumerable.Range(0,365-CInt(DateTime.IsLeapYear(Today.Year))).Select(Function(i) New DateTime(Today.Year,1,1).AddDays(i)).Where(Function(d) d.DayOfWeek=DayOfWeek.Sunday OrElse d.DayOfWeek=DayOfWeek.Saturday).ToArray() Regards,

This post made by @RPAForEveryone received 3 likes!

Todays date is given in 3 column want complete date in 4th column which activity I can use for it

Hi @satish.rathi59 Welcome to the UiPath Community! You can use DateTime.ParseExact method to achieve this. Assign DateString = A1 + "/" + B1 + "/" + C1 (append the first three columns together) Assign MyDate = DateTime.ParseExact(DateString, "dd/MM/yyyy", CultureInfo.InvariantCulture) You may choose not to add the / character, I added it for clarity/aesthetics. Whichever date format you prefer, make sure to use that in the second argument of ParseExact. For example, if you pass DateStrin…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

How to get Saturday's and Sunday's of whole year

Hi, FYI, another solution: arrayDateTime = Enumerable.Range(0,365-CInt(DateTime.IsLeapYear(Today.Year))).Select(Function(i) New DateTime(Today.Year,1,1).AddDays(i)).Where(Function(d) d.DayOfWeek=DayOfWeek.Sunday OrElse d.DayOfWeek=DayOfWeek.Saturday).ToArray() Regards,

This solution provided by @Gokul001 received 3 likes!

How to get the last row count of specified column?

HI @Alvin_Apostol2 You can try as @lakshman suggested and also you can try this methods Method 1 Use Read Range and store in a variable For each row in datatable and loop through the column Inside keep if activity and give condition as Row(“Status”).Equals("") Then you can process your task Else keep empty it will go to next row Method 2 Use Read Range and store in a variable Use Lookup Datatable and give lookup value as “” in column status and get the row index from there. Do you…

This solution provided by @Yoichi received 2 likes!

I want to remove columns with blanks and certain characters in my data table

Hi, Your code seems remove rows… Anyway, can you try the following expression? BBBB = AAAAA.AsEnumerable.Where(Function(x) Not (String.IsNullOrEmpty(x("Jan").ToString) OrElse x("Jan").ToString.Contains("KEYWORD"))).CopyToDataTable() Regards,

[Previous Month] Top 3 Users with the most likes on their solutions

@Gokul001 received 95 likes for their solutions!

@Yoichi received 59 likes for their solutions!

@Nithinkrishna received 34 likes for their solutions!

---

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.

[system]

Daily Forum Report | 01 March 2022

Top 3 Topics with Most Views

🌺 Women in Automation Series 🌺 9 - 11 March made by @cristina.vidu with 156 views.

How can we split made by @Sweety_Nagar with 62 views.

How to select the date from calendar 180 days ago? made by @tayyabimtiaz1 with 45 views.

Top 3 Topics with Most Replies

How to select the date from calendar 180 days ago? made by @tayyabimtiaz1 with 35 replies.

Date Format with Variable made by @FingFongRobot with 17 replies.

Something is wrong with my variable made by @Eulo_Map with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 61 posts!

@ppr made 43 posts!

@Nithinkrishna made 33 posts!

Top 3 Most Liked Posts

This post made by @cristina.vidu received 15 likes!

Women in Automation Series 9 - 11 March

Spread the word by sharing this link: Women in Automation Series 9 - 11 March - Events - UiPath Community Forum :sparkles: In order to mark March 8th, International Women’s Day, we are launching a full fledged series for all the women within our community and beyond. From women in RPA, to any woman willing to step into RPA. WOMEN IN AUTOMATION SERIES March 9-11…

This post made by @Gokul001 received 4 likes!

Get string in Reverse

Hi @Learner007 Try this expresion String.Join(" “,Split(“Robotic process automation”,” ").Reverse) Regards Gokul

This post made by @Gokul001 received 3 likes!

How to get the last date of the any month

Hi @copy_writes Try this expression DateTime.DaysInMonth(Any year, Any Month).ToString [image] Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 4 likes!

Get string in Reverse

Hi @Learner007 Try this expresion String.Join(" “,Split(“Robotic process automation”,” ").Reverse) Regards Gokul

This solution provided by @Gokul001 received 3 likes!

How to get the last date of the any month

Hi @copy_writes Try this expression DateTime.DaysInMonth(Any year, Any Month).ToString [image] Regards Gokul

This solution provided by @Gokul001 received 2 likes!

Condition loop except some sheet?

Hi @fairymemay And what are you looping on I think you used these steps to loop if not try this Get Workbook Sheets and store in a “Sheets” variable For each item in Sheets If Not Item.tostring.contains(“Extra”) Regards Gokul

---

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.

[system]

Daily Forum Report | 02 March 2022

Top 3 Topics with Most Views

Iterating through email attachments made by @Androk with 65 views.

I had one pdf with 100 pages which contains data of cars compnay. can i split into 4 documents based on page no and company name? made by @MitheshBolla with 52 views.

Merge two database with different Column Name made by @jvillalba9221 with 52 views.

Top 3 Topics with Most Replies

Unable to run script after disconnecting VM / after doing system shutdown made by @Mathkar_kunal with 26 replies.

Merge two database with different Column Name made by @jvillalba9221 with 20 replies.

Get outlook mail message ERROE made by @Zoeyu with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 58 posts!

@ppr made 39 posts!

@Nithinkrishna made 25 posts!

Top 3 Most Liked Posts

This post made by @zell12 received 2 likes!

Your feedback on UiPath Apps can earn you a certification voucher

Hi Maciej! @loginerror below are my inputs What integration to an automation platform are you looking forward to see in UiPath Apps and why? Direct integration/native compatibility with Action Center. One such use case of this would be an App/Unified dashboard being used by a pool of users, where they could select a batch of items that will then be routed to an Approval Matrix queued and orchestrated via Action Center. Once approved/rejected/hold, the status will then be reflec…

This post made by @Yoichi received 2 likes!

重複データを抽出したいです

こんにちは 以下お試しください dt = dt.AsEnumerable.Where(Function(r) dt.AsEnumerable.Count(Function(r2) r2("Column1").ToString=r("Column1").ToString)>1).CopyToDataTable()

This post made by @Sadmim_Hossain1 received 2 likes!

Read data in column and compare (Fast)

It’s probably because of the excel file. You can either change the data format after this process is completed. (alternative: you can also add a ’ before the text when it writes in the cell.) It is taking time because of its’ dynamic process. It opens and reads the excel file each time, searches the table to get the amount of the particular APPLAN. If we could fix the DataTables; as done in the previous workflow; the process would have been way faster.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

重複データを抽出したいです

こんにちは 以下お試しください dt = dt.AsEnumerable.Where(Function(r) dt.AsEnumerable.Count(Function(r2) r2("Column1").ToString=r("Column1").ToString)>1).CopyToDataTable()

This solution provided by @nikhil.girish received 2 likes!

Copy data from excel column

Hi @Aishwarya_Bhargava refer below link hope this helps Thanks

This solution provided by @Sadmim_Hossain1 received 2 likes!

Loop sheet name?

Hello, Basically, it totally depends on how you are going to use the DT. The idea goes like this when you are going through the DT as per row you are also reading the Sheet’s DataTable. You can do it by separating the sheet names into an array and then reading the data table individually with For Each Activity. This For Each activity will iterate through the array and read each of the sheets. I have created a sample workflow that will be able to read all the sheets separated by a comma. You ca…

---

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.

[system]

Daily Forum Report | 03 March 2022

Top 3 Topics with Most Views

Split by space made by @Angel_Llull with 48 views.

Option to Digitize Single Page made by @prasath_S with 47 views.

How to find difference between two date made by @Vrushali_Gave with 41 views.

Top 3 Topics with Most Replies

Insert column between column? made by @fairymemay with 26 replies.

Selector and Element Exist made by @arturo.ayala with 14 replies.

Compare the phone numbers in excel to a list of PDF files, write the file names in the excel file made by @MF.RPA with 8 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 50 posts!

@ashwin.ashok made 21 posts!

@Nithinkrishna made 20 posts!

Top 3 Most Liked Posts

This post made by @ppr received 17 likes!

Monthly Forum rewards - February 2022

@loginerror Thank you for the Award initiative and the reward. May I ask you to check if it is possible to pass the reward as a donation e.g. to: Thanks Congratulations to all the winners

This post made by @Gokul001 received 9 likes!

Monthly Forum rewards - February 2022

Congratulation to all the winners Regards Gokul

This post made by @AMALRAJ received 8 likes!

Monthly Forum rewards - February 2022

Congratulations to all the winners Especially to @Gokul001 My Warmest congratulations on your achievement. Regards AMAL

Top 3 Most Liked Solutions

This solution provided by @lepumin received 2 likes!

Write text from multiple PDF's to single text file

Remove WriteTextFile activity and use AppendLine activity to add text to the existing .txt file.

This solution provided by @Yoichi received 2 likes!

How to find first substring which contains any alphabet

Hi, Can you try the following expression? System.Text.RegularExpressions.Regex.Match(yourString,"\b[A-Z]{5,}").Value Regards,

This solution provided by @supermanPunch received 1 likes!

Compare the phone numbers in excel to a list of PDF files, write the file names in the excel file

Hi @MF.RPA , The above Idea is very much a Possibility as I have also accomplished a similar updation after exporting the extraction results. During the Exporting of the Datasets to an Excel, we could use the datatable for updating the Column Value of the Phone Number. Suppose table is your Datatable variable, then we could update the value in the Phone Number Column using an Assign Activity in the Below way : table(0)("Phone Number") = FileName FileName is the data which should already be…

---

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.

[system]

Daily Forum Report | 04 March 2022

Top 3 Topics with Most Views

Yoichi 2000th Solution Flag Celebration made by @ppr with 58 views.

Yoichi 2000th solution Flag celebration 👏 made by @AMALRAJ with 52 views.

How can I use data scraping with the activity filter data table made by @Josimar_Leandro_Ortiz_Pas with 44 views.

Top 3 Topics with Most Replies

Read data from excel and write into another excel (Only get the last column data) made by @ack940129 with 15 replies.

How to get specific data from data table and make it as value to be typed in TypeInto activity made by @_waysi with 15 replies.

How can I use data scraping with the activity filter data table made by @Josimar_Leandro_Ortiz_Pas with 13 replies.

Top 3 Users Who Posted The Most

@lakshman made 29 posts!

@ashwin.ashok made 27 posts!

@Nithinkrishna made 20 posts!

Top 3 Most Liked Posts

This post made by @AMALRAJ received 8 likes!

Yoichi 2000th solution Flag celebration

HI… On behalf of everyone, I took this responsibility to say thank you to @Yoichi,i am so privileged to wishing this achievement. For his 2000th solution flag, I think next to @Palaniyappan,@Yoichi made his 2000th solution flag. Advance wishes for @ppr also. Thank you for being so helpful.Your reply was so timely,in-depth and helpful to our forum members. I know this caliber of response takes a person who is very detailed and thoughtful. Once again i thank you fr…

This post made by @ppr received 7 likes!

Yoichi 2000th Solution Flag Celebration

1997,1998,1999 it is just a question of minutes/seconds/milliseconds 2000 Lets join @Yoichi when he reached the 2000th Solution Flag.

This post made by @StefanSchnell received 4 likes!

Monthly Forum rewards - February 2022

Congratulations to all the winners and thank you for your effort.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Read Cell for Null and Double Values

Hi, Can you try to use UiPath.Core.GenericValue type, as the following? [img20220304-3-2] Regards,

This solution provided by @mmc received 1 likes!

Orchestrator API - Update modern Unattended Robot password

Hi @BennyS I solved the issue by splitting the process in: Get the user (GET /odata/Users({key})) Change/set the Unattended Password – “UnattendedRobot”: { “Password”: “new password”, … – Update the user with at PUT call (with the changed password) (PUT /odata/Users({key})) I hope this helps. Best Regards, Martin

This solution provided by @lakshman received 1 likes!

Orchestrator HTTP Request: Determine Success Status

@azeem_rosli We have property called Status Code. If it is 200 then Http request is success else not.

---

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.

[system]

Daily Forum Report | 05 March 2022

Top 3 Topics with Most Views

How to get the range of data present in excel made by @jeevan.h with 50 views.

How to filter outlook email messages received "today" made by @kit2815 with 40 views.

Job running failed made by @s.swapna8 with 37 views.

Top 3 Topics with Most Replies

Job running failed made by @s.swapna8 with 18 replies.

How to get the range of data present in excel made by @jeevan.h with 16 replies.

I want to move files from one folder to another folder. The files are stored in onedrive made by @abhishek_bhide with 11 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 33 posts!

@ashwin.ashok made 10 posts!

@nico.marucchi made 8 posts!

Top 3 Most Liked Posts

This post made by @SudhaSachi received 2 likes!

Monthly Forum rewards - February 2022

Congratulations to all of you.

This post made by @pravin_calvin received 1 likes!

Yoichi 2000th Solution Flag Celebration

Congratulations @Yoichi

This post made by @Palaniyappan received 1 likes!

Yoichi 2000th solution Flag celebration

Congrats @Yoichi Inspiring

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 1 likes!

Parsing DateTime AM/PM Problem

this will work DateTime.ParseExact("22/02/2019 - 07:24 PM", "dd/MM/yyyy - hh:mm tt", nothing) you need to use hh instead of HH because HH is 24 hour time which doesnt work with AM / PM e.g. 15:03 AM doesnt make sense but 03:03 AM or 03:03 pm makes sense

This solution provided by @mahmoud.zaky received 1 likes!

How to split int no without seperator

Hello Naveen, you can use “Strvalue.ToCharArray” like below 1- Create Variable for your string (Str) with your value. 2- Create Array of type Char under system.char (arrstr) 3- use assign activity as arrstr–> Str.ToCharArray 4- then use for each loop on you arrstr. Screen of process: [image] Screen of Variables: [image] Screen of Output: [image]

This solution provided by @Srini84 received 1 likes!

Unable tio use Filter data Table activity in UI PAth version 2021

@varun_shinde Can you place ColumnName in " " Put Column Salary as “Salary” Hope this will help you Thanks

---

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.

[system]

Daily Forum Report | 06 March 2022

Top 3 Topics with Most Views

Need help to edit code LINQ? made by @fairymemay with 69 views.

Disaster when Move File to a destination folder which was not exist made by @Marginalizer with 48 views.

Need help to Filter datatable made by @Aleem_Khan with 47 views.

Top 3 Topics with Most Replies

Need help to edit code LINQ? made by @fairymemay with 20 replies.

Need help to Filter datatable made by @Aleem_Khan with 10 replies.

Disaster when Move File to a destination folder which was not exist made by @Marginalizer with 9 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 35 posts!

@Aleem_Khan made 14 posts!

@fairymemay made 11 posts!

Top 3 Most Liked Posts

This post made by @vaibhavinnovation79 received 2 likes!

Monthly Forum rewards - February 2022

Congratulations to All

This post made by @ashwin.ashok received 2 likes!

How to split int no without seperator

The pattern detects the empty gaps between each number: [image] Then Where clause in the LINQ filters out empty results(Blanks) and converts the rest to Array. Kind Regards, Ashwin A.K

This post made by @Abram_Yct received 1 likes!

Unable to assign value from Datatable

Hello Mr Gustavo, i still have the same problem as this post and still cant find the way to get rid of it. Can i send you my project? thank u so much.

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Convert day today to int?

Hey @fairymemay Yes it shows like the below, 0 - Sunday 1 - Monday 2 - Tuesday 3 - Wednesday 4 - Thursday 5 - Friday 6 - Saturday I guess when you ran the above code, as per your system day it would be Sunday that’s why it outputs as 0 Hope this helps Thanks #nK

This solution provided by @Nithinkrishna received 1 likes!

Need help to edit code LINQ?

Hey @fairymemay Please find the updated below, ateTime.ParseExact(x(“วันรับเล่ม”).ToString, “dd/MM/yyyy HH:mm”, System.Globalization.CultureInfo.InvariantCulture) Thanks #nK

This solution provided by @Jorge_Valbuena received 1 likes!

Different results reading a Native PDF File and Scanned PDF File with the same OCR

So, It’s seems to be an issue with the encoding of some fonts, when I set the property ForceApplyOCR to true, I get the expected results from the extraction of the data. I guess that with the proper OCR, the results will be with 100% accuracy or close to it.

---

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.

[system]

Daily Forum Report | 07 March 2022

Top 3 Topics with Most Views

LINQ to check if item in one column of Datatable 1 is present or contains items from another column in Datatable2 made by @Ray_Sha1 with 62 views.

How can i use extract table data on web data? made by @A_Zyzz_Man with 46 views.

Round a number to the nearest 10 made by @Haltob01 with 44 views.

Top 3 Topics with Most Replies

LINQ to check if item in one column of Datatable 1 is present or contains items from another column in Datatable2 made by @Ray_Sha1 with 21 replies.

Send SMTP Mail Message new line made by @Felix_Gunawan with 21 replies.

Boolean error to replace text using Asenumberable made by @Shyam_Pragash with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 45 posts!

@ashwin.ashok made 31 posts!

@postwick made 25 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 3 likes!

Convert Timespan to the String Format

Hi @henokhbrian , Timespan might contain the keyword “Time” in it, but it has nothing to do with Dates, which is why we can’t use string implementations. Its a collection of ticks, so the only workaround for it is like so: [image] Assign → spn_variable = TimeSpan.Parse("1.03:34:23.8121360") spn_variable.Hours.ToString+":"+spn_variable.Seconds.ToString Or String.Format("{0}:{1}",spn_variable.Hours,spn_variable.Seconds) I hope that helps. Kind Regards, Ashwin A.K

This post made by @Nithinkrishna received 2 likes!

How to check if a tab still exists, without using element exist

Hey @Shinjid The below activity may help you. Thanks #nK

This post made by @fairymemay received 2 likes!

Check range another sheet excel?

Now I check value in column FYP and compare with sheet that start text config as below. and column Type_config = sheetName that found value APPLAN follow red text) [image] test.xaml (22.8 KB) Data Campaign_65 old map.xlsx (1.5 MB) But DataRow have 10K , It take time to run. Please guide me about it. (Fast) @Ramya_K can you guide me for edit code?

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

How to check if a tab still exists, without using element exist

Hey @Shinjid The below activity may help you. Thanks #nK

This solution provided by @Gokul001 received 2 likes!

How to click the button of excel?

HI @yu_anan Welcome to community! Can you try to use Click Image activity If possible share the excel file Regards Gokul

This solution provided by @ppr received 2 likes!

Check column name if found header same

---

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.

[system]

Daily Forum Report | 08 March 2022

Top 3 Topics with Most Views

【UiPathアカデミー】新規コースのお知らせ made by @yuko.tanaka with 52 views.

How can we get the modified Date from a file in Sharepoint? made by @jmeier with 46 views.

Sum of a column based on index made by @karthik_kulkarni1 with 42 views.

Top 3 Topics with Most Replies

Regex based extractor extracting all value from all the pages of the pdf made by @shrey.shah with 25 replies.

How to replace all the spaces of Headers with "_" made by @Sirimalla_Karthik_Chandra with 23 replies.

How to click on the ok or cancel button within the chrome alert box? made by @Riya_Sharma with 20 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 40 posts!

@ashwin.ashok made 35 posts!

@ppr made 31 posts!

Top 3 Most Liked Posts

This post made by @yuko.tanaka received 3 likes!

【UiPathアカデミー】新規コースのお知らせ

平素より、UiPathアカデミー をご愛顧いただき誠にありがとうございます。 このたび、「 Studio による UI 操作の自動化 」コースを新たにリリースしましたのでお知らせいたします。 このコースでは、モダン エクスペリエンスとクラシック エクスペリエンスの両方を使用して、UI 操作の自動化の概念について学習します。 ※アカデミーにログイン後、リンクが遷移しない場合は、ブラウザーを一度閉じクッキーとキャッシュをクリアしてください。 UiPath 製品に関する知識の拡充にお役に立てればと思います。 ぜひ、UiPath アカデミーをご活用くださいませ。 引き続きよろしくお願いいたします。

This post made by @Gokul001 received 3 likes!

Advanced scheduling using Cron Expression

What is Cron Expression? Cron expressions are used to configure instances of Cron Trigger, a subclass of Trigger. Cron expression is a string consisting of six or seven subexpressions (fields) that describe individual details of the schedule. Quartz implements 7 field cron-expressions Seconds Minutes Hours Day-of-Month Month Day-of-Week Year (optional field)

1. Cron expression to trigger the process for Every month & day between 7th and 13th at 7:30

Expression : 0 30 7 7-13 * ? * [ima…

This post made by @Gokul001 received 3 likes!

Pic download

Hi @kamini Welcome back to community Instead of passing the title You can use “*” Asterisk Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

Pic download

Hi @kamini Welcome back to community Instead of passing the title You can use “*” Asterisk Regards Gokul

This solution provided by @Sadmim_Hossain1 received 2 likes!

Check dup by column

Hello, For this problem, you can First flag the rows that are duplicates and later delete them from excel with an Insert/Delete Rows activity to delete the rows that are flagged. I have created a solution, you can have a look, and do let me know if you have any further queries. ExcelDupicateDelete.xaml (35.4 KB)

This solution provided by @ashwin.ashok received 2 likes!

When I Assign the datarow to select the column of datatable there's cannot find

Hi @HuaiYe , It seems as though the Data Scrapping was performed unsuccessfully. Could you try using the Data Scrapping Wizard? [image] The Modern Design Experience has to be disabled for this option to be available. [image] You can use the Extract Table Data Activity as well if Modern Design Experience is enabled like so: [image] ExtractDataFromWeb.xaml (11.8 KB) Kind Regards, Ashwin A.K

---

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.

[system]

Daily Forum Report | 09 March 2022

Top 3 Topics with Most Views

Celebrating 5️⃣ anniversary with UiPath Forum made by @lakshman with 56 views.

Extract certain string between "|" made by @Ionut_Frincu with 49 views.

Read multiple invoice format made by @mayachoy with 42 views.

Top 3 Topics with Most Replies

How to run "Start Job" for designated Robot made by @Lori with 17 replies.

Celebrating 5️⃣ anniversary with UiPath Forum made by @lakshman with 14 replies.

Extract certain string between "|" made by @Ionut_Frincu with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 47 posts!

@Palaniyappan made 17 posts!

@ppr made 15 posts!

Top 3 Most Liked Posts

This post made by @lakshman received 16 likes!

Celebrating anniversary with UiPath Forum

Hey Guys, As the cake near my name says, today is my year anniversary since I joined the UiPath Forum [Screenshot_20220309-093859] I have learnt a lot from forum during these years especially from @ppr (Linq query expert), @Yoichi (Regex expert), @StefanSchnell (SAP automation expert), @balupad14 (Excel automation expert) and also made a lot of friends like @Lahiru.Fernando, @Palaniyappan, @nerlichman, @Divyashreem, @prasath_S etc… I…

This post made by @lakshman received 3 likes!

Celebrating anniversary with UiPath Forum

@prasath_S @Yoichi @nikhil.girish Thanks to you as well for your continuous support to the UiPath community. Keep up the good work

This post made by @lakshman received 2 likes!

Celebrating anniversary with UiPath Forum

Thanks to you @Gokul001 & @Sudharsan_Ka as well for your continuous support to the UiPath community. Keep up the good work.

Top 3 Most Liked Solutions

This solution provided by @Sadmim_Hossain1 received 2 likes!

Delete rows excel (loop)

Hello, I hope this works for you DeleteRowsExcelLoop.xaml (13.2 KB)

This solution provided by @Gokul001 received 1 likes!

C# or vba?

Hi @ankur.kaushik Welcome to community Have a look on the thread Regards Gokul

This solution provided by @ashwin.ashok received 1 likes!

How to check if one column is equal another colum in excel and add a new column

Hi @siteltower , Could you try and see if the logic performs the operation as expected? (From row In dt_masterData.AsEnumerable() Let upd = dt_updateData.AsEnumerable().Where(Function(w) w("ID").ToString.Trim.Equals(row("ID").ToString)).ToArray() Let ra = New Object(){row("ID"),row("Service Type"),row("Assets SN"), upd.First().Item("Status"),upd.First().Item("Issue"),row("Name"),row("Project")} Select dt_result.Rows.add(ra)).CopyToDataTable() CheckIfColumnsAreSame.xaml (7.8 KB) Kind 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.

[system]

Daily Forum Report | 10 March 2022

Top 3 Topics with Most Views

How to get the Max and Min value from excel and write it to another excel made by @Krystal with 52 views.

Need a help on Group By made by @Marian_B with 51 views.

Insert header into Data table made by @Olivera_Kalinic with 47 views.

Top 3 Topics with Most Replies

Insert header into Data table made by @Olivera_Kalinic with 18 replies.

Unable to get column value in excel made by @shuklarchana001 with 14 replies.

How to get the Max and Min value from excel and write it to another excel made by @Krystal with 13 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 62 posts!

@ashwin.ashok made 40 posts!

@Gokul001 made 39 posts!

Top 3 Most Liked Posts

This post made by @Ovidiu_Constantin received 3 likes!

Log times to contain milliseconds

Added to the backlog.

This post made by @Gokul001 received 3 likes!

How to set flow condition?

HI @fairymemay Have a look on the skeleton Flowchart.xaml (11.4 KB) [image] Regards Gokul

This post made by @postwick received 2 likes!

Whole data table as single item into an orchestrator queue

Queue Items can’t be complex datatypes. Your best option is to save the data to Excel or CSV and then reference the file path as a string in the Queue Item. It is possible to convert a datatable to JSON and put the JSON into the Queue Item as a string, but I don’t know the limitations on how much data you can do that with.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 3 likes!

How to set flow condition?

HI @fairymemay Have a look on the skeleton Flowchart.xaml (11.4 KB) [image] Regards Gokul

This solution provided by @postwick received 2 likes!

Whole data table as single item into an orchestrator queue

Queue Items can’t be complex datatypes. Your best option is to save the data to Excel or CSV and then reference the file path as a string in the Queue Item. It is possible to convert a datatable to JSON and put the JSON into the Queue Item as a string, but I don’t know the limitations on how much data you can do that with.

This solution provided by @ashwin.ashok received 2 likes!

How to get particular date of every month from current year?

Hi @NervousTuber , Is this what you were looking for? [image] [image] Assign → int_day = 16 int_year = 2022 Enumerable.Range(1,12).Select(Function(s) New DateTime(int_year,s,int_day).ToString("dd/MM/yyyy")).ToArray() Kind Regards, Ashwin A.K

---

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.

[system]

Daily Forum Report | 11 March 2022

Top 3 Topics with Most Views

Measuring Bot Execution Time made by @anmita with 56 views.

Else condition pass to CATCH? made by @fairymemay with 55 views.

Moving collumns made by @Atharv_Madne with 52 views.

Top 3 Topics with Most Replies

Else condition pass to CATCH? made by @fairymemay with 18 replies.

Smtp errror made by @poojaskyrathore with 17 replies.

Moving collumns made by @Atharv_Madne with 15 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 35 posts!

@ashwin.ashok made 33 posts!

@nikhil.girish made 24 posts!

Top 3 Most Liked Posts

This post made by @nikhil.girish received 2 likes!

Post GET API Request

Hi @karina_mota try downgrading the package and see if issue still persist ? Thanks

This post made by @Yoichi received 2 likes!

Is it possible to create a code where it behaves like a scientific calculator?

Hi, Unfortunately, Vb or C# doesn’t have a function like eval(), we need to approach by other ways. ● DataTable.Compute method strExpression = "((10-5)*(2+2))*5" dt = New DataTable() Then dt.Compute(strExpression, "").ToString ● Inject JS script activity strExpression = "((10-5)*(2+2))*5" Inject JS Script activity Indicate an element in any browser. Input Parameter : strExpression ScriptCode "function(e,v) { return eval(v); }" ScriptOutput : strResult ●Use 3rd party library. Per…

This post made by @karina_mota received 1 likes!

Post GET API Request

Hi Thank you very much, I created a new project and re-installs activity in an older version. The error is gone. Now I will try the procedure that the @dokumentor suggested. very grateful [Capturar]

Top 3 Most Liked Solutions

This solution provided by @nikhil.girish received 2 likes!

Post GET API Request

Hi @karina_mota try downgrading the package and see if issue still persist ? Thanks

This solution provided by @Yoichi received 2 likes!

Is it possible to create a code where it behaves like a scientific calculator?

Hi, Unfortunately, Vb or C# doesn’t have a function like eval(), we need to approach by other ways. ● DataTable.Compute method strExpression = "((10-5)*(2+2))*5" dt = New DataTable() Then dt.Compute(strExpression, "").ToString ● Inject JS script activity strExpression = "((10-5)*(2+2))*5" Inject JS Script activity Indicate an element in any browser. Input Parameter : strExpression ScriptCode "function(e,v) { return eval(v); }" ScriptOutput : strResult ●Use 3rd party library. Per…

This solution provided by @suraj.setty received 1 likes!

Adding Values of column

Hi @mohamedalthaf Please have a look. [Uipath Sum of Column in Excel] Hope this helps to solve. Thanks.

---

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.

[system]

Daily Forum Report | 12 March 2022

Top 3 Topics with Most Views

How to count Special 3 character in one String made by @Sweety_Nagar with 73 views.

Convert System.Collections.Generic.List`1[System.SystemException] to string? made by @fairymemay with 56 views.

Regex help capturing total amount made by @MaxDS1 with 42 views.

Top 3 Topics with Most Replies

How to count Special 3 character in one String made by @Sweety_Nagar with 14 replies.

Convert System.Collections.Generic.List`1[System.SystemException] to string? made by @fairymemay with 13 replies.

Excel to Sap Business one made by @badal_patel with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 34 posts!

@Gokul001 made 19 posts!

@fairymemay made 14 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 1 likes!

Regex help capturing total amount

HI @MaxDS1 If you need the whole text try this expression System.Text.RegularExpression.Regex.match("InputString","(I\salt\s)(\d.+)|(Saldo\s)(\d.+)|(Saldo\svor\sfavør\n)(\d.+)|(Ultimosaldo\sI\salt DKK\s)(\d.+)|(I\salt\sDKK\s)(\d.+)|(Beløb\sSkyldig\nkr\s)(\d.+)").Tosting.Trim [image] Regards Gokul

This post made by @Gokul001 received 1 likes!

Regex help capturing total amount

HI @MaxDS1 Try this Regex Expression System.Text.RegularExpression.Regex.match("InputString","(?<=I\salt\s)(\d.+)|(?<=Saldo\s)(\d.+)|(?<=Saldo\svor\sfavør\n)(\d.+)|(?<=Ultimosaldo\sI\salt DKK\s)(\d.+)|(?<=I\salt\sDKK\s)(\d.+)|(?<=Beløb\sSkyldig\nkr\s)(\d.+)").Tosting Regards Gokul

This post made by @jeevith received 1 likes!

Regex help capturing total amount

Hei @MaxDS1, In short the last one has kroner “Kr” one the newline before it starts with digits. So your pattern was not capturing the last one. Similar to your anchor search with pipes, you can use the | to look for two different types of patterns. Basically an OR logic. \s(saldo|i alt|ultimo|Beløb\sskyldig).{0,19}?\n?(kr [\d*.\d*]+.,\d*|[\d*.\d*]+.,\d*) [image] From Regex101 (I like using this website since it provides group matches and explanation of the pattern) [image] One more thi…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 1 likes!

Regex help capturing total amount

Hei @MaxDS1, In short the last one has kroner “Kr” one the newline before it starts with digits. So your pattern was not capturing the last one. Similar to your anchor search with pipes, you can use the | to look for two different types of patterns. Basically an OR logic. \s(saldo|i alt|ultimo|Beløb\sskyldig).{0,19}?\n?(kr [\d*.\d*]+.,\d*|[\d*.\d*]+.,\d*) [image] From Regex101 (I like using this website since it provides group matches and explanation of the pattern) [image] One more thi…

This solution provided by @Palaniyappan received 1 likes!

Throw, Rethrow and Global Exception handler

Hi I appreciate your interest and passion to know the activity and it’s properties But by next Pls be clear with the query you want to get clarified On a note that these are EXCEPTION handling methods / activities used in UiPath There are five activities for handling exception Try catch Throw Rethrow Global exception handler Retry scope Rethrow is used when you want activities to occur before the exception is thrown. Throw activity is used when you want to throw error before the execut…

This solution provided by @ashwin.ashok received 1 likes!

For Loop append string

Hi @fairymemay , If you are using a For Each Loop, then here is a sample sequence to get you started: [image] [image] [image] I’m using a Substring Method to get rid of the comma that gets appended towards the start when we first start assigning the items to our string variable. CombineStrings.xaml (6.4 KB) Kind Regards, Ashwin A.K

---

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.

[system]

Daily Forum Report | 13 March 2022

Top 3 Topics with Most Views

Activities if made by @pl.rusinov with 47 views.

How to store multiple extracted PDF data through DU into excel made by @sai_krishna6 with 43 views.

Copy values from one excel to another made by @Sathish_Kumar_S with 41 views.

Top 3 Topics with Most Replies

Compare values from different excel made by @aqiff with 10 replies.

How to store multiple extracted PDF data through DU into excel made by @sai_krishna6 with 10 replies.

Copy values from one excel to another made by @Sathish_Kumar_S with 8 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 16 posts!

@Palaniyappan made 15 posts!

@Nithinkrishna made 9 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Does Deserialize Contain XML Value?

we would recommend to do a first check on only local name. So we do not have handle unknown namespaces. [grafik] xdoc.Descendants().Any(Function (x) x.Name.LocalName.tolower.equals(strElementNameVar.toLower))

This post made by @anmita received 1 likes!

Using Widget for Execution Time in Insight

If we have the transaction duration in Seconds for bot then how can I find the Bot Processing Time in hour format using formula in widget ? (Example in 1 hr how much time does it execute needs to be found)

This post made by @Sathish_Kumar_S received 1 likes!

Copy values from one excel to another

How to copy the Value of the each header in file 1 to file 2 ? File 1: [image] File 2: [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Does Deserialize Contain XML Value?

we would recommend to do a first check on only local name. So we do not have handle unknown namespaces. [grafik] xdoc.Descendants().Any(Function (x) x.Name.LocalName.tolower.equals(strElementNameVar.toLower))

---

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.