Forum Engagement Daily Reports

[system]

Daily Forum Report | 16 June 2024

Top 3 Topics with Most Views

データテーブルの各行を繰り返す、で重複行の場合は次の行を処理したい made by @vgmadtg with 43 views.

半角数字から全角数字への変換について made by @ml.system with 38 views.

Can't find package for microsoft.activities.extension for dictionary activities,thanks for any help! made by @Sai_Kumar_111 with 36 views.

Top 3 Topics with Most Replies

テキスト位置を探すについて made by @ml.system with 14 replies.

半角数字から全角数字への変換について made by @ml.system with 13 replies.

Need to extract values/numbers based on rules and add them made by @8b6861dc5e0c9f7008548ca66 with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@lrtetala made 13 posts!

@vrdabberu made 8 posts!

Top 3 Most Liked Posts

This post made by @Indranil_Dey received 1 likes!

Monthly Forum Rewards - May 2024

Congratulations to all winners

This post made by @588b97c268cd7dd244bd4707e received 1 likes!

Convert dynamic values to date

Learning platform UI Path Description Hi I am new to UI path I have a doubt. I am getting values(dates) from excel in MM/dd/yyyy as string. I want it to be stored as date format. Because I need to compare two date. Date which I read from excel and current date. I tried this : DateTime.ParseExact( One , “d-M-yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”) where one is the variable in string which values I am getting from excel ex: 7/2/2024. Can someone please…

This post made by @lrtetala received 1 likes!

Need to extract values/numbers based on rules and add them

Hi @8b6861dc5e0c9f7008548ca66 Try this MRValues = (From row In dt.AsEnumerable() Let line = row(0).ToString() Where System.Text.RegularExpressions.Regex.IsMatch(line, "(IND|DBA|STA|GJK) \d+-MR") Select Convert.ToInt32(System.Text.RegularExpressions.Regex.Match(line, "\d+").Value)).Sum() MPValues = (From row In dt.AsEnumerable() Let line = row(0).ToString() Where System.Text.RegularExpressions.Regex…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Data Table Extract not working

@dutta.marina As mentioned if idx is increasing for each transaction just use a variable and incrmenet If that is not the case them we need to find another attribute which is unique to your target table…and get that…may be selecting a intermediate row in the ui explorer center top window will help…check the same to restrict the selector to the tab you need Cheers

This solution provided by @lrtetala received 1 likes!

Need to extract values/numbers based on rules and add them

@8b6861dc5e0c9f7008548ca66 To handle cases with varying spaces between the prefix and the number, and to capture both alphabet and alphanumeric suffixes accurately, MRValues = (From row In dt.AsEnumerable() Let line = row(0).ToString() Where System.Text.RegularExpressions.Regex.IsMatch(line, "(IND|DBA|STA|GJK)\s+\d+(\.\d+)?\s*-MR") Select Convert.ToDouble(System.Text.RegularExpressions.Regex.Match(line, "\d+(\.\d+)?").Value)).Sum() MPVa…

---

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.