Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 March 2022

Top 3 Topics with Most Views

Datarow throwing error made by @kavya.s16 with 43 views.

エンコード"shift_jis"はサポートされていませんというエラーの解消方法について made by @UedaKorai with 42 views.

LINQ "not in" datatable made by @ajh with 41 views.

Top 3 Topics with Most Replies

Error Job stopped with an unexpected exit code made by @fairymemay with 25 replies.

Merge column 2 column to one column? made by @fairymemay with 19 replies.

How to click on each name of web page made by @siteltower with 17 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 31 posts!

@Gokul001 made 24 posts!

@fairymemay made 21 posts!

Top 3 Most Liked Posts

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

Match and remove first linebreak from string

Seems like I was a little too late. Fantastic solutions by @Mr_JDavey though! I’ll just leave what I’ve found here in case you are interested: [image] System.Text.RegularExpressions.Regex.Replace(str_txtData,"(?<=^.*)\r?\n"," ") Kind Regards, Ashwin A.K

This post made by @Mr_JDavey received 2 likes!

Match and remove first linebreak from string

Hi there @Ninjabullen, I trust you are having a fantastic day! You should be able to achieve this via Strings.Replace: Strings.Replace(String, String, String, Int32, Int32, CompareMethod) Method (Microsoft.VisualBasic) | Microsoft Docs You can configure it as: YourString= Strings.Replace(YourString, VBCRLF, String.Empty, 1, 1) This will ultimately say, replace the first instance of VBCRLF in the String value. Example below: [image] Please let me know if you have any questions. Thanks …

This post made by @ppr received 2 likes!

How to write cell in a column exceeding the range A to Z

[grafik]

Top 3 Most Liked Solutions

This solution provided by @Mr_JDavey received 2 likes!

Match and remove first linebreak from string

Hi there @Ninjabullen, I trust you are having a fantastic day! You should be able to achieve this via Strings.Replace: Strings.Replace(String, String, String, Int32, Int32, CompareMethod) Method (Microsoft.VisualBasic) | Microsoft Docs You can configure it as: YourString= Strings.Replace(YourString, VBCRLF, String.Empty, 1, 1) This will ultimately say, replace the first instance of VBCRLF in the String value. Example below: [image] Please let me know if you have any questions. Thanks …

This solution provided by @ppr received 2 likes!

How to write cell in a column exceeding the range A to Z

[grafik]

This solution provided by @Steven_McKeering received 2 likes!

Which regex expression pattern to use if I want to select the number after 2 words?

Hi @mce Thank you for the Sample, the expected Output. But I think we need more information on the Pattern and any extra requirements you have. There are many talented people on the UiPath Community forums who can help with a pattern and have contributed a reply (@ppr and @Gokul001) but they need as much information as possible to make a strong pattern This information should be in the first post. 1 Minute invested in Original Post = 2+ Minutes saved later …

---

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 | 19 March 2022

Top 3 Topics with Most Views

How To Prnt Key values pairs from an dictionary made by @Sidney_Vogel with 48 views.

Read range error? made by @fairymemay with 40 views.

Combine several excel files and create pivot made by @vkrivenko with 39 views.

Top 3 Topics with Most Replies

How can I make the Instagram like button dynamic? made by @ridvanucok with 9 replies.

How To Prnt Key values pairs from an dictionary made by @Sidney_Vogel with 9 replies.

Read range error? made by @fairymemay with 9 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 14 posts!

@Shikhar_Tandon made 5 posts!

@fairymemay made 5 posts!

Top 3 Most Liked Posts

This post made by @Thanu_Matheesha1 received 1 likes!

Combine several excel files and create pivot

There are pre-build activities to combine excel files such as merge and to create a pivot table there is an activity called to create a pivot table. Use those pre-built activities to build your work flow

This post made by @vkrivenko received 1 likes!

Combine several excel files and create pivot

Hello, I have given several Excel files with reports. I’ve need to combine them all and create a pivot table. Please, help

This post made by @Lynx received 1 likes!

How to negate a regex?

itis works great!! thank very much @Steven_McKeering

Top 3 Most Liked Solutions

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

How To Prnt Key values pairs from an dictionary

Hi @Sidney_Vogel , You could also try looping through the Keys and reference the Values using the dictionary itself For Each-> Key In in_exceldata.Keys So could you give this a try instead? [image] key+ " " + in_exceldata(key).ToString Also, I’ve changed the ArgumentType to String → [image] BlankProcess1_v1.zip (5.6 KB) Kind Regards, Ashwin A.K

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

Need to stop excel and chrome

Hi @Bhjanga_Prabhu I would recommend you to use kill process activity for both EXCEL and Chrome in start of your process Drag 2 kill process activities and in properties just mention process name as excel and Chrome Also make continue on error property as TRUE Thanks

This solution provided by @fernando_zuluaga received 1 likes!

Read range error?

Can you try converting or saving your excel to an CSV file then using the read csv file, it should work and in less time 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 | 20 March 2022

Top 3 Topics with Most Views

Problems with the dynamic selector made by @appleikmek with 41 views.

AI Center not opening in Community Version of Cloud Orchestrator made by @Sainath_S1 with 30 views.

Linq Filter DataTable and rename Columns made by @NHoe with 30 views.

Top 3 Topics with Most Replies

Problems with the dynamic selector made by @appleikmek with 8 replies.

Write cell beyond a to z range in Gsuite - Google Sheets? made by @Pruthvi.G with 7 replies.

How to extract and update account number if account code from code column foun made by @Mansi_Mhatre with 7 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 10 posts!

@ashwin.ashok made 6 posts!

@appleikmek made 5 posts!

Top 3 Most Liked Posts

This post made by @Steven_McKeering received 1 likes!

How to do conditional "or" in regex?

