import text file

S

Shawna

I need to import some data from a text file,

I am using
If MyString Like "*,*,[*:*],,," Then

as my criteria - what the line of text looks like to import is below.

10,1,V1 GATE TAG: GV001,,,

there is different text lines in the file but I need it to skip all the others that don't look like this but the only difference between this line and the others is the 3rd field will always have a : in it.
the others will never have. But my if statement isn't working, I've tried without the * in there.
Any suggestions would be great.

Thanks in advance.
Shawna
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top