Cleaning up and converting multiple numerical fields

[ScottB1]

I have a source data with ~130 fields. About half of them are numeric and filled with text and special characters. What are the disadvantages of converting the [dirty] fields first then using dynamic select to remove all non-numerical characters (like the attached)? I went that route as I didn't want to select every field in the data cleansing tool. 

[flying008]

Hi, @ScottB1 

Maybe you can upload some example data for input and output.  so what your want? like dynamic select fields?

[ScottB1]

@flying008

It's basically just columns that are 95% numeric (or null) but some rows contain "NA" or "Not Found". The approach I took works fine it just generates a lot of field conversion warnings.