Hi @Lynx The pipe symbol “|” represents Or in Regex. Take a look at this Regex Pattern I have created for you. [image] I have used an achor on the text “OP. GRAVADA” and then inserted some brackets which will find either “S/” or “$” (note that “$” must be escaped “\$” like this to mean it literally instead of the end of a line). Just be aware that Regex101.com is great for learning and for ‘basic’ Regex Patterns but I strongly recommend using RegexStorm as it is 100% compatible with UiPath …

This post made by @Lynx received 1 likes!

How to do conditional "or" in regex?

Thanks a lot @Steven_McKeering

This post made by @ridvanucok received 1 likes!

How to Scan QR code in scanned pdf's

@adarsh_kotagiri I can’t share it because it’s a workflow I made for a company. However, if I am available during the day, I can create an external workflow and share it with you.

Top 3 Most Liked Solutions

This solution provided by @Steven_McKeering received 1 likes!

How to do conditional "or" in regex?

Hi @Lynx The pipe symbol “|” represents Or in Regex. Take a look at this Regex Pattern I have created for you. [image] I have used an achor on the text “OP. GRAVADA” and then inserted some brackets which will find either “S/” or “$” (note that “$” must be escaped “\$” like this to mean it literally instead of the end of a line). Just be aware that Regex101.com is great for learning and for ‘basic’ Regex Patterns but I strongly recommend using RegexStorm as it is 100% compatible with UiPath …

This solution provided by @nice-guy received 1 likes!

データスクレイピング時の型変換エラー

Yoichi さん、回答ありがとうございました。別スレットを立てて質問しますので、よろしくお願いします。

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

Filter column by condition?

Use my sequence for reference TestA.xaml (13.0 KB) read config and input to configDt and inputDt datatables [image] loop configDt, in each iteration, filter input Dt so that APAPDT >=APAPDT1 and <= APAPDT2 and output filtered table to filterdDt write filteredDt to FileName.xlsx [image] Result Report1.xlsx [image] Report2.xlsx [image]

---

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 | 21 March 2022

Top 3 Topics with Most Views

Copy specific column from one excel to another excel last row with specific column made by @mashy2 with 44 views.

How to get Particular file From directory made by @Anand_Designer with 44 views.

"SMTP Mail" fails on one computer and works on another made by @Aguirre with 44 views.

Top 3 Topics with Most Replies

How to get Particular file From directory made by @Anand_Designer with 17 replies.

Assign: An item with the same key has already been added made by @Sirisha_Siri with 16 replies.

Unable to Scrap the text using Matches Activity made by @Omkar_Deshmukh with 14 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 39 posts!

@ppr made 28 posts!

@ashwin.ashok made 23 posts!

Top 3 Most Liked Posts

This post made by @Debakanta_Mahanta received 2 likes!

Combo-Dropdown - Web Automation

Hi Swapnil, You can directly navigate to the url assigned to Ruling by MahaRERA href=“https://maharerait.mahaonline.gov.in/searchlist/SearchJudgements?MenuID=1072” [image] Thank you Debakanta

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

Change picture/icon in Assistant

Hi @Timsener , It looks like its still a work in progress as detailed in this thread by UiPath → Kind Regards, Ashwin A.K

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

Write cell beyond a to z range in Gsuite - Google Sheets?

Hi @Pruthvi.G , I understand that, but you wanted the range, correct? This snippet of code with allow you to compute the range, which you can them pass into the range like so → [image] UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(32) + int_index.ToString Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

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

Change picture/icon in Assistant

Hi @Timsener , It looks like its still a work in progress as detailed in this thread by UiPath → Kind Regards, Ashwin A.K

This solution provided by @ppr received 2 likes!

Regex or String manipulation needed in order to insert a new line before a value

[grafik] (\d+ [\d\/]{10})

This solution provided by @Yoichi received 1 likes!

Remove Odd items from Array

Hi, Hope the following helps you. Remove even: arrVar = arrVar.Where(Function(x,i) i mod 2 =1).ToArray() Remove odd: arrVar = arrVar.Where(Function(x,i) i mod 2 =0).ToArray() 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 | 22 March 2022

Top 3 Topics with Most Views

How to train same custom DU model multiple times? made by @shrey.shah with 50 views.

How to copy sheet from Excel to another with a new sheet name made by @Archie with 50 views.

Problems with selectors made by @Pavel_Shlykevich with 46 views.

Top 3 Topics with Most Replies

How to copy sheet from Excel to another with a new sheet name made by @Archie with 21 replies.

How to add date in google forms throgh excel sheet? made by @guptasweb with 20 replies.

Get date value as a string made by @Pradumn_Chavan with 18 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 43 posts!

@fernando_zuluaga made 27 posts!

@ppr made 25 posts!

Top 3 Most Liked Posts

This post made by @Tuan_Nguyen1 received 2 likes!

Performance Desktop Triggers

Thanks, this is very helpful. I’ll take a look and discuss what we can do with the team.

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

Type into letters skipping

Hi @Rahul_54 We have a property called delay between keys So kindly use this property where set it 200 ms Note :Adjust as per your website behaviour Thanks

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

Add amounts Found using Regex

Hi @spemur01 , There are two way to sum up the values, and I have detailed both in this workflow. Please have a look and let me know if it is as expected. Single Step → [image] matches.Cast(Of Match).Sum(Function(s) Convert.ToDouble(s.ToString.Replace(",",""))) Using For Each ->(TypeArgument: System.Text.RegularExpressions.Match) [image] doub_sumLoop= doub_sumLoop+Convert.ToDouble(match.ToString.Replace(",","")) MatchandSum.xaml (7.1 KB) Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

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

Type into letters skipping

Hi @Rahul_54 We have a property called delay between keys So kindly use this property where set it 200 ms Note :Adjust as per your website behaviour Thanks

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

Add amounts Found using Regex

Hi @spemur01 , There are two way to sum up the values, and I have detailed both in this workflow. Please have a look and let me know if it is as expected. Single Step → [image] matches.Cast(Of Match).Sum(Function(s) Convert.ToDouble(s.ToString.Replace(",",""))) Using For Each ->(TypeArgument: System.Text.RegularExpressions.Match) [image] doub_sumLoop= doub_sumLoop+Convert.ToDouble(match.ToString.Replace(",","")) MatchandSum.xaml (7.1 KB) Kind Regards, Ashwin A.K

