Reporting - count rows with specific strings

[Pickaxe]

Hi all,

I'm looking to count rows with specific word in a single column with "abb" inbetween any other letters 

Example

Column 1

Goodabbok 

Badabbnot 

Coolabbok 

Abbok 

I.e. count every word which has "abb" inbetween or at the start , or at the end 

Output = 4

Trying to find a solution in forum's but couldn't find it.

Can anyone assist Thanks in advance.

[messi007 · Accepted solution]

@Pickaxe,

Please see below how you can do it :

Attached the workflow,

Regards,

[Pang_Hee_Choy]

use formula, to create a column by formula. if contains then 1 else 0. 

and sum it up later.

*use text to column to split by text to row if more than 1 word.

try to search excel method, it may provide similar solution that can use in alteryx.