How can I Search in a Selected Column only

[BobBailey]

I have a very large pipe-delimited file that is cumbersome in Excel. I can view it using DSV in EE quite easily and do some things that I need to do.
I would really like to be able to search only one column but can’t seem to find a way to do that. I spent about 45 mins combing through Help but found nothing
First, is this possible. If so, how? Finally, is it documented in Help? Where?
Thanks for a really great tool. I use it constantly.
…Bob.

[Yutaka Emura]

Hello BobBailey,

Yes, it is very easy. First, select a column (if the Ruler is displayed, you can double-click the ruler). Then CTRL + F to bring up the Find dialog box, and make sure “In the Selection Only” is checked, and find.

On the next version, the Advanced Filter feature will also make it possible to search only a specified column.

Thanks,

[Author]

Posts