# Ignoring text when converting strings of text to numbers

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)

Sample string:

{NA,NA,NA,2.05E-08,2.07E-06,3.45E-09,7.52E-07,NA,NA...}

• Can you post a sample string? – David Keith Jan 23 '19 at 20:08
• Why not just remove the NA afterwards, DeleteCases[z, NA]? – C. E. Jan 23 '19 at 20:35
• You sample string is not a string. Please put some effort in that :) – Kuba Jan 24 '19 at 7:11