Forum Engagement Daily Reports

[system]

Daily Forum Report | 29 November 2023

Top 3 Topics with Most Views

Convert to datetime format Error: Length cannot be less than zero (Parameter'length') made by @YangYang with 58 views.

Error madness with variable type made by @pere with 50 views.

REST APIを利用したアクティビティの時間ズレ made by @h.yasuda with 44 views.

Top 3 Topics with Most Replies

マクロを動かした際に出てくる【アラーム発生情報】を見て情報が一致したものにメールを送信したい made by @once10201029 with 31 replies.

Error when applying formula to Excel help made by @22222222asas with 20 replies.

Excel cell made by @Pushpendra_kowthavarapu with 15 replies.

Top 3 Users Who Posted The Most

@rikulsilva made 37 posts!

@Yoichi made 36 posts!

@ppr made 25 posts!

Top 3 Most Liked Posts

This post made by @YangYang received 1 likes!

Convert to datetime format Error: Length cannot be less than zero (Parameter'length')

Hi there, i have this pivot table and i need to convert it to datetime format to “MM/dd/yyyy” this is my syntax that is not working anymore. Assign variable ExtractedRowDate as System.DateTime = DateTime.ParseExact(row(0).tostring.Substring(0,row(0).ToString.IndexOf(" "c)).Trim,“MM/dd/yyyy”,System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat) Error Length parameter cannot be less than zero the result is -1 i would like to read only the date row and convert it to datetime forma…

This post made by @22222222asas received 1 likes!

How to cut characters according to a rule

I want to trim a cell’s input to 25 characters, and if there’s a space at the 25th position, cut it off. If there isn’t a space, find the nearest space, move frontward, and cut it off. The remaining characters should then move to the next row, and the process repeats. If the last row has characters that are less than or equal to 25, the robot should end. I’ve tried using length, trim, and replace, but it didn’t work. Is there a way to achieve this? The question is insufficient, so I explain it…

This post made by @pravallikapaluri received 1 likes!

Error when applying formula to Excel help

@22222222asas Excel.Sheet("Sheet1").Cell("B2")+" "+Excel.Sheet("Sheet1").Cell("C2") [image]

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 1 likes!

Error when applying formula to Excel help

Hi @22222222asas If you use classic activity [image] [image] regards,

This solution provided by @Yoichi received 1 likes!

Split a string for the double quote character "

HI, How about the following expression? variable.split({""""c,ChrW(&H201C),ChrW(&H201D)}) Regards,

This solution provided by @efelantti received 1 likes!

Error madness with variable type

Easiest imo would be to change the definition of the string, like I already suggested. Then it’s a valid JSON list/array and can be deserialized as such. Otherwise you need to either transform it in code to a proper format or do some splitting manually.

---

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.