Forum Engagement Daily Reports

[system]

Daily Forum Report | 12 March 2022

Top 3 Topics with Most Views

How to count Special 3 character in one String made by @Sweety_Nagar with 73 views.

Convert System.Collections.Generic.List`1[System.SystemException] to string? made by @fairymemay with 56 views.

Regex help capturing total amount made by @MaxDS1 with 42 views.

Top 3 Topics with Most Replies

How to count Special 3 character in one String made by @Sweety_Nagar with 14 replies.

Convert System.Collections.Generic.List`1[System.SystemException] to string? made by @fairymemay with 13 replies.

Excel to Sap Business one made by @badal_patel with 10 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 34 posts!

@Gokul001 made 19 posts!

@fairymemay made 14 posts!

Top 3 Most Liked Posts

This post made by @Gokul001 received 1 likes!

Regex help capturing total amount

HI @MaxDS1 If you need the whole text try this expression System.Text.RegularExpression.Regex.match("InputString","(I\salt\s)(\d.+)|(Saldo\s)(\d.+)|(Saldo\svor\sfavør\n)(\d.+)|(Ultimosaldo\sI\salt DKK\s)(\d.+)|(I\salt\sDKK\s)(\d.+)|(Beløb\sSkyldig\nkr\s)(\d.+)").Tosting.Trim [image] Regards Gokul

This post made by @Gokul001 received 1 likes!

Regex help capturing total amount

HI @MaxDS1 Try this Regex Expression System.Text.RegularExpression.Regex.match("InputString","(?<=I\salt\s)(\d.+)|(?<=Saldo\s)(\d.+)|(?<=Saldo\svor\sfavør\n)(\d.+)|(?<=Ultimosaldo\sI\salt DKK\s)(\d.+)|(?<=I\salt\sDKK\s)(\d.+)|(?<=Beløb\sSkyldig\nkr\s)(\d.+)").Tosting Regards Gokul

This post made by @jeevith received 1 likes!

Regex help capturing total amount

Hei @MaxDS1, In short the last one has kroner “Kr” one the newline before it starts with digits. So your pattern was not capturing the last one. Similar to your anchor search with pipes, you can use the | to look for two different types of patterns. Basically an OR logic. \s(saldo|i alt|ultimo|Beløb\sskyldig).{0,19}?\n?(kr [\d*.\d*]+.,\d*|[\d*.\d*]+.,\d*) [image] From Regex101 (I like using this website since it provides group matches and explanation of the pattern) [image] One more thi…

Top 3 Most Liked Solutions

This solution provided by @jeevith received 1 likes!

Regex help capturing total amount

Hei @MaxDS1, In short the last one has kroner “Kr” one the newline before it starts with digits. So your pattern was not capturing the last one. Similar to your anchor search with pipes, you can use the | to look for two different types of patterns. Basically an OR logic. \s(saldo|i alt|ultimo|Beløb\sskyldig).{0,19}?\n?(kr [\d*.\d*]+.,\d*|[\d*.\d*]+.,\d*) [image] From Regex101 (I like using this website since it provides group matches and explanation of the pattern) [image] One more thi…

This solution provided by @Palaniyappan received 1 likes!

Throw, Rethrow and Global Exception handler

Hi I appreciate your interest and passion to know the activity and it’s properties But by next Pls be clear with the query you want to get clarified On a note that these are EXCEPTION handling methods / activities used in UiPath There are five activities for handling exception Try catch Throw Rethrow Global exception handler Retry scope Rethrow is used when you want activities to occur before the exception is thrown. Throw activity is used when you want to throw error before the execut…

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

For Loop append string

Hi @fairymemay , If you are using a For Each Loop, then here is a sample sequence to get you started: [image] [image] [image] I’m using a Substring Method to get rid of the comma that gets appended towards the start when we first start assigning the items to our string variable. CombineStrings.xaml (6.4 KB) Kind Regards, Ashwin A.K

---

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.