Column with data separated with semicolon

Hi,   Just want to ask, I have a column in one of my table with format shown below. Is this an array? I am interested in counting rows with blank specific string within that array.   Ex.  I am i...