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
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