Checking if values in .xlsx document contains special character

Help
1

Hello,

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?

Regards,

2

You can try with dataTable.select([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

dataTable.select(" FirstName constains ‘*’ ")