Forum Engagement Daily Reports

[system]

Daily Forum Report | 26 August 2021

Top 3 Topics with Most Views

Write Excel formula into cell uipath made by @korhansuren with 52 views.

How To Rename An Existing Folder using text file in uipath made by @Ajit_Chowdary with 51 views.

How to use switch made by @Matthew2 with 42 views.

Top 3 Topics with Most Replies

How To Rename An Existing Folder using text file in uipath made by @Ajit_Chowdary with 21 replies.

Write Excel formula into cell uipath made by @korhansuren with 15 replies.

Removing Trailing Spaces in a variable made by @ieptus with 15 replies.

Top 3 Users Who Posted The Most

@Dawodm made 31 posts!

@prasath17 made 20 posts!

@HeartCatcher made 18 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 2 likes!

#FeatureBlog - 19.10 - Using regular expression (Regex) in the selector attributes

Hi @loginerror, Quite late to the party, but this is extactly what I was looking for. RegexSearch within selectors. BluePrism had this feature long ago so its nice to see UiPath support it too. The windows popup in different languages is different. By using the following alteration to the selector we avoided drastic changes to the code! If anyone else is facing the same issue, only a | is required to support multiple languages. <wnd app='chrome.exe' cls='#32770' title='Open|Åpne' matching:…

This post made by @Dhanushka_Karagaswewa received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, I’m DK and I’m new to UI path and I joined this forum to improve my knowledge in terms of the platform and to stay updated on new trends/updates

This post made by @Sonalk received 2 likes!

Check Email Address in Active Directory

Thanks @Jeroen @lukas.macas : I’ve got expected email id by using below activities. [image]

Top 3 Most Liked Solutions

This solution provided by @lukasziebold received 2 likes!

Read Part of Excel Based on Certain Column Value. Split One major Excel to Two parts

Hi Hurmet, I would probably: Iterate through the full DataTable with For Each Row and declare a variable for the RowIndex Get Cell Color with a range based on the RowIndex (careful, RowIndex 0 is usually row 2 in Excel) If the color is yellow, use that RowIndex to copy your rows to a new DataTable like this: NewDataTable = FullDataTable.AsEnumerable.Skip(PreviousIndex).Take(CurrentIndex - PreviousIndex + 1).CopyToDataTable Put the CurrentIndex as the PreviousIndex (+1) after and you can skip…

This solution provided by @Yoichi received 2 likes!

特定の日付が休日、祝日なら平日に移動する処理をしたいです。

こんにちは 基本的に曜日は日付で一意に決定されるので、日付だけのハンドリングにして、 必要時に曜日を算定する方がシンプルかと思います。 そのためデータ２に関してはDictionaryにするのではなく、対象日付を リストあるいは配列すれば十分かと思います。 データ１の各行の日付を評価して、「土曜日」または「日曜日」または「上記リスト中に日付がある」の いずれかに該当すれば、１日加算して、再度評価します。 上記に該当しない日が平日ですので、それを書き戻します。 これらをまとめると、例えば以下の様に実装できると思います。 [img20210826-1]

This solution provided by @Yoichi received 2 likes!

How to use switch

Hi, We can achieve it using dictionary and regex as the following, for example. [img20210826-3] Sample20210826-3.zip (3.1 KB) 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.