Forum Engagement Daily Reports

[system]

Daily Forum Report | 29 November 2021

Top 3 Topics with Most Views

Invoke VB code does not work made by @abdel with 45 views.

How can we pass the data table output to custom table please help me? made by @panguluri_saritha with 44 views.

How to pass variable into send hotkey made by @dhanashree22 with 40 views.

Top 3 Topics with Most Replies

How can add one by one add integer in web page made by @Rajiduraikannu_Santhosh_G with 17 replies.

How to use add data row if there is already value in datatable? made by @CharlotteG with 15 replies.

How can i modify Datatable in foreach loop? in C# made by @Sa_Ge with 13 replies.

Top 3 Users Who Posted The Most

@kirankumar.mahanthi1 made 32 posts!

@Yoichi made 21 posts!

@ppr made 19 posts!

Top 3 Most Liked Posts

This post made by @Palaniyappan received 3 likes!

How to extract table data from mail body?

Hi There are multiple approaches to read a DATATABLE from a mail body Like data scrapping or converting the HTML mail body to DATATABLE Have a view on this thread for multiple approaches Or This component can help you convert the HTML to datatable that is it will read the mail and give the datasets in it If you using this component Then the steps involved will be like [image] [image] In property HTMLText – item.Header(“HTMLBody”).ToString . This will extract the HTML code from the e…

This post made by @n.balaji10 received 2 likes!

“Insert: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).”

If you get this error means, Check excel header and DB table header, and check if any header has spaces inbetween. if yes remove the spaces then choose database connection wizard from Microsoft ODBC Data Source and try

This post made by @prasath_S received 2 likes!

Regex Help to read - Merchant statement

Hi @Duleepa_Krishan Please give a try, System.Text.RegularExpressions.Regex.Match("your input","(?<=MERCHANT NUMBER)[\s\d:]*").tostring.trim.replace(":","") Thanks

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 3 likes!

How to extract table data from mail body?

Hi There are multiple approaches to read a DATATABLE from a mail body Like data scrapping or converting the HTML mail body to DATATABLE Have a view on this thread for multiple approaches Or This component can help you convert the HTML to datatable that is it will read the mail and give the datasets in it If you using this component Then the steps involved will be like [image] [image] In property HTMLText – item.Header(“HTMLBody”).ToString . This will extract the HTML code from the e…

This solution provided by @pavithra_pavi received 1 likes!

How replace a special characters in string

Hi @Kavya_Bhat , From what i understand, you need to remove the special character from a string. Try using Regex. System.Text.RegularExpressions.Regex.Replace(“thisIs@myQues#”, “[^a-z A-Z]”, “”).ToString Let me know if it works.

This solution provided by @pravin_calvin received 1 likes!

Extract value from a selector

Hi @hacback17 Use get Attribute to get the parentid attribute from the selector and use the Regex pattern to match only digits! 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.