Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 November 2023

Top 3 Topics with Most Views

In an excel if a cell contains data empty, how to delete entire row. Can anyone help me with this please made by @PriyaReddy with 33 views.

Couldn't find "System.IO.File.GetAccessControl" Function made by @aeklikit with 32 views.

メール添付ファイルからパスワードを外したのち、フォルダへ保存したい made by @wggcs044 with 31 views.

Top 3 Topics with Most Replies

In an excel if a cell contains data empty, how to delete entire row. Can anyone help me with this please made by @PriyaReddy with 27 replies.

How to change csv file format to xlsx format made by @anjani_priya with 14 replies.

Index was outside the bounds of the array! made by @170290064 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 78 posts!

@Nguyen_Van_Luong1 made 18 posts!

@170290064 made 16 posts!

Top 3 Most Liked Posts

This post made by @Shiva_Nikhil received 2 likes!

Get values from in_config to outlook

@Meu_Eu_Nando You can pass the values to these arguments By using assign activity Or in the imports where this workflow invoked In this way In_SmeEmail=Config(“key”).tostring Or in_Config(“key”).tostring Key is which you have given in the config file

This post made by @170290064 received 2 likes!

Queue Items Issues

How stupid i am I couldnT see the typo Thanks for the answer

This post made by @Meu_Eu_Nando received 2 likes!

Get values from in_config to outlook

Thank you. Both solution works. I just needed to add the config argument inside the send email flow but I tested before what you said and worked. Many thanks guys

Top 3 Most Liked Solutions

This solution provided by @Shiva_Nikhil received 2 likes!

Get values from in_config to outlook

@Meu_Eu_Nando You can pass the values to these arguments By using assign activity Or in the imports where this workflow invoked In this way In_SmeEmail=Config(“key”).tostring Or in_Config(“key”).tostring Key is which you have given in the config file

This solution provided by @rajneesh94 received 1 likes!

Extract Specific text from multiple Pdf's

Hi @rsr.chandu, You can extract the selected values using Regex. Use Read PDF Activity and store the extracted text in a variable like strExtractedText. For extracting Total value use an assign activity in the following way: strTotal = System.Text.RegularExpressions.Regex.Match(strExtractedText, "(?:\s*|^)(\$\s*\d+(?:,\d+)*\.\d+)\s*(?:$|\s)").Groups(1).Value Same for Invoice Date: strInvoiceDate = System.Text.RegularExpressions.Regex.Match(strExtractedText, "\s*(0?[1-9]|1[0-2])\/(0?[1-9]|…

This solution provided by @Anil_G received 1 likes!

How to change csv file format to xlsx format

@anjani_priya Just so that you know …a little googling also will help [image] now coming to c hanging all use a loop around [image] cheer

---

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.