An Amount string column contains '12.50', '9.00', and 'unknown'. You need a numeric result and an exception list. Which approach is appropriate?

1. Replace every failure with zero without approval
2. Use a tolerant conversion and explicitly inspect failed conversions
3. Remove the entire source table
4. Sort the strings and treat the order as numeric