Is there a method to auto remove an alpha character from a numerical field ?
Are you using JMP 12? If so you can do most of what you have asked in your 3 posts in Columns > Utilities > Recode
If you have not seen this option used before I would recommend you contact your territory SE for a demo.
Extract numbers from string in JSL