Forum Engagement Daily Reports

[system]

Daily Forum Report | 01 July 2024

Top 3 Topics with Most Views

Need help with for each ui element made by @mohamed.saty2012 with 59 views.

Replace text within string "" with \" \" made by @dutta.marina with 59 views.

Try catch invoke made by @A_Learner with 55 views.

Top 3 Topics with Most Replies

I wanted to get the excel sheet names with out opening the excel and then I want do so operation in each sheet made by @Naveen_Kanike with 30 replies.

Need help with for each ui element made by @mohamed.saty2012 with 19 replies.

Find matches activity - Result property made by @Venkatraj_WaMDS with 17 replies.

Top 3 Users Who Posted The Most

@Yoichi made 28 posts!

@ashokkarale made 26 posts!

@rlgandu made 24 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Regular Expression - Capture Text B/W Words

@Lalitha_Selvaraj If it is two different words or sentences then you can just use split and get the data str.Split({"Sentence1"},StringSplitOptions.None).Last.Split({"Sentence2"},StringSplitOptions.None).First Cheers

This post made by @yangyq10 received 1 likes!

How to capture specific sales number from email text?

Dear Experts Previously I can use below Regular Expression to capture the sales number(伝票番号) from email text System.Text.RegularExpressions.Regex.Match(mail.Body.ToString,“(?<=伝票番号\D+)[\d,]+”).value [image] But now business changes and we will have another sales number(伝票番号) form which start with “G” plus 9 number [image] However, the above Regular Expression can only capture 9 number(900002875) under this scenario May I know how to modify the current Regular Expression to capture both 10…

This post made by @Lalitha_Selvaraj received 1 likes!

Regular Expression - Capture Text B/W Words

Hi, I need to capture the data between “Use this section for explanations and special requests. Identify Question and Section numbers.” and “PT”. How to write a regex for the below image? I have attached the sample pdf image. if there is data , the value should get printed in csv and if there is no data there is no data printed in csv. [tempsnip] Expected output: [image]

Top 3 Most Liked Solutions

This solution provided by @Nawazish_Ahmad received 1 likes!

How to check whether the files are in excel or text files

Hi @pabaleloh After saving the Outlook Attachment. You can check the extension by Path.GetExtension(AttachmentFilePath) If the file extension is .txt, read the text data using Read Text File activity and then write this data into an Excel file using Write Range activity. Hope it’ll helps you Cheers !!

This solution provided by @mkankatala received 1 likes!

Need help with for each ui element

In which element you want to click on. Do you want to click on every element in that column. → If yes, then Inside for each row in datatable activity insert the assign activity and store the value of that column in a variable called SelectValue. → Drag and drop an click activity after the assign activity, then indicate on the first element of the column. When you are indicating ui element Check the Strict selector and uncheck the fuzzy selector, image and OCR and submit it. → Come back to …

This solution provided by @Yoichi received 1 likes!

How to capture specific sales number from email text?

HI, It’s my bad.(Missing + sign) Can you try the following expression? System.Text.RegularExpressions.Regex.Match(mail.Body.ToString,"(?<=伝票番号\W+)\w+").Value [image] 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.