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
