Validation doesn't modify data. Auto-enter calcs due. That's different tab in the same dialog.
But removing quotes can be a bit tricky as there is more than one character that can be a quote if "smart quotes" are present in your imported text. The "remove everything" substitute function would need to use square bracket parameters to specifically remove the straight quotes, the left quotes and the right quotes.
Substitute ( textField ; ["\"" ; "" ] ; [Char (Leftquotecodehere) ; "" ] ; [Char ( rightquotecodehere ) ; "" ] )
and you then need to clear the "do not replace..." check box.
During import, you then need to enable auto-enter options (a check box in a small funky dialog that appears only after you click Import.)
Wow, that was simple! Works flawlessly.
In this case, there's no need to worry about smart quotes, since the download source is an Oracle system that probably doesn't use or allow them.
Phil, if you aren't already on FileMaker's payroll, you should be. You're fantastic.