LOG PARSERLIZARD
Tutorials · Text files

Search many text files with one SQL query

Use a folder or wildcard as the source, filter for the identifier you need and return only the lines worth inspecting.

Choose the text provider

Use TEXTLINE when each line is a record, or TEXTWORD when word-level tokenization is useful.

Search a complete folder

SELECT FileName, LineNumber, Text
FROM 'C:\Exports\*.txt'
WHERE Text LIKE '%customer-12345%';

Reduce noise

Add filename, date or content filters and return only the columns needed for the investigation.