Welcome to the Mythicsoft Q&A site for:

- Agent Ransack
- FileLocator Lite
- FileLocator Pro

Please feel free to ask any questions on these products or even answer other community member questions.

Useful Links:

- Contact Us
- Help Manuals
- Mythicsoft Home
0 votes

Hi,

I have to search through a number of excel files all contained in the same directory.
Each file consists of several sheets but the sheets always have the same name.

Is it possible to limit the search to a specific sheet? Or show in the results the name of the sheet where the row was found?

Let's say the sheet is called "Processed" and I have to look for lines containing the text "577001 728?

by (20 points)

1 Answer

0 votes

You could probably achieve what you want using the multi-line regex functionality (Pro feature). When the program converts the spreadsheet into text each sheet is prefixed with the sheet name, e.g.

Sheet: Processed (1 of 5)

... sheet data ...

Sheet: Orders (2 of 5)

etc.

With Multi-line RegEx specified as the expression type you could search for something on the 'Processed' sheet by searching for:

Containing Text: Sheet: Processed.*?577001 728.*?Sheet: Orders
by (27.9k points)
...