03-02-2006
script to search for the contents of a file
Hi all,
Please see my requirement and post me asap.
Spool all the tables names into a file . Take each table name and check if it is present in any of the scripts in a directory using grep -il command. The script has to loop through the tables list and take each table and find it's presence in directory. After this exercise, we need to get the list of tables that not present in any of the scripts.
As I am beginner to this shell scripting, I have given the below logic for this to be done. Logic can be same , but I want a clean debugged script.
I am not able to use the variables properly. Please let me know how to use the variables in this case.
Script:
for i in all_tables.txt (this is the spooled file which contains the table names)
do
tbl= head -i all_tables.txt|tail -1
search=grep -il tbl *
if(test -z $search)
then echo ${tbl}>>unused (I wanted to created a file with all the tables which are not used in the scripts)
fi
done
Thanks
Vasundhara
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I need to write a shell script that will access tables available on webpages and update a table on my webpage on a periodic basis. It will access, say for example a website that periodically update a table with certain quantities and update my table accordingly.it should have the flexibility... (0 Replies)
Discussion started by: wannabegeek
0 Replies
2. Shell Programming and Scripting
Hi,
I have a challenging task,in which i have to find the duplicate files by its name and size,then i need to take anyone of the file.Then i need to open the file and find for more than one pattern and count of that pattern.
Note:These are the samples of two files,but i can have more... (2 Replies)
Discussion started by: jerome Sukumar
2 Replies
3. Shell Programming and Scripting
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
4. Shell Programming and Scripting
Hi,
I just want to take each sql script from specified directory and print all tables in those sqls. Below is the script but getting an error lik
ksh: 0403-057 Syntax error: `(' is not expected.
Script is----
ls /ukdw/prd/working/TDMatrix/srualcb02/ukdw/prd/bin | awk '{printf("%s... (2 Replies)
Discussion started by: subrat
2 Replies
5. Shell Programming and Scripting
Hi ,
I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1,
t3= t1 - t2
t3= t1 - t2
I am new to scripts, any help please? thanks (7 Replies)
Discussion started by: Celine19
7 Replies
6. Shell Programming and Scripting
Hi,
I have to write a program to compute the checksums of files
./script.sh
I wrote the program using bash and it took me forever since I am a beginner but it works very well.
I'm getting so close to the deadline and I realised today that actually I have to use normal Bourne shell... (3 Replies)
Discussion started by: pgarg1989
3 Replies
7. Shell Programming and Scripting
Dear Members,
I have a table REQUESTS in Oracle which has an attribute REQUEST_ACTION. The entries in REQUEST_ACTION are like, ME, MD, ND, NE etc.
I would like to create a script which will will call other scripts based on the request action.
Can we directly read from the REQUEST_ACTION... (2 Replies)
Discussion started by: Yoodit
2 Replies
8. Shell Programming and Scripting
Hi i have to find the shell script that contain the word
PROC__TO_UPDATE
SEARCH SHOULD BE INSENSITIVE AND SCRIPT CAN BE DEPLOYED IN ANY PATH.
I am on Solaris. (27 Replies)
Discussion started by: rafa_fed2
27 Replies
9. Shell Programming and Scripting
dear all
please help me !
i need a script for exporting the selected tables of oracle database installed on CentOs.
i waiting your response.
thanks and regards (6 Replies)
Discussion started by: amirzargaran
6 Replies
10. UNIX for Advanced & Expert Users
Hi,
Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out... (1 Reply)
Discussion started by: techmoris
1 Replies
TBLCVT(1) General Commands Manual TBLCVT(1)
NAME
tblcvt - troffcvt preprocessor to convert tbl-format tables
SYNTAX
tblcvt [ file ] ...
DESCRIPTION
tblcvt examines troff input for tables that would normally be processed by the tbl program, i.e., for lines bracketed by the .TS table
start and .TE table end requests. tblcvt parses table specifications and data and converts it to a form that troffcvt can more easily han-
dle. This is useful for document processing commands that use troffcvt, since troffcvt has knowledge only of the troff input language, and
knows nothing of the tbl input language.
tblcvt is a direct replacement for tbl. Suppose you would normally process a document using tbl and troff (or groff, etc.) like this:
% tbl file ... | troff ...
To format the document using tblcvt and troffcvt, use a command like this:
% tblcvt file ... | troffcvt ...
Actually, it's more likely that you'll be using one of the troffcvt front ends such as troff2html than that you'll be using troffcvt
directly. troffcvt in the preceding command may be replaced by the name of the front end:
% tblcvt file ... | troff2html ...
If it seems that troffcvt or a front end are not reading the output from tblcvt , specify - after the option list to explicitly tell them
to read the standard input after processing their other options:
% tblcvt file ... | troffcvt ... -
% tblcvt file ... | troff2html ... -
DIAGNOSTICS
Diagnostic messages are written in this format:
tblcvt:line l (table t, section s): message...
This indicates that a problem was detected at line number l, and that tblcvt considers the line to be part of table number t and section s
within the table. Section numbers start at one and are incremented for each .T& request that occurs within a table specification.
SEE ALSO
troffcvt(1)
tblcvt - A troffcvt Preprocessor
WHO-TO-BLAME
Paul DuBois, dubois@primate.wisc.edu.
BUGS
For the most part, tblcvt assumes your tables make sense, i.e., are legal according to the tbl input language. tblcvt may complain about
malformed table constructs (if it detects them), but it may also get confused by them and generate garbage output.
tblcvt generates troff output that uses long request names, so you can't use compatibility mode -C ( option) with troffcvt or a troffcvt
front end.
tblcvt doesn't support vertically-spanned lines. It prints a warning when it detects one, but the table output won't be correct.
TBLCVT(1)