How to grep the grant statement and output to the different files? Post: 302772282

Sponsored Content

Top Forums Shell Programming and Scripting How to grep the grant statement and output to the different files? Post 302772282 by jediwannabe on Monday 25th of February 2013 12:08:26 AM

02-25-2013

Registered User

I need to change my original code as it will give some negative results
here's my current code

Code:

for i in *.sql
do
        if [[ `grep EXCEL_TXN "$i"` ]]
        then
        grep EXCEL_TXN "$i" > "${i%.*}_to_excel_txn.sql"
        fi
        if [[ `grep BONUS_USER "$i"` ]]
        then
        grep BONUS_USER "$i" > "${i%.*}_to_bonus_user.sql"
        fi
done

exit

I need to be more specific to zoom in only the grant ....to EXCEL_TXN line or

grant...to BONUS_USER line

how do I do it?

from HowTo: Use grep Command In Linux / UNIX [ Examples ]

Code:

$ egrep -w 'word1|word2' /path/to/file

Code:

$ egrep -w 'GRANT|EXCEL_TXN' /path/to/file

since it will also grep the additional GRANT TO BONUS_USER.

any assistance is greatly appreciated!

thanks!

jediwannabe

View Public Profile for jediwannabe

Find all posts by jediwannabe

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using grep in if statement

Can somebody please guide me towards right syntax: #!/bin/ksh if i = $(grep $NAME filename) echo "Name Found" else echo " Name not Found" fi I need to grep for $NAME in the file, and if it returns false, execute a series of commands and if true, exit out. The above is not the right...

2. Shell Programming and Scripting

grep'ing for specific directories, and using the output to move files

Hello, this is probably another really simple tasks for most of you gurus, however I am trying to make a script which takes an input, greps a specific file for that input, prints back to screen the results (which are directory names) and then be able to use the directory names to move files....

3. Shell Programming and Scripting

Grep statement

Hi All, Please can somebody advise that if I want to search a pattern xyz the grep command should only select xyz and not any other pattern containing xyz (ex abxyzcd) Regards

4. Shell Programming and Scripting

Grep multiple terms and output to individual files

Hi all, I'll like to search a list of tems in a huge file and then output each of the terms to individual files. I know I can use grep -f list main.file to search them but how can I split the output into individual files? Thank you.

5. Shell Programming and Scripting

Using GREP in IF Statement

Hello All, I have 2 different pieces of code, I am confused why the Code1 is giving me the correct result where as the Code2 is not giving me correct result. It gives me always result as "Failure" irrespective of the "ERROR" word exists in logfile or not. may I know the reason why? I am using Bash...

6. Post Here to Contact Site Administrators and Moderators

Redirecting grep output to multiple files

Hi All, I am trying to redirect the grep output to multiple files, can you please help with that. Below is the command im using to match my pattern grep \<proxyType\>$PxyType $DIR/EndureFiles.json > File_Name*.json Note : $DIR and $PxyType is already defined in my script Im able...

7. Solaris

Grant unprivileged user rights to see the output of echo|format but not modify disks

anyone have any idea how do to this with auth_attr? I suspect if I grant him solaris.device.:RO::Device Allocation::help=DevAllocHeader.html that will work but I'm unsure. Just looking for a second opinion.

8. Shell Programming and Scripting

Grep strings on multiple files and output to multiple files

Hi All, I want to use egrep on multiple files and the results should be output to multiple files. I am using the below code in my shell script(working in Ksh shell). However with this code I am not attaining the desired results. #!/bin/ksh ( a="/path/file1" b="path/file2" for file in...

9. Shell Programming and Scripting

How can i prepare grant staement with 2 files ?

---file1 ( tables A B C D E F ... ... Z ---file2 Joe Bob Mary Sally Fred Elmer David

10. Shell Programming and Scripting

Grep two files: -F flag gives weird output

Hi Members, I'm confused with grep -F option. Goal is to get all the lines from file2 that have exact gene name from gene list (file one). File one has list of genes: File two has lot more information pertinent to genes in file one: I use three following commands: 1) grep -wf gene...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using grep in if statement

Discussion started by: chiru_h

2. Shell Programming and Scripting

grep'ing for specific directories, and using the output to move files

Discussion started by: JayC89

3. Shell Programming and Scripting

Grep statement

Discussion started by: Shazin

4. Shell Programming and Scripting

Grep multiple terms and output to individual files

Discussion started by: ivpz

5. Shell Programming and Scripting

Using GREP in IF Statement

Discussion started by: Ariean

6. Post Here to Contact Site Administrators and Moderators

Redirecting grep output to multiple files

Discussion started by: Deena1984

7. Solaris

Grant unprivileged user rights to see the output of echo|format but not modify disks

Discussion started by: os2mac

8. Shell Programming and Scripting

Grep strings on multiple files and output to multiple files

Discussion started by: am24

9. Shell Programming and Scripting

How can i prepare grant staement with 2 files ?

Discussion started by: rocking77

10. Shell Programming and Scripting

Grep two files: -F flag gives weird output

Discussion started by: genome