Forum Engagement Daily Reports

[system]

Daily Forum Report | 25 March 2021

Top 3 Topics with Most Views

Structure of Loops made by @Yudhisteer_Chintaram1 with 38 views.

How to check if item exist in array? made by @AhmedKutraphali with 29 views.

There are no Available licence comunity version made by @davron20 with 28 views.

Top 3 Topics with Most Replies

Structure of Loops made by @Yudhisteer_Chintaram1 with 24 replies.

Convert cell or range value from text to number [Excel][Vb] made by @AS07 with 22 replies.

フォルダ内のテキストファイルの起動について made by @kawagolf with 19 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 34 posts!

@prasath17 made 33 posts!

@NIVED_NAMBIAR made 26 posts!

Top 3 Most Liked Posts

This post made by @GBK received 3 likes!

How to give default value for regex iendurable<Match>

@copy_writes - you can try to assign a variable in if activity based on match response like below matched_string = Regex.Match(regex); if(matched_string == null) { matched_string = "default"; }

This post made by @prasath17 received 3 likes!

Get text after string and ignore any spaces

@JeffNZ1 - You can try this Regex pattern… Assumption: After the Last Name there will be usermenu always.. [image] StrFNLN= Regex.Match(“JS Jeff ShumUserMenu”,“(?<=\s*)\w+\s*?\w+(?=UserMenu)”).value Import : System.text.regularexpressions (if Regex.Match did not recognize) [image]

This post made by @Berke received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, My name is Berke, I am 17 years old and studying in the informatics department. I’m trying to learn more about Rpa and improve myself as much as possible on these issues.

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 2 likes!

Structure of Loops

Hi @Yudhisteer_Chintaram1 Have a look at that workflow Main.xaml (14.0 KB) You can look at the workflow comments which i had put to get the logic how we can execute the workflow I am preffering a while loop here to do the process @copy_writes please have a look on that too Regards, Nived N Happy Automation

This solution provided by @Cristian_Negulescu received 2 likes!

Unable to update description in jira , but able to update summery

Please Check the movie on minute 1:52 to see how I define variables you need to write new JObject() . I also have a movie dedicated how to create JSON with details: [UiPath Tutorial for JSON Parsing and Creation | 8 UseCase]

This solution provided by @ppr received 2 likes!

Excel rows, create list only from integer numbers of rows

@Danny_Gi we do feel that a list with 1,2,3 will not help your case Also a list with all number will not add a value. Looking on this from another viewpoint we do see the chance to form groups based on main and sub items. for this we can use a group by approach: and if we do the grouping by logic like bring e.g. 1 and 1.1,1.2 … etc together we can segment the data for a further processing. Here following statement will help for defining the group key: [grafik] Let us know if you want to…

---

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.