VBA to read in tab delimited text file

[DaveNUFC]

Hi, I have the below code which reads in a tab delimited file however how do I tweak this so it only brings back data that I want.
For example, if I want to see only those entries where the first field is 123 how do I go about doing that? At the moment this code will read in all entries from within the tab delimited file.

Many thanks

Please Login or Register  to view this content.

[AlphaFrog]

Try this. It uses the Split function to divide the delimited data of a given line.
The If-End If code block is the filter where the zero is the field number (1st column = 0, 2nd column = 1...)

Please Login or Register  to view this content.

[DaveNUFC]

Thanks Alpha Frog that works exactly as I wanted it to.
If I wanted to only bring back this but within a certain date range e.g. reference 123 only where column 3 is greater than or equal to 01/01/16 and column 4 being less than or equal to 01/04/16- could this be added to the below extract you did above?

I guess column 3 would be varTemp(2) and 4 varTemp(4)?

Please Login or Register  to view this content.

[AlphaFrog]

Thanks Alpha Frog that works exactly as I wanted it to.
If I wanted to only bring back this but within a certain date range e.g. reference 123 only where column 3 is greater than or equal to 01/01/16 and column 4 being less than or equal to 01/04/16- could this be added to the below extract you did above?

I guess column 3 would be varTemp(2) and 4 varTemp(4)?

I didn't test this...

Please Login or Register  to view this content.

[DaveNUFC]

Thanks Alpha, works great ;-)