I have a requirement where I need parse through files in a directory which have a specific pattern and then check whether the file has been processed or not. The exit condition is any file that has been processed will have an entry in database. If it is processed i.e., if an entry is present for the file in database then I need to skip it and move towards the next file in the order of ascending dates
What database are you using? How do you access your database? What keys are used in your database? What field in your database contains the name of the file? Is it a filename or a pathname?
How is the age of a file to be determined? (Last modification timestamp? A timestamp encoded in the name of the file? Something else?)
What database are you using? How do you access your database? What keys are used in your database? What field in your database contains the name of the file? Is it a filename or a pathname?
How is the age of a file to be determined? (Last modification timestamp? A timestamp encoded in the name of the file? Something else?)
What have you tried to solved this?
AIX
ksh
Oracle
Access using sqlplus within script
Database field contains file pattern not file name and in another column it contains absolute path
age of file to be determined by modification timestamp
Currently my script has a logic where it aborts with exit code 1 if it finds more than one file matching the pattern
The current script has above logic
Last edited by abhilashnair; 06-26-2015 at 05:47 AM..
... ... ...
Currently my script has a logic where it aborts with exit code 1 if it finds more than one file matching the pattern
... ... ...
... ... ...
... ... ...
The current script has above logic
You say: "Currently my script has a logic where it aborts with exit code 1 if it finds more than one file matching the pattern". Is this what you want your script to do? If not, what do you want this script to do?
Note that if the first two characters of your script are not #! (note the two leading spaces in your script), if you invoke this script by name (as opposed to invoking it by running ksh scriptname), this script will be run using your system's default shell; not necessarily /bin/ksh.
If you want to know if your script was called with 12 arguments, a much safer test would be:
Why do you explicitly complicate your SQL script to add double quotes to the output it produces when the only use for those quotes is to write more code in your script to strip out those quotes?
There are several sequences of similar pipelines of very similar commands repeatedly processing the same input to extract individual fields. It would be MUCH MUCH more efficient to run those commands once, printing the values desired for all of the fields to be set, and pipe it those results through read to set all of the variables at once.
Hi there,
Here is my checklist of items,
4.1.1 Alerter
4.1.2 Client Services for Netware
4.1.3 Clipbook
4.1.4 Fax Service
4.1.5 File Replication
4.1.6 File Services for Macintosh
4.1.7 FTP Publishing Service
4.1.8 Help and Support
4.1.9 HTTP SSL
4.1.10 IIS Admin Service ... (1 Reply)
Hello,
I have a very long list of file (see input below). I only need the first "chunk" of the line before the space and omit the rest. Also, the > sign needs to be excluded. Can anyone help me please?
Thank you so much!
INPUT:
>gi|24976465|gb|AL935113.1|AL935113 AL935113 Homo sapiens... (4 Replies)
Most of the code I've seen is been listing processes or capturing process ids, etc. But here's what I need to do. Preferably in Korn shell.
1. do a ps -ef |grep tns |grep -v grep
in order to get a list or Oracle listeners that are running.
2. parse the line into components which... (7 Replies)
Hi
I have a vcf file with 20000 lines, it looks like this-
23 122691 . C 1345.09 PASS
33 122961 . C 833.45 PASS
43 122970 . A 689.75 PASS
53 123009 . T 118.99 PASS
63 123033 . T 46.85 PASS
73 123042 . A 127.51 PASS
83 123060 . T 299.64 PASS
93 123081 . T 299.64 PASS... (3 Replies)
Hello I am trying to develop a shell script that takes a text file such as this...
E-mail@ Soc.Sec.No. *--------Name-----------* Class *School.Curriculum.Major.* Campus.Phone
JCC2380 XXX-XX-XXXX CAREY, JULIE C JR-II BISS CPSC BS INFO TECH 412/779-9445
JAC1936 XXX-XX-XXXX... (7 Replies)
Hi folks,
I have a list of XML files with entries like this one:
<Item Name="Author" Type="String">Stark F</Item>
<Item Name="Author" Type="String">Pfannstiel J</Item>
<Item Name="Author" Type="String">Klaiber I</Item>
<Item Name="Author" Type="String">Raabe T</Item>
and what I would like... (1 Reply)
Hi
I wanted to print/store just a specific element of the list . I have got the list as an output of grep command.
here is code snap below :
end_no=`egrep -ni '!return code: 0|return code other than 0' temp.log | cut -d':' -f1`
this will return the line numbers in end_no. I just... (2 Replies)
Hello,
somewhere in a shell script, i am storing the output of "ls" into a variable. My question is how can i parse this variable to get each filepath. I don't want to create a temporary file to write down all the filenames and then parse it..
is there a easy way out..
here is what... (3 Replies)
I have two text files. I need to parse the data. It's names of file and I am using it to rename files. I have file1 containing the original file name and file2 containing the renamed name of the file. I need to parse them together in one file, which will be easy to use the mv command.
This is... (4 Replies)