Possible to count the number of '+' appearing in an excel column?

[lmoham]

I would like to improve my process to accommodate for changes in the future and would like to change the bot from finding “LP” keywords to the number of times ‘+’ plus signs appear within a row is that possible?

I get this error when replacing “LP” with “+” using the code shown above

[NIVED_NAMBIAR (NIVED N)]

hi @lmoham

can u show thw excel column please?

[lmoham]

Heres the column for it, I would like to get the same results but finding ‘+’ plus signs instead of ‘LP’.

[Pradeep_Shiv]

(From row in outData.AsEnumerable() Where row.item(0).ToString.Contains(“+”) Select row.Item(0)).ToList()

you can use For each to print them and just do this to check Item.Count

Try this and let me know.

[vignesh.ks]

Hi @lmoham

Please use the below method.

System.Text.RegularExpressions.Regex.Matches(yourVariable,“[+]”).count

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

[Srini84 (Srinivas Kadamati)]

@lmoham

Check as below

System.Text.RegularExpressions.Regex.Match(sampleString,"LP").Value.ToArray().Count()

Mark as solution if this helps you

Thanks

[lmoham]

Thanks again and yes your code worked the way I desired!

Thanks to everyone chipping in too ^^