Dear all,

Is it possible to load partially a text file depending on specific
criteria in it ?

Example:

text file contains (delimitor is ^)

aaaaa^bbbbbbb^ccccc^^eeeee^fffff
rrrrrr^eeee^ssssss^bbbb^jjjjj^ooooooo
kk^^mmm^hhhhhhhhhhhhhh^uuuuuuu^wwwwww
xxx^pppp^qqqq^bbbb^yyyyy^kkkkk

I want to load into excel only the records that contains "bbbb" in the
4th field (column)
so in this example only record 2 and 4 should be loaded.

Any way to achieve this ?

Many thanks in advance !

Ronald.