Forum Engagement Daily Reports

[system]

Daily Forum Report | 22 January 2023

Top 3 Topics with Most Views

Separate the name made by @Muneer_Alrashdan with 44 views.

Regex Matches with Anchors made by @Beere_Plays with 40 views.

Http Request unknown host Error made by @Man_Kay_So with 35 views.

Top 3 Topics with Most Replies

RESULT からの例外:0x800706BE made by @miwa_yamamoto with 16 replies.

Unable to define solution approach for multiple attachments made by @rds0511 with 7 replies.

Cannot anchor PDF file data made by @Isabel_Chau with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@rds0511 made 8 posts!

@fernando_zuluaga made 7 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Array of Strings - Compiler error BC 30311: value of type '(string, string)' cannot be converted to 'string()'

@cellery Welcome to the community For adding array you have to use flower/curly brackets not round.please try this {"John","Don"} Hope this helps Cheers

This post made by @Yoichi received 1 likes!

Can not assign 'Convert.ToDouble(row("Amount").ToString)

Hi, Which do you need to handle “24.28-”, as positive or negative? If positive Convert.ToDouble(row("Amount").ToString.TrimEnd("-"c)) +dbSumAmount If negative Convert.ToDouble(System.Text.RegularExpressions.Regex.Replace(row("Amount").ToString,"^([.,\d]+)(-)?$","$2$1")) +dbSumAmount Hope the above helps you. Regards,

This post made by @Comet received 1 likes!

Leap year

Thank you very much! This again solved my problem.

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

What is the ideal way of creating libraries?

in every project that we develop, remove the unused dependecies will be a good practice to apply, no matters if the projects is a sequence or library etc, we should remove all of them and just keep the used dependencies. Library won’t affect the project perfomance, just remember to publish then in the orchestrator if you will move to production environment For example if you run the analyze file it will retrieve you a warning in case that you dont delete the unused depencies [image] Regards! …

This solution provided by @Yoichi received 1 likes!

Call cell from data table with Variables

Hi, Which type of variables do you use : in_dtItems, RowCount and ColumnCount? If in_dtItems is DataTable and RowCount and ColumnCount are String type and store index value of row or column, the following will work. in_dtItems( CInt(RowCount))( CInt(ColumnCount)).ToString or in_dtItems.Rows(CInt(RowCount))( CInt(ColumnCount)).ToString 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.