Forum Engagement Daily Reports

[system]

Daily Forum Report | 05 August 2023

Top 3 Topics with Most Views

Select year using regular expression made by @helpplease with 52 views.

How can I extract the complete phone number from the website when it's displayed as '0096279552xxx' initially and only revealed after clicking on it? Any ideas? made by @M.Abd with 35 views.

LINQ query! made by @Rohan_Dhole with 34 views.

Top 3 Topics with Most Replies

Multiple extractions using regex made by @helpplease with 12 replies.

VBA code excel made by @shama93 with 11 replies.

Switch Activity Expression Field made by @Joel_Metheny with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 53 posts!

@mkankatala made 26 posts!

@Parvathy made 9 posts!

Top 3 Most Liked Posts

This post made by @mkankatala received 2 likes!

How can I extract the complete phone number from the website when it's displayed as '0096279552xxx' initially and only revealed after clicking on it? Any ideas?

Hi @M.Abd Use get text activity to get the mobile number and indicate on the element. After indicates open the UI explorer and select the attribute which has the proper mobile number data. After this use get attribute activity and select the attribute in the output of get attribute create a variable which stores the exact data. Hope it helps!!

This post made by @Anil_G received 1 likes!

Select year using regular expression

@helpplease Try this one (?<[A-Za-z]{3} ?)\d{4} [image] cheers

This post made by @bhavana_kolli received 1 likes!

Validation error BC30512:

solved.i used generic value

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Select year using regular expression

@helpplease Try this one (?<[A-Za-z]{3} ?)\d{4} [image] cheers

This solution provided by @shama93 received 1 likes!

While activity

Ok thanq so much… will try

This solution provided by @Anil_G received 1 likes!

Excel COUNT IF Formula

@Omkar_Shete2 Add two columns for each to write the data in excel And then use write cell activity and give the formula as "=If(COUNTIF(A:A,A2)>1,""Duplicate Found"","""")" Then use auto fill range to fill the formula to the bottom Repeat same for the second columns as well Hope this helps Cheers

---

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.