Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 August 2021

Top 3 Topics with Most Views

How to match values in excel with values in a dictionary key made by @Mpumi_Setshedi with 35 views.

Add data from column 3 to column 1 made by @nirmalya.sarkar with 34 views.

Need helps with creating if condition made by @Khanh_Nguyen with 30 views.

Top 3 Topics with Most Replies

Add data from column 3 to column 1 made by @nirmalya.sarkar with 12 replies.

How to save multiple variable value in excel/csv made by @Smruti_Smita_Samal with 9 replies.

How to break captcha from GST site made by @THIRU_NANI with 9 replies.

Top 3 Users Who Posted The Most

@sonaliaggarwal47 made 20 posts!

@AndyMenon made 15 posts!

@Gokul001 made 14 posts!

Top 3 Most Liked Posts

This post made by @ranjith received 2 likes!

How to filter the column if cell contains specific keyword?

Hi @Dorothy_lee You can use linq query to achieve your requirement. (from x as DataRow in dtInptut where x("Name").ToString.Contains("joy") select x ).CopyToDataTable

This post made by @copy_writes received 2 likes!

How to filter the column if cell contains specific keyword?

Hi Dawodm if use like this i hope you are not get the out put because bot will search only joy so if the row (name ) = joy means it will search only joy not joydema she is asking joy or joydema she want to filter those things so use like this row(“name”).Contains(“joy”) I hope you understood what am try to say Thanks Chethan P

This post made by @Dawodm received 2 likes!

How to filter the column if cell contains specific keyword?

Hi @copy_writes Ah ok thanks for the feedback. I didn’t see it. I though she searches for joy. row(“name”).Contains(“joy”) Works if it is no matter where is the joy keyword. But @Dorothy_lee if you search for only joy at the beginning you have to set it so: row(“Name”).ToString.Substring(0,3) = “joy” → Here you check only the first three characters. Best regards Mahmoud

Top 3 Most Liked Solutions

This solution provided by @T0Bi received 2 likes!

Copy and Pasting data within the same excel sheet

Use the Read Range Activity to read the data and the Append Range Activity to add it to the end of your range. If this has helped you, please mark this answer as the solution.

This solution provided by @sonaliaggarwal47 received 2 likes!

Computer Vision activities on On Premise Orchestrator

Hi @alvaro.j.nobre, Per my understanding, CV feature is not available on on-prem orchestrator unless you specifically setup a server for same. Same goes with AI/ML features. Regards Sonali

This solution provided by @prasath17 received 1 likes!

For each row | pdfs file in folder

@Markus3003 - In that case, change your logic as shown below… For Each code should be Directory.GetFiles(“YourFolderName”) Here Each File will give you the path name and next “5555” + path.GetFileName(Eachfile).Substring(0,6) will give you the invoice #… [image]

---

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.