Hi,
I have searched the forum for an answer to this but can not find one. Please excuse me if I have missed something obvious. any help would be appreciated.
I have a TXT File that contains many lines of data. I would like to be able to import lines if they contain certain string values. The string values could appear in any position in the line.
As an example if a line contains Apple, Grapes and Peach then the line is added to the Worksheet and moves to check the next line in the TXT file for the same, repeating until the end. Lines that do not contain all these words should not be added.
Apple|Bannana|Grapes|Orange|Strawberry|Pear|Peach Added
Apple|Bannana|Grapes|Orange|Strawberry|Pear|Melon Not added
I have searched the forum for an answer to this but can not find one. Please excuse me if I have missed something obvious. any help would be appreciated.
I have a TXT File that contains many lines of data. I would like to be able to import lines if they contain certain string values. The string values could appear in any position in the line.
As an example if a line contains Apple, Grapes and Peach then the line is added to the Worksheet and moves to check the next line in the TXT file for the same, repeating until the end. Lines that do not contain all these words should not be added.
Apple|Bannana|Grapes|Orange|Strawberry|Pear|Peach Added
Apple|Bannana|Grapes|Orange|Strawberry|Pear|Melon Not added