> So can u suggest how would I handle these data I have a > large set of data where may be the integer after E is missing > it should be assumed to be 0 if value is there. Simple enough - check the strings if they're ending with "E", if yes append "0", then you're set for using the validator. Martin