validate all numeric fields and extract number if mixed with text