This solution provided by @supermanPunch received 1 likes!

Combo-Dropdown - Web Automation

Hi @Swapnil_Pawar , We should be able to Hover over the Dropdowns and Click the "Rulings By MahaRERA" option. Hover over Downloads, then Hover Over Maharashtra and Perform a Click on Rulings By MahaRERA Check the Below Workflow and Let us know if it doesn’t work : Dropdown_Click.xaml (14.3 KB)

---

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 March 2022

Top 3 Topics with Most Views

LINQ query for filtering made by @A_Learner with 57 views.

Needed Uipath Activities for Text document(Notepad) made by @arunprasanth_m with 51 views.

Using Refresh Browser in a Loop until Element appears made by @djkmod83 with 47 views.

Top 3 Topics with Most Replies

Send hotkey is not supporting, while trying to scroll down in excel made by @shuklarchana001 with 24 replies.

Not able to use Type Into and Set Text activity to fill out a web form made by @harmeet_kaur with 20 replies.

Specific Text Extraction from SAP Page made by @Tarif_Mohammad with 18 replies.

Top 3 Users Who Posted The Most

@ppr made 28 posts!

@fernando_zuluaga made 27 posts!

@postwick made 26 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 2 likes!

How to automate in a survey a number of answers for option 1 and another number of answers for option 2? (it also contains multiple answers to be checked)

Hi @robertcostache , Could You Explain what do you mean by these Percentages? Is it the Percentage of times the Option is Selected out of 900 times ?

This post made by @THIRU_NANI received 2 likes!

Assistant is not working

Hi! delete the json folder in the file explorer and run the studio again! Regards, Nani

This post made by @suraj.setty received 2 likes!

How to train same custom DU model multiple times?

Hi @shrey.shah I would suggest to follow the document as per the best practice , I think my method may not work every time. You can select the Minor version as 0 as suggested in the article. Thanks .

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to make a replace in a string irrespective of string length?

Hi, Can you try the following expression? System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=^.{6}).*(?=.{4}$)",Function(m) New String("X"c, m.Value.Length)) Regards,

This solution provided by @Jeroen_van_Loon received 1 likes!

How to write a if statement based on percentage

Your if then else reults are swithced around. You state if resultstwo > 0,8 then writeline less than 80. > means greater then… so switch the then and else sub-sequences around and you have it correct.

This solution provided by @Gokul001 received 1 likes!

Needed Uipath Activities for Text document(Notepad)

I n this workflow, Just update the date in the Type Into Activity DateTime.Now.ToString("yyyyMMdd") DateTime.Now.AddDays(-1).ToString("yyyyMMdd") [image] 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 | 24 March 2022

Top 3 Topics with Most Views

Yang Miss,请赐教 made by @bigpeng with 54 views.

Unable to browser attach in ForEachRow made by @SJJ with 47 views.

How to append the data into excel using Add Data row activity made by @mayankjha986 with 46 views.

Top 3 Topics with Most Replies

Find exact Match and replace the tex file made by @Shagoul_Hameed with 17 replies.

Yang Miss,请赐教 made by @bigpeng with 16 replies.

How to append the data into excel using Add Data row activity made by @mayankjha986 with 15 replies.

Top 3 Users Who Posted The Most

@ushu made 33 posts!

@fernando_zuluaga made 31 posts!

@Gokul001 made 25 posts!

Top 3 Most Liked Posts

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

Copying from one list to another

Hi @Igor_Wolny , Here is another way to approach the problem. I hope it gets you thinking in creative ways → lst_masterSet = New List(Of String) From {"Ai123", "Ai243", "Bi344", "Bi3443", "Ci24244", "Ci48484"} lst_searchCriterias = lst_masterSet.Select(Function(s) s.Substring(0,2)).Distinct().ToList() dict_items = lst_searchCriterias.ToDictionary(Function(k) k, Function(v) lst_masterSet.Where(Function(w) w.StartsWith(v)).ToList()) ListExercise.xaml (5.9 KB) Kind Regards, Ashwin A.K

This post made by @JFletch100 received 1 likes!

How to set execution target for 'Queue' trigger type?

Is there a fix for this issue or are they hoping that by ignoring it, the issue will go away?

This post made by @andrewjames received 1 likes!

Bug Report - System.Activities.statements.Assign activity throws Cannot implicitly convert type 'object' to 'string'. An explicit conversion exists (are you missing a cast?)

I had the same issue today with a multiple assign in 2021.10.5 To fix it I opened the XAML into notepad, and changed the “object” references to “string” and this fixed the issue. Unfortunately I can’t remember the steps I used when creating the multiple assign.

Top 3 Most Liked Solutions

This solution provided by @Gokul001 received 1 likes!

How to convert Json to data table

Hi @red_yan Welcome to community Look into the documentation Regards Gokul

This solution provided by @ppr received 1 likes!

V2.11.4 excel process scope

[grafik] And with index [grafik]

This solution provided by @postwick received 1 likes!

Copying from one list to another

Use Debug instead of Run. Then right-click your activities and set breakpoints. It’ll pause at each breakpoint and then you can look at the debug panels on the left to see the realtime values of each variable/list.

---

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 March 2022

Top 3 Topics with Most Views

Merge column in Datable & calculate value (LINQ) made by @fairymemay with 62 views.

How to do sum on dynamic columns in Excel made by @vinjam_likitha with 52 views.

The "Open Browser" Activity is missing made by @cui.z.1 with 46 views.

Top 3 Topics with Most Replies

Merge column in Datable & calculate value (LINQ) made by @fairymemay with 17 replies.

Unable to fetch data from excel when having value is 0 made by @shuklarchana001 with 12 replies.

How to do sum on dynamic columns in Excel made by @vinjam_likitha with 12 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 27 posts!

