I want to read in tab deliminated text, so:

Description>Code>Amount

Book1>ABCDE0035A>4

When the Code is not known, it has a random code in it which includes a set of 7 zeros, so:

Book2>AB0000000F>3

I need to check the string as it comes in and if 7 zeros found deletes the string and leaves the field blank, so:

Book1>ABCDE0035A>4
Book2>>3

Can anyone help?
Thanks