Shell Programming and Scripting

The question is. "How many lines?"

If it is less than 20, the script I posted will be faster. If it's more than 100, awk or sed will be faster.

Hi vgersh99,


Thank you for the reply. The command works fine to get the out put as

[GRANT select ON *.*] ['atlrep'@'10.8.5.%']

Can you please help me the same command as two induvidual commands to get the output directed to 2 new files. Where i need to further parse them.


Thanks

Code:

nawk -F' TO ' '{print  $1 > "file1" ; print substr($2,1, index($2, " ")-1) > "file2" }' myFile

Hi


Thank you all for the reply. In addition can you please let me know how to cut the first word of every line in a text file. There are more then 20 lines in the file.

Thanks

depends on what you mean by 'cut' and by 'word'..

Code:

sed 's/^\([^ ][^ ]*\).*/\1/' myFile
OR
awk '{print $1}' myFile

Hi vgersh99,


Thank you for the reply. I was looking at remove the word grant from the above output in the first command ..for eg

File 1
[GRANT select ON *.*]

remove the word GRANT out of the above line. so can we use sed with awk which you gave initially

awk -F' TO ' '{print $1 **sed** > "file1" ; print substr($2,1, index($2, " ")-1) > "file2" }' grantfiles.

In short, i want the out put like

GRANT SELECT ON `ods`.* TO 'systemsDBuser'@'%';

[SELECT ] ON [`ods`.*] TO ['systemsDBuser'@'%'];

while the [] values in 3 different files.

Thanks

Code:

nawk -F' TO ' '{sp=index($1, " ");print  substr($1,1,sp-1) > "file1"; substr($1,sp+1) > "file2" ; print substr($2,1, index($2, " ")-1) > "file3" }' myFile