I have a string of measurements--mostly numbers, but occasionally an NA. Right now Mathematica is reading it all as text, so I'm using
Read[StringToStream[#], Number] & /@ z;
to convert to a number string, where z is the string.
Is there a way to skip the NA whenever it appears?
Edit: the numbers are all in scientific notation (2.00E-07)