@ushu made 22 posts!

@ppr made 21 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Remove part of string after last occurrence of delimiter "/"

we can do it with regex: [grafik] or using string method Split and join it again

This post made by @ushu received 1 likes!

How to terminate the UIPath process with a messagebox cancel button

@bencemarci You can terminate the process using terminate workflow activity. Please find the related work flow for this process MessageBox.zip (2.3 KB) Please use below video for more info on terminate workflow activity [UiPath Terminate Workflow Example]

This post made by @RAKESH_KUMAR_BEHERA received 1 likes!

UiPath Orchestrator New Version (2022) | By Rakesh

Learn how to use the new orchestrator UiPath user interface quickly. This video will show you how to navigate the new interface and upload a project to Orchestrator. This video will walk you through the process of successfully adding machines, robots as well as developing processes and deploying the uipath studio built project. This video will serve as an excellent introduction to the new version of uipath orchestrator 2022. [UiPath Orchestrator New Version (2022) | By Rakesh]

Top 3 Most Liked Solutions

This solution provided by @ushu received 1 likes!

How to terminate the UIPath process with a messagebox cancel button

@bencemarci You can terminate the process using terminate workflow activity. Please find the related work flow for this process MessageBox.zip (2.3 KB) Please use below video for more info on terminate workflow activity [UiPath Terminate Workflow Example]

This solution provided by @Yoichi received 1 likes!

I want to compare two datatable and put them in a new datatable

Hi, There are some ways to achieve this. One of them, we can use LeftJoin. The following will help you. Regards,

This solution provided by @Yoichi received 1 likes!

Looking Assistant with excel

