Want to check column datatype and convert accordingly

Hi ,

Am building one dashboard where my one of the column and  it's data type is  String and it will have both alpha numeric values ,numeric and string values. I want to check if it numeric then i need to replace it with 0 and if it string need to display as it is.

Thanks,

Manoj Praveen