Checking if values in .xlsx document contains special character


I am trying to check if cells from column do not contain (*) in string. How can i check this after reading excel file into dt type variable?


You can try with[filtercondition]), if it return more than one value then you can safely assume there special chars.

I am not sure about the exact filter condition, but you can try the following, assume column name is FirstName" FirstName constains ‘*’ ")