Search for specific string using shell script

Question

I have a set of log files and I need to find tables from a specific database being used by searching them in log files. The search keyword should start with 'database.' and should be able to grep/parse all table names with preceding database name. Can anyone advise on how this can be achieved using shell script.

Thanks

Please include a sample of an input file. Show what output you expect for the sample. — choroba
– choroba, Commented Jan 12, 2022 at 14:48
You have to be more specific. Otherwise the answer is: yes use grep. — ceving
– ceving, Commented Jan 12, 2022 at 14:50

Dominique · Accepted Answer · 2022-01-12 15:00:15Z

1

This is very easy:

grep "database" *              : this shows the filename + the entire line
grep -l "database" *           : this shows only the filename
grep -o "database [a-z]*" *    : this shows the filename + the database name
grep -h -o "database [a-z]*" * : this shows the database name

answered Jan 12, 2022 at 15:00

Dominique

17.6k20 gold badges80 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Search for specific string using shell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related