Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 March 2023

Top 3 Topics with Most Views

Comparison between Einstein OCR (Salesforce OCR) VS UiPath OCR made by @shreyash_shirbhate with 65 views.

Update individual cell in Excel Spreadsheet made by @craig.norton with 63 views.

How to Automatic add the sum of columns values in a same row in UiPath Studio Coding? made by @raghav.bhardwaj.external with 44 views.

Top 3 Topics with Most Replies

How to get data from orchestrator queue made by @sruthesanju with 27 replies.

Google blocks Gsuite made by @aquinn with 20 replies.

Regex to get str values between numbers made by @syezids with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 89 posts!

@supermanPunch made 31 posts!

@Yoichi made 28 posts!

Top 3 Most Liked Posts

This post made by @Manish540 received 4 likes!

指定ファイルパスのフォルダパスを取得する構文は存在しない？

Hi @gorby , You can use below code to get folders from a main folder, System.IO.Directory.GetDirectories(“folderpath”) To get the folder name of a filepath you can use below code, System.IO.Path.GetDirectoryName(“filepath”) Hope this may help you

This post made by @Yoichi received 3 likes!

Lookup Address Values - Unique Values

Hi, It’s because * and ? are special characters in lookup. Can you try to escape it using ~ as the following? row_symbol = row_symbol.Replace("*","~*").Replace("?","~?") Regards,

This post made by @Yoichi received 3 likes!

How to take the first set(ConfigValue) of records in a loop

Hi, FYI, another approach: chunksize = 2000 then arrDt = Enumerable.Range(0,(dt.Rows.Count \ chunksize) -CInt(dt.Rows.Count mod chunksize <>0)).Select(Function(i) dt.AsEnumerable.Skip(i*chunksize).Take(chunkSize).CopyToDataTable).ToArray returns datatable array which has chunksize (2000) rows (the last item has remaining rows) Then iterate this array. Regards,

Top 3 Most Liked Solutions

This solution provided by @Manish540 received 4 likes!

指定ファイルパスのフォルダパスを取得する構文は存在しない？

Hi @gorby , You can use below code to get folders from a main folder, System.IO.Directory.GetDirectories(“folderpath”) To get the folder name of a filepath you can use below code, System.IO.Path.GetDirectoryName(“filepath”) Hope this may help you

This solution provided by @Anil_G received 2 likes!

Migration classic folder to modern folder: Attended robot not displayed

@PeCour You need not reinstall the attended robots…you just need to configure the attended license again once you migrate… You have to create machine templates and users and assign the license to it Users are what are called as robots in the modern folders… you have to create and add them to the respective folder and provide the attended user license Can use this as a started help [UiPath Advance Orchestrator | Assigning Roles to Modern Folders] https://docs.uipath.com/orchest…

This solution provided by @fernando_zuluaga received 2 likes!

Write date as 'Thursday 09th March'?

Hi @Rowley101 Give a try with DateTime.Today.ToString("dddd dd'th' MMMM") 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.