Hi, If there is possibility it returns no row, first get datarow array using the following expression, then use CopyToDataTable when its length is larger than 0. arrDataRow = (From a In dt1.AsEnumerable Group Join b In dt2.AsEnumerable On a("bill number").ToString Equals b("bill number").ToString Into grp = Group From row In grp.DefaultIfEmpty() Select If(row Is Nothing, dtResult.LoadDataRow({a("Name"),a("amount"),a("bill number"),a("account"),a("Others"),"",""},…

---

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 March 2022

Top 3 Topics with Most Views

Could not find the user interface(UI) element for this action made by @Liya_Sunny with 38 views.

Document understanding Algorithm? made by @vivek_sinha with 33 views.

Count PDF Pages made by @momo10 with 29 views.

Top 3 Topics with Most Replies

Could not find the user interface(UI) element for this action made by @Liya_Sunny with 10 replies.

System.String item cannot display all related methods made by @vrbkrpa1982 with 6 replies.

Read range (Settings and Constants sheets): Could not load file or assembly ‘ClosedXML, Version=0.87.0.0 made by @SandeepPanchal with 5 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 31 posts!

@Sudharsan_Ka made 6 posts!

@Liya_Sunny made 5 posts!

Top 3 Most Liked Posts

This post made by @Apple received 2 likes!

Argument Value

Thanks it works

This post made by @Gokul001 received 1 likes!

Read range (Settings and Constants sheets): Could not load file or assembly ‘ClosedXML, Version=0.87.0.0

Hi @SandeepPanchal Can you update the dependencies mentioned below, UiPath.Excel.Activities UiPath.MicrosoftOffice365.Activities Update the package and try running the process. Regards Gokul

This post made by @Gokul001 received 1 likes!

Insert Name from excel column into Outlook email body

Hi @jibroni Use → Save For Later activity it will act like assign activity in Studio Have a look on the user interface of Studiox Regards Gokul

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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 March 2022

Top 3 Topics with Most Views

Queue status in orchestrator made by @T_Y_Raju with 39 views.

How to Configure Get IMAP Mail Message Activity in Ui path made by @varun_shinde1 with 37 views.

Create multiple sheets in excel file based on records made by @avinashy with 36 views.

Top 3 Topics with Most Replies

For each row in Table and If condition (build data table OK / Add data row OK) made by @Felipe_Sternberg with 19 replies.

Can Someone help me with filtering excel column which has a date made by @shilpa_p with 11 replies.

Error in Inner Join Data Tables using custom LINQ made by @kit2815 with 8 replies.

Top 3 Users Who Posted The Most

@ashwin.ashok made 15 posts!

@lakshman made 6 posts!

@Felipe_Sternberg made 5 posts!

Top 3 Most Liked Posts

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

Create multiple sheets in excel file based on records

Hi @avinashy , That can be achieved by converting the DataTable into a List of DataTables each containing 10 records. But how you want to go about naming each sheet is still unclear, so I’ve given generic names followed by indexes (Sheet2, Sheet3…Sheetn) The logic for that is detailed below → [image] Enumerable.Range(0,CInt(Math.Ceiling(dt_sampleData.Rows.Count()/10))).Select(Function(s) dt_sampleData.AsEnumerable.Skip(s*10).Take(10).CopyToDataTable()).ToList() Could you give this a try a…

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

How to Configure Get IMAP Mail Message Activity in Ui path

Hi @varun_shinde1 , You might have to enable few settings in your account for this to happen. Maybe this link could be of help? Kind Regards, Ashwin A.K

This post made by @NIVED_NAMBIAR received 1 likes!

Edit code LINQ?

@fairymemay For updating the different columns, you had to use the code like this as below DT_TextFile.AsEnumerable().ToList().ForEach(Sub(row) row("FPP")= CDbl(row("FPP").ToString)/Cdbl(row("Case").ToString)) DT_TextFile.AsEnumerable().ToList().ForEach(Sub(row) row("APSUM")= CDbl(row("APSUM").ToString)/Cdbl(row("Case").ToString)) Try this approach Thanks & Regards, Nived N

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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 March 2022

Top 3 Topics with Most Views

string.Contains() not working made by @ainaasyhda with 53 views.

How to get TransactionItem Number? made by @MasterSinge with 48 views.

I need to check if the second variable contains 70% of the first variable made by @ridvanucok with 47 views.

Top 3 Topics with Most Replies

Get Asset - You are not authenticated! Error Code: 0 made by @Craig_Bannerman1 with 20 replies.

Cannot Trigger UiPath Robot after Update to latest UiPath studio version made by @Ashok_kumar7 with 14 replies.

Delete column (error Copytodatable is not a member) made by @fairymemay with 13 replies.

Top 3 Users Who Posted The Most

@Gokul001 made 30 posts!

@ashwin.ashok made 28 posts!

@ushu made 28 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

This post made by @shalini.singh received 2 likes!

Care Health Insurance - RPA Developer - Gurgaon - India - Full Time

Job title: RPA Developer Job role: RPA Developer Country: India City: Gurgaon Company name: Care Health Insurance Employment Type: Full Time Seniority level: Junior 1 to 2 years Job Description: Role Description • Design the automation workflows, write the code using UiPath • Make changes to the robot code during implementation as needed • Responsible for the overall testing cycles Requirements • Graduate in Computer Science/IT or equivalent Degree • Analytical and proven problem-s…

This post made by @Yoichi received 2 likes!

BC20198 ')' expected at Line 1

Hi, FYI, VB expression for it will be the following. in_dt_dsrDtRaw.AsEnumerable().ToList().ForEach(Sub (row) If(row("INVOICE_NUMBER").tostring.substring(0,3)="950") Then row("BILLED_QTY")=0 row("LOCAL_CURR_AMOUNT") = Double.Parse(row("LOCAL_CURR_AMOUNT").ToString) * -1 row("NET_AMOUNT")=Double.Parse(row("NET_AMOUNT").ToString) * -1 End If End Sub )

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

BC20198 ')' expected at Line 1

Hi, FYI, VB expression for it will be the following. in_dt_dsrDtRaw.AsEnumerable().ToList().ForEach(Sub (row) If(row("INVOICE_NUMBER").tostring.substring(0,3)="950") Then row("BILLED_QTY")=0 row("LOCAL_CURR_AMOUNT") = Double.Parse(row("LOCAL_CURR_AMOUNT").ToString) * -1 row("NET_AMOUNT")=Double.Parse(row("NET_AMOUNT").ToString) * -1 End If End Sub )

This solution provided by @ppr received 2 likes!

Get Asset - You are not authenticated! Error Code: 0

[image] [/quote] not sure if an explicit reference to UiPath.Activities.Api is needed. Check its removal also

This solution provided by @Gokul001 received 2 likes!

Edit code LINQ?

Hi @fairymemay Why you need to delete the column? Have a look on the thread 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 | 29 March 2022

Top 3 Topics with Most Views

Excel「yy-mm-dd（文字列）」を「yyyy/mm/dd（数値）」にしたい made by @peanuts with 48 views.

What is the licensing fee for 1 developer? made by @Rodrigo_Buch with 47 views.

About screen scraping made by @swapnilpatil8200 with 42 views.

Top 3 Topics with Most Replies

How To Get Data From Filter Array Of Strings made by @burakavuncu with 18 replies.

How to ignore attachments(images) embed in mail body made by @VISHNU07 with 15 replies.

How to extract data from handwritten text pdf? made by @raju_alakuntla with 14 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 32 posts!

@fernando_zuluaga made 23 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @Lucas.Pimenta received 2 likes!

Winners: UiPath Apps Product Feedback

Congratulations!!

This post made by @StefanSchnell received 2 likes!

SAP.Middleware.Connector.RfcCommunicationException

@LevKushnir Hello Lev, nope. RC = Return Code RFC_RC 18 = RFC_NOT_SUPPORTED, the operation is not supported on that handle. This is a rather rare error that I have never encountered. CPIC 00024 = CM_PROGRAM_PARAMETER_CHECK (SAP Note 63347) Maybe a parameter is invalid or passed in the wrong format? Best regards Stefan

This post made by @LevKushnir received 2 likes!

SAP.Middleware.Connector.RfcCommunicationException

@DanaKz see the post above, it sounds like something wrong with parameteres. thanks, @StefanSchnell

Top 3 Most Liked Solutions

This solution provided by @ridvanucok received 1 likes!

Excel Formula Write

Burak, Evet, Türkçe kullandığın Excel’de sıkıntı yaşaman çok normal. Eğer kurumsal bir proje yapıyor isen, Excel’in dilini ingilizceye çevirmen daha sağlıklı olacaktır. Bende de şuan Türkçe excel yok o yüzden deneyemiyorum. Excel’i Türkçe olarak değiştiremiyorum diyorsan ona göre bir çözüm arayalım. Not: Forum’da bizden birilerini görmek güzel

This solution provided by @ridvanucok received 1 likes!

PDD Word Template

Hi @Kakooza-Allan-Klaus, Does this empty template satisfy the request? Blank PDD Template.docx (266.0 KB)

This solution provided by @Yoichi received 1 likes!

Save Image from variable ICollection<object> to local folder

Hi, I think it’s better to use List<UiPath.Core.Image> as @lakshman mentioned. However if you need to use ICollection<Object> for some reason, the following will work. [img20220329-a1] TypeArgument of ForEach is object. And Image property of SaveImage is as the following. CType(item,UiPath.Core.Image) 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 | 30 March 2022

Top 3 Topics with Most Views

Regex / split without delimitter made by @Aldhyt_Wirangga1 with 64 views.

Delete or Remove an entire Row in excel on the basis of some Condition made by @Mayank_Soni with 45 views.

Unable to run script after rdp disconnects made by @Mathkar_kunal with 42 views.

Top 3 Topics with Most Replies

Create Project Failed? made by @eric.chen with 23 replies.

Regex / split without delimitter made by @Aldhyt_Wirangga1 with 15 replies.

Active Directory- Get Object Properties For Each Data in Excel made by @burakavuncu with 15 replies.

Top 3 Users Who Posted The Most

@ushu made 28 posts!

@lakshman made 26 posts!

@suraj.setty made 20 posts!

Top 3 Most Liked Posts

This post made by @Sam_Abraham received 3 likes!

What is the difference between the open browser and attached browser

Hi @meeraa Open browser is used to open a browser at a specified URL and execute multiple activities within it Attach browser is used to attach to an already opened browser and perform multiple actions within it.

This post made by @DanaKz received 2 likes!

SAP.Middleware.Connector.RfcCommunicationException

@StefanSchnell thank you very much, issue was resolved by using your advice on how to code password string. @LevKushnir thank you for your help!

This post made by @ordo received 2 likes!

BAPI_REQUISITION_CREATE - Need additional fields

HI Pratik, you can not simply add fields to an existing accelerator. The accellerator does rely on the fields being available in the BAPI itself. If you send fields to the BAPI which this BAPI doesn’t understand, you will get an error. However you can easily add support for additional BAPIs, in your case BAPI_PR_CREATE. The easiest way would be to: Copy the directory of an existing BAPI in the accellerator. Rename the files to follow the schema with the BAPI name in the artifacts. Modify t…

Top 3 Most Liked Solutions

This solution provided by @Sam_Abraham received 3 likes!

What is the difference between the open browser and attached browser

Hi @meeraa Open browser is used to open a browser at a specified URL and execute multiple activities within it Attach browser is used to attach to an already opened browser and perform multiple actions within it.

This solution provided by @ppr received 2 likes!

Regex

give a try at: [grafik]

This solution provided by @Gokul001 received 2 likes!

Save Email Attachments Saves Images

HI @hurmet.noka Actually, the Filter property from Save Mail Attachment will filter on which attachments should be saved. The filter should be in RegEx format. Try to use “.csv” in the filter Or Try to use “.*(.CSV|.Csv|.CSv|.csv)” in the filter [image] Have a look on the thread 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 | 31 March 2022

Top 3 Topics with Most Views

Why cant we have two or more answers as solution made by @Aida_Azar with 52 views.

Help in Wait for download made by @Ashok98 with 48 views.

Date extraction from PDF is not working! made by @Joker with 47 views.

Top 3 Topics with Most Replies

Date extraction from PDF is not working! made by @Joker with 25 replies.

How to get a dynamic Links in Mail Body content? made by @keerthi_arumugam with 18 replies.

How to remove Multiple Headers from CSV file made by @vishal_nachankar with 17 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 30 posts!

@fernando_zuluaga made 22 posts!

@ppr made 20 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Find the lowest and click

do a check on following strategy extract datatable / data calculate lowest price e.g. with a linq dtData.AsEnumerable.Min(Function (x) Cint(x("Price").toString.Trim)) Use a dynamic selector for the click

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

Winners: UiPath Apps Product Feedback

Congratulations for All the winners

This post made by @luis.h.assali received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi all! My name is Hernan or Nan for short . I’m starting to learn UiPath for my current job position so I really new on all this. I hope to learn a lot and eventually be able to help others. Thank you!

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Find the lowest and click

do a check on following strategy extract datatable / data calculate lowest price e.g. with a linq dtData.AsEnumerable.Min(Function (x) Cint(x("Price").toString.Trim)) Use a dynamic selector for the click

This solution provided by @Akiyo_Yamada received 1 likes!

Reporting typos in Documentation and Academy / ドキュメントとアカデミーのテキストの誤字のお知らせ

@vtomaixe 様 3点目のアカデミーコンテンツに関するご指摘についても修正が完了いたしましたので、お手すきの際にご確認いただけますと幸いです。 よろしくお願いいたします。

This solution provided by @Yoichi received 1 likes!

JArray Select/LinQ to select positions

Hi, The following will work. Can you try this? ja = New JArray(ja.Where(Function(j) j("URL").ToString.Contains("www.the-thing-i-want.com"))) note: ja is JArray Regards,

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

@Gokul001 received 92 likes for their solutions!

@Yoichi received 58 likes for their solutions!

@ashwin.ashok received 52 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 April 2022

Top 3 Topics with Most Views

Creation of classic entities is disabled! Use modern folders instead! made by @Shagoul_Hameed with 63 views.

Can anyone help me to extract from excel and send the data row to mail made by @shilpa_p with 52 views.

Unable to click click image after vpn disconnects made by @Mathkar_kunal with 50 views.

Top 3 Topics with Most Replies

Unable to click click image after vpn disconnects made by @Mathkar_kunal with 23 replies.

How add a column from a datatable to another datatable? made by @wdescalsota with 23 replies.

If select option is not available then move to another activity made by @Naveen_Kumar2 with 16 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 39 posts!

@lakshman made 32 posts!

@ushu made 25 posts!

Top 3 Most Liked Posts

This post made by @sudheern received 1 likes!

Performance Desktop Triggers

Thanks @Tuan_Nguyen1 , this is very useful , i am looking for this from 2018 onwords , as it is not there i developed code for that when USB plug in the baby cry if not baby stops cry [How to Wild Uipath Robot Sound Effect | Baby Crying Robot Sound Effect Part 1 | RPA | UiPath Learner]

This post made by @suraj.setty received 1 likes!

Creation of classic entities is disabled! Use modern folders instead!

Hi @Shagoul_Hameed You can try this workaround Please create a Queue in Modern folder and Link the created Queue to the Classic folder. [image] Next [image]

This post made by @Shagoul_Hameed received 1 likes!

Creation of classic entities is disabled! Use modern folders instead!

Hi all, i am unable to create a queue in the classic folder which was working fine elariler… “Creation of classic entities is disabled! Use modern folders instead!” any solution ? [image]

Top 3 Most Liked Solutions

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

Creation of classic entities is disabled! Use modern folders instead!

Hi @Shagoul_Hameed @raool90 @Filipe_Vitorino1 @Kiran-Kishore, If your organization is on the community licensing plan, kindly take a look at this topic: Hope it helps you guys!

This solution provided by @ushu received 1 likes!

What is the minimum amount of files for a UI Path Studio process project?

@Bence_Domokos Yes for a basic automation you need only Main.xaml and Project.json. But when it is lengthy process it is best practice to create chunks of code in multiple workflows. In this case you will have different files. Definitely you can zip the whole project and send to some one When coming to the images folder, UiPath automatically creates it, to save the image when you select an element in an application. So, you need not to worry about this folder

This solution provided by @lakshman received 1 likes!

Uipath marketplace activities download

@ydash999 Yes it’s not required. You already got the business solution and you can use it directly without installation anything.

---

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 April 2022

Top 3 Topics with Most Views

Read Range question made by @A_Learner with 39 views.

AWS RDSに接続してデータを取得する方法 made by @RYOKO0306 with 37 views.

Merging duplicate rows in a data table made by @Aluvala_Vamshi_Krishna with 34 views.

Top 3 Topics with Most Replies

Retry Issue on Every single Activity made by @Shyam_Pragash with 14 replies.

How to have default value selected in radio button in input dialog box made by @Deepa_Madkar with 9 replies.

Read Range question made by @A_Learner with 9 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 34 posts!

@lakshman made 7 posts!

@A_Learner made 5 posts!

Top 3 Most Liked Posts

This post made by @trog received 2 likes!

REFramework: any arguments not to use it?

I’ve always been a proponent of the REFramework, because it essentially works out of the box, including exception handling, logging and pretty much anything you’d need for an enterprise robot. Perhaps you might want to tweak a few things, but the basis is solid. Recently I’ve started working with a few developers who do not wish to use the REFramework and wanted to create their own thing instead, from scratch. I was a bit shocked… why reinvent the wheel when the REFramework already exists? Cou…

This post made by @Deepa_Madkar received 1 likes!

How to make default selection in the Input Dialog Box?

Hey @Florent_Salendres Regarding the solution which u provided for getting default radio button selection. Can u pls explain how to achieve this using parallel activity. Input dialog box is not UIelement so how can i use Select activity to select one of the radio buttons as selected? It will be really helpful if u can provide some answer please. Thanking you in advance

This post made by @nicolas.topart received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello all, My name is Nicolas. I’m starting RPA with Studio X and it’s pretty cool . I did few processes but i face some trouble particularly about exceptions ! So, i’m here to fix that with your help. Thanks Nico

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 1 likes!

Rename process name?

Hi @fairymemay You can rename the project from the settings and also while publishing make sure the required name is maintained. Thanks #nK

This solution provided by @Jesmine received 1 likes!

Logic in UiAutomation

Thanks! I have did it by own

---

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 April 2022

Top 3 Topics with Most Views

DataTable filter issue made by @cury with 41 views.

Email automation beginner made by @Ang_Weng_Fook with 39 views.

Email automation with excel sheet made by @Ang_Weng_Fook with 39 views.

Top 3 Topics with Most Replies

DataTable filter issue made by @cury with 9 replies.

Cannot add Queue to UiPath Apps made by @Sarmad_Nadeem with 9 replies.

Cannot perform click text on webpage made by @aqiff with 9 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 13 posts!

@lakshman made 12 posts!

@Yoichi made 8 posts!

Top 3 Most Liked Posts

This post made by @Deepa_Madkar received 1 likes!

How to make default selection in the Input Dialog Box?

yes @Nithinkrishna

This post made by @Deepa_Madkar received 1 likes!

How to have default value selected in radio button in input dialog box

Thanks for the reply @Nithinkrishna But my requirement is like: ‘Yes’ and ‘No’ options should be displayed to the client with ‘Yes’ option selected as default. If client thinks whatever displayed is incorrect then he will select ‘No’ If possible can you suggest any solution to achieve this requirement @Nithinkrishna Thanks in advance

This post made by @Deepa_Madkar received 1 likes!

How to have default value selected in radio button in input dialog box

Hi @Nithinkrishna , i am not sure wthr form activities are allowed. There are some restrictions in terms of activities to be used. But still any solutions can u provide for the issue i am facing ? Thank u for taking some time out.

Top 3 Most Liked Solutions

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

Simple RegEx question

Hi @natasha6 , The period can be escaped using a forward slash like so → [image] (?<=Invoice No\.\s).* As for the second text, you can detect the required section using this pattern → [image] (?<=Job\r?\n).*(?=\sPage) Kind Regards, Ashwin A.K

This solution provided by @lakshman received 1 likes!

How to update a value to NOTHING if the length of string is more than 200 using LINQ

@Sirimalla_Karthik_Chandra Let’s say your input DataTable is InputDT Try below expression in Invoke Code activity to do that. InputDT.AsEnumerable().ToList().ForEach(Sub(row) row(“ColumnName”) = If(row("ColumnName").ToString.Trim.Length > 200, "Nothing", row("ColumnName").ToString.Trim) Note: Create one argument for Invoke Code activity and mention properties as below. Name - InputDT Direction - In Type - DataTable Value - InputDT

This solution provided by @Yoichi received 1 likes!

How can we enable green tick in my activity

Hi, FYI, can you see the following? 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 | 04 April 2022

Top 3 Topics with Most Views

Can anyone help me with the logic on how to find the latest link on a webpage made by @shilpa_p with 46 views.

Identify Unique rows based on specific columns made by @vishal_nachankar with 44 views.

How to have a value selected by default in input dialog box activity made by @Deepa_Madkar with 43 views.

Top 3 Topics with Most Replies

Can anyone help me with the logic on how to find the latest link on a webpage made by @shilpa_p with 24 replies.

Retry Scope stopped working made by @Chris_Balance with 21 replies.

Download a file from winscp made by @supu123 with 16 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 45 posts!

@ushu made 20 posts!

@ashwin.ashok made 19 posts!

Top 3 Most Liked Posts

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

Monthly Forum rewards - March 2022

The satisfaction gained from helping each other out on the Forum is the real reward Congratulations to everyone who made it to the Leaderboard! Kind Regards, Ashwin A.K

This post made by @Gokul001 received 6 likes!

Monthly Forum rewards - March 2022

Congrats to all the fellow mates Keep up the good work Regards Gokul

This post made by @suraj.setty received 4 likes!

Monthly Forum rewards - March 2022

It’s been a great Month, congratulations to all the winners, specially @ashwin.ashok for the top notch. Keep helping each other. Thanks.

Top 3 Most Liked Solutions

This solution provided by @kiran.suryavanshi received 2 likes!

How to create mail folder/ sub folder using IMAP?

Hi All, Found a solution to create mail folders using IMAP programmatically with help of python. It’s quite easy. Posting the solution below so it would help the community. import imaplib M = imaplib.IMAP4_SSL("imap.example.org","port number in integer") M.login("username", "password") M.create("New Folder Name") M.logout Please note, you can create nested folder in one go as well. All you have to do is separate folder name by forward slash / e.g. Inbox/SubFolder1/SubFolder2 Happy Automat…

This solution provided by @Yoichi received 1 likes!

Identify Unique rows based on specific columns

Hi @vishal_nachankar , I’d like to confirm your requirement. If input data is as the following, column1,column2,column3,column4 ABC,xxx,123,yyy ABC,xxx,123,yyy AAA,xxx,123,yyy tys,yyy,334,yyy tys,yyy,334,yyy yru,ooo,999,ppp Is expected output still the following? column1, column2,column3,column4 ABC,xxx,123,yyy tys,yyy,343,yyy yru,ooo,999,ppp OR column1,column2,column3,column4 ABC,xxx,123,yyy AAA,xxx,123,yyy tys,yyy,334,yyy yru,ooo,999,ppp If former, the expression will be as the followi…

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

L'activité HTTP est frappée

Hi @Peter_D Essayez de rétrograder le package vers une version légèrement inférieure j’espère que cela pourrait aider ( Please try Downgrading the package) 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 | 05 April 2022

Top 3 Topics with Most Views

Drop Down Menu Error made by @khooshbu.jani with 57 views.

Filter by use Linq? made by @fairymemay with 47 views.

Uipath stimulate type into (enter key) made by @Munish_Jain with 44 views.

Top 3 Topics with Most Replies

How to click on first row of column after searching a value made by @sambulkar with 29 replies.

Drop Down Menu Error made by @khooshbu.jani with 29 replies.

Filter by use Linq? made by @fairymemay with 23 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 59 posts!

@ushu made 30 posts!

@supermanPunch made 28 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 4 likes!

Monthly Forum rewards - March 2022

Congratulations to all the winners keep rocking and continue the same. @Gokul001, @ashwin.ashok, @ppr , @Yoichi, @postwick , @Palaniyappan Regards, Arivu

This post made by @Steven_McKeering received 3 likes!

How to get the required output from given input using regex or trim or anything? Please help

Hi @anjasing Take a look at these options: Option 1 Option 2 Option 3 If you want to learn Regex Check out my Regex MegaPost Can you expand upon the pattern of text. What is consistent? Cheers Steve EDIT: I had the wrong sample Input Alright, logging off for today

This post made by @Nithinkrishna received 2 likes!

Hello, How to split string

Hey @Bot_Learner Just try this, Str1.Split(" "c).Last Hope this helps Thanks #nK

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Hello, How to split string

Hey @Bot_Learner Just try this, Str1.Split(" "c).Last Hope this helps Thanks #nK

This solution provided by @Gokul001 received 1 likes!

How to get the required output from given input using regex or trim or anything? Please help

Hi @anjasing Try this regex expression System.Text.RegularExpressions.Regex.Match("InputStr","(?<=Program\s:\s)(\S+)").Tostring.Trim [image] Regards Gokul

This solution provided by @Nithinkrishna received 1 likes!

Send Slack Message using random Tokens

Hey @hurmet.noka Here you find the sample. I don’t have the API key so just made a sample array. Kindly replace it with your valid one. [nmnithinkrishna_UiPath_SlackIntegration with random tokens] [nmnithinkrishna_UiPath_SlackIntegration with random tokens] PFA - nmnithinkrishna_SlackRandomTokenUseForAuth.zip (4.1 KB) 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 | 06 April 2022

Top 3 Topics with Most Views

Automate using UIPATH made by @anmita with 41 views.

Get Attribute -aastate IE vs EDGE made by @Brano with 40 views.

Filter Data table having only date value made by @RENU_KHALKHO with 38 views.

Top 3 Topics with Most Replies

Orchestrator is loading and not opening made by @sushmitha.e with 17 replies.

Filter Data table having only date value made by @RENU_KHALKHO with 14 replies.

How to remove column row (csv file) made by @pankajdhane with 14 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 53 posts!

@Palaniyappan made 36 posts!

@ashwin.ashok made 27 posts!

Top 3 Most Liked Posts

This post made by @Nithinkrishna received 2 likes!

Introducing Automation Cloud Robot - Serverless! Limitless robot power with zero infrastructure

This sounds cool !

This post made by @Arvind_Kumar1 received 2 likes!

Introducing Automation Cloud Robot - Serverless! Limitless robot power with zero infrastructure

This is amazing !!!

This post made by @B_Bastien received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello , My name’s Bastien and I’m starting to learn how to dev in RPA using the UiPath tools , mostly Studio. I hope I can learn as much as possible around here !

Top 3 Most Liked Solutions

This solution provided by @Nithinkrishna received 2 likes!

Am I stupid or I cant multiply double here?

Hey @hurmet.noka Try this once please. CInt(CurrentRow.Item("Target"))*5 Thanks #nK

This solution provided by @Nithinkrishna received 1 likes!

Deserialize JSON Response & Access properties

Hey @manoj2500 Here are the samples, For a normal property, jObj("propertyname").ToString For an Array, jObj("propertyname")(0).ToString Thanks #nK

This solution provided by @jauharul received 1 likes!

Get specific value from Data table into String Variable

Thanks, This are the answer of the syntax. thanks ya.

---

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.