Sponsored Content
Full Discussion: Need help
Top Forums Shell Programming and Scripting Need help Post 302104644 by dsravan on Friday 26th of January 2007 11:18:04 AM
Old 01-26-2007
Need help

I have a problem. I have a direcotry where i have files named as below

-rwxr-x--- 1 sadalbid dwro 953 Jan 4 17:03 tables.telg.subs.txt
-rwxr-x--- 1 sadalbid dwro 79 Jan 4 17:03 tables.telg.sub2.txt
-rw-r--r-- 1 sadalbid dwro 268 Jan 4 17:03 tables.telg.prty.txt
-rwxr-x--- 1 sadalbid dwro 349 Jan 4 17:03 tables.telg.prod.txt
-rwxr-x--- 1 sadalbid dwro 45 Jan 4 17:03 tables.telg.addr.txt

I have to loop thruogh these text files and get the table name which is the first field in the file. for e.g cat on one of the files above will produce o/p like this

cat tables.telg.subs.txt

acct STD
acct_chrg_off_actvt STD
acct_crdt_hist STD
acct_sgmnt_hist HST
acct_sts_hist HST
acct_upd STD
acct_upd2 STD
acct_inv_due_dt STD
cllctn_agnc_avt AVT
cpni_srv_hist HST
cpni_sts_avt AVT
cpni_sts_hist HST

I have to take the first column from each file here which is the table name and replace in another file which deletes the data from all these tables. How can i loop through all the files and replace the table name in my actual script to delete the data from the tables in these files only. Please suggest.

My delete script looks like this; I want to make it automated so that i don't need to run it manually.

delete from acct;
.IF ERRORCODE <> 0 Then .QUIT 1
delete from acct_chrg_off_actvt ;
.IF ERRORCODE <> 0 Then .QUIT 2
 
dos2unix(1)						      General Commands Manual						       dos2unix(1)

NAME
dos2unix - DOS/MAC to UNIX text file format converter SYNOPSYS
dos2unix [options] [-c convmode] [-o file ...] [-n infile outfile ...] Options: [-hkqV] [--help] [--keepdate] [--quiet] [--version] DESCRIPTION
This manual page documents dos2unix, the program that converts plain text files in DOS/MAC format to UNIX format. OPTIONS
The following options are available: -h --help Print online help. -k --keepdate Keep the date stamp of output file same as input file. -q --quiet Quiet mode. Suppress all warning and messages. -V --version Prints version information. -c --convmode convmode Sets conversion mode. Simulates dos2unix under SunOS. -o --oldfile file ... Old file mode. Convert the file and write output to it. The program default to run in this mode. Wildcard names may be used. -n --newfile infile outfile ... New file mode. Convert the infile and write output to outfile. File names must be given in pairs and wildcard names should NOT be used or you WILL lost your files. EXAMPLES
Get input from stdin and write output to stdout. dos2unix Convert and replace a.txt. Convert and replace b.txt. dos2unix a.txt b.txt dos2unix -o a.txt b.txt Convert and replace a.txt in ASCII conversion mode. Convert and replace b.txt in ISO conversion mode. Convert c.txt from Mac to Unix ascii format. dos2unix a.txt -c iso b.txt dos2unix -c ascii a.txt -c iso b.txt dos2unix -c mac a.txt b.txt Convert and replace a.txt while keeping original date stamp. dos2unix -k a.txt dos2unix -k -o a.txt Convert a.txt and write to e.txt. dos2unix -n a.txt e.txt Convert a.txt and write to e.txt, keep date stamp of e.txt same as a.txt. dos2unix -k -n a.txt e.txt Convert and replace a.txt. Convert b.txt and write to e.txt. dos2unix a.txt -n b.txt e.txt dos2unix -o a.txt -n b.txt e.txt Convert c.txt and write to e.txt. Convert and replace a.txt. Convert and replace b.txt. Convert d.txt and write to f.txt. dos2unix -n c.txt e.txt -o a.txt b.txt -n d.txt f.txt DIAGNOSTICS
BUGS
The program does not work properly under MSDOS in stdio processing mode. If you know why is that so, please tell me. AUTHORS
Benjamin Lin - <blin@socs.uts.edu.au> Bernd Johannes Wuebben (mac2unix mode) <wuebben@kde.org> MISCELLANY
Tested environment: Linux 1.2.0 with GNU C 2.5.8 SunOS 4.1.3 with GNU C 2.6.3 MS-DOS 6.20 with Borland C++ 4.02 Suggestions and bug reports are welcome. SEE ALSO
unix2dos(1) mac2unix(1) 1995.03.31 dos2unix v3.0 dos2unix(1)
All times are GMT -4. The time now is 04:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy