Forum Engagement Daily Reports

[system]

Daily Forum Report | 10 December 2022

Top 3 Topics with Most Views

How to add semicolon after each value in email address column made by @vielesh with 56 views.

Add 0 in the beginning of a mobile number if the mobile number only has 9 digits and starts with 4 made by @ammohan with 54 views.

Need to remove duplicates on single column made by @manojmanu.rpa with 51 views.

Top 3 Topics with Most Replies

How to remove special characters in excel data table like for one sheet made by @sathish_Kumar6 with 6 replies.

Need to remove duplicates on single column made by @manojmanu.rpa with 6 replies.

I have a excel in which after opening the sheet user will find the grade which is “F19,010” and under this grade it will find the location as “Mumbai” and fetch the value for the same grade under Mumbai City made by @Prathamesh_Chavan with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 21 posts!

@Yoichi made 12 posts!

@Rahul_Unnikrishnan made 11 posts!

Top 3 Most Liked Posts

This post made by @shesherao.patil received 1 likes!

How to use casesensitive attribute in selectors for Select Item Activity?

Its working thanks a lot for your fine solution

This post made by @Yoichi received 1 likes!

How to use casesensitive attribute in selectors for Select Item Activity?

Hi, Can you try to add .Replace(" “,”") as the following? strSelect = options.Split(vbCrLf.ToCharArray,StringSplitoptions.RemoveEmptyEntries).Where(Function(s) s.ToLower.Replace(" ","")=strTarget.ToLower.Replace(" ","")).FirstOrDefault Regards,

This post made by @Anil_G received 1 likes!

How to remove special characters in excel data table like for one sheet

Hi @sathish_Kumar6 Perform a for each row in excel and then use currentRow("Columnname") = System.Text.RegularExpressions.Regex.Replace(currentRow("Columnname").ToString,"[^a-zA-Z0-9\s]","") This will replace all values except the specified which are alphabets numbers and spaces Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to use casesensitive attribute in selectors for Select Item Activity?

Hi, Can you try to add .Replace(" “,”") as the following? strSelect = options.Split(vbCrLf.ToCharArray,StringSplitoptions.RemoveEmptyEntries).Where(Function(s) s.ToLower.Replace(" ","")=strTarget.ToLower.Replace(" ","")).FirstOrDefault Regards,

This solution provided by @Anil_G received 1 likes!

How to remove special characters in excel data table like for one sheet

Hi @sathish_Kumar6 So in the regex cap is for ignore the next characters and what characters i gave are alphabets(a-z and A-Z) , numbers (0-9) , any space characters(\s) .so ignoring these characters all other characters will be replaced [image] If you wnat to do for all columns then i would suggest read the data into a datatable and then use for loop on row and another loop on column inside the row loop and replace it Then write back the data Other way is to do with linq queries but aga…

This solution provided by @Yoichi received 1 likes!

画像の合成処理を代入で処理

こんにちは 返り値がないメソッドを呼ぶときはInvoke Method(メソッド呼び出し）アクティビティを使用する必要があります。 例えば以下になります。 [image] なおGraphics.DrawImageには上記の組み合わせの引数はないと思いますので、 コールする内容は見直したほうが良いように思えます。 詳しくは以下を参照ください。 https://learn.microsoft.com/ja-jp/dotnet/api/system.drawing.graphics.drawimage?view=dotnet-plat-ext-7.0

---

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.