Get text strings from a binary file 1

[jaxtell]

I am trying to figure out exactly what SQL statements an executable is running. I can view or grep the file to see the text, but there is a lot of it. Is there a good way to retrieve these string from a binary file? The closest I've gotten so far is

grep -i --binary-files=text "delete " FILENAME > delete.txt

But I still end up with loads of binary data. Ideally, I just want every match of the word delete followed by a space followed by a table name (letters and underscores) to end up as the results. I'd appreciate any advice you can offer. Thanks.

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/

 

[KenCunningham]

Does strings work on your implementation?

The internet - allowing those who don't know what they're talking about to have their say.

 

[jaxtell]

Ah, yes it does. Knowing the right command makes things quite a bit easier. Thanks!

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/

 

[jaxtell]

This is what I ended up with

strings FILENAME | grep -i -o -P "delete [\W|_]+" > delete.txt

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/

 

[KenCunningham]

Glad to help and thanks for the star!

The internet - allowing those who don't know what they're talking about to have their say.