03-21-2010
parse apl-numeric codes from filenames, and match them to entries in database
Hello,
I am new to Unix scripting, and would like some help with my issue:
I have vairous files having some alphanumeric codes in them e.g.
10000-01
34440TE
34590SR
All these codes are stored in the database, and I need to parse these codes out of these filenames, and match them with the database entries.
For instance:
File Name: 10000-01 Western Region.xls should match with database code 10000-01 or
South Region perf-34590SR.xls should match with database code 34590SR.
Also, the script should give me the code coming in from the filename in a variable.
Any help will be greatly appreciated for this critical task I have on hand.
Thanks,
Mel.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I don't have much experience in scripting, and couldn't find anything that will help me to write a script I need, hopefully you can help me with it.
I have lots of files in one directory with the following file name pattern:
100001-something.ext1
100101-something2.ext2... (4 Replies)
Discussion started by: troman
4 Replies
2. Shell Programming and Scripting
hi there.
in perl, I am struggling to find a simple method of connecting to a database, determining if the result of my query is "true" and then testing against the result. I dont even really want the data that i am 'SELECT'íng. i effectively just want to check that a record exists with a UID... (2 Replies)
Discussion started by: rethink
2 Replies
3. Shell Programming and Scripting
Hi Everyone,
Here's a snippet of my data:
File 1 = testRef2:
A1BG - 13208 13284
AAA1 - 34758475 34873943
AAAS - 53701240 53715412File 2 = 42MLN.3.bedS2:
13208
13208
13360
13363
13484
13518
13518My awk script:
awk 'NR == FNR{a=$1;next} {$1>=a}{$1<=a}{print... (5 Replies)
Discussion started by: heecha
5 Replies
4. Shell Programming and Scripting
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
Discussion started by: shellguy
15 Replies
5. Shell Programming and Scripting
Hello,
I have a text file with lines that look like this:
1974 12 27 -0.72743 -1.0169 2 1.25029
1974 12 28 -0.4958 -0.72926 2 0.881839
1974 12 29 -0.26331 -0.53426 2 0.595623
1974 12 30 7.71432E-02 -0.71887 3 0.723001
1974 12 31 0.187789 -1.07114 3 1.08748
1975 1 1 0.349933 -1.02217... (2 Replies)
Discussion started by: meridionaljet
2 Replies
6. Shell Programming and Scripting
Hi ,
I have a number say 12345001 which needs to be parsed. Its a number that has no delimiters.I have to read the last three digits and then the rest of digits irrespective of the total length of the number. The digits then have to be swapped and changed to a fixed length. The fillers to be... (10 Replies)
Discussion started by: Sheel
10 Replies
7. Shell Programming and Scripting
Hello All:
We are looking to search through 2000 files with around 21,000 statements where we have to search, replace and insert a pattern based on the following:
1) Parse through the file and check for CREATE MULTISET TABLE or CREATE SET TABLE statements.....and they always end with ON... (5 Replies)
Discussion started by: madhunk
5 Replies
8. Shell Programming and Scripting
I have a log file that's created daily by this command:
sar -u 300 288 >> /var/log/usage/$(date "+%Y-%m-%d")_$(hostname)_cpu.log
It that contains data like this:
Linux 3.16.0-4-amd64 (myhostname) 08/15/2015 _x86_64_ (1 CPU)
11:34:17 PM CPU %user %nice ... (12 Replies)
Discussion started by: unplugme71
12 Replies
9. Shell Programming and Scripting
i run command that return this result,example :
gigabitethernet2/2/4:NotPresent, gigabitethernet2/1/17:UP, gigabitethernet2/1/10:UP, gigabitethernet2/1/5:UP,
gigabitethernet2/1/9:UP, gigabitethernet2/1/36:DOWN, gigabitethernet2/1/33:DOWN, gigabitethernet2/1/8:UP,... (19 Replies)
Discussion started by: wanttolearn1
19 Replies
10. UNIX for Beginners Questions & Answers
I am on AIX.
I need to list the contents of the directory based on a pattern and write an XML output file with file names.
If a filename does NOT match the below pattern then write an OUTPUT xml file in the below xml format
Pattern
Starts with (.abc) and contains (def)
Starts with... (4 Replies)
Discussion started by: techedipro
4 Replies
LEARN ABOUT DEBIAN
ssgrep
SSGREP(1) GNOME SSGREP(1)
NAME
ssgrep - search spreadsheets for strings
SYNOPSIS
ssgrep [OPTIONS] [FILES]
DESCRIPTION
This manual page briefly documents the ssgrep command.
ssgrep is a command line utility to search for strings in spreadsheets of any format supported by gnumeric.
OPTIONS
This program follows the usual GNU command line syntax, with single letter options starting with a single dash (`-') and longer options
starting with two dashes (`--').
Options controlling input file handling
--recalc
Recalculate all cells
Options controlling patterns and pattern matching
-f, --keyword-file=FILE
The path to a text file containing one key per line
-i, --ignore-case
Ignore differences in letter case
-w, --word-regexp
Match only whole words
-F, --fixed-strings
Pattern is a set of fixed strings
-R, --search-results
Search results of expressions too
-v, --invert-match
Search for cells that do not match
Options controlling output in general
-c, --count
Only print a count of matches per file
-L, --files-without-matches
Print filenames without matches
-l, --files-with-matches
Print filenames with matches
-q, --quiet
Suppress all normal output
-H, --with-filename
Print the filename for each match
-h, --without-filename
Do not print the filename for each match
-n, --print-locus
Print the location of each match
-T, --print-type
Print the location type of each match
Help options
-V, --version
Display ssgrep's version
-?, --help
Display the supported options
--usage
Display a brief usage message
EXAMPLE
To search for the string "SUM" in the file foo.gnumeric :
ssgrep SUM foo.gnumeric
To search for the strings from the file keywords in the spreadsheet foo.xls :
ssgrep --keyword-file=keywords foo.xls
LICENSE
ssgrep is licensed under the terms of the General Public License (GPL), version 2. For information on this license look at the source code
that came with the software or see the GNU project page <http://www.gnu.org>.
COPYRIGHT
The copyright on ssgrep and the gnumeric software and source code is held by the individual authors as is documented in the source code.
AUTHOR
ssgrep's primary author is Jody Goldberg <jody@gnome.org>; ssgrep builds on the gnumeric codebase.
The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen (Ray) <jdassen@debian.org>.
SEE ALSO
beagled(1), gnumeric(1), ssconvert(1), ssindex(1)
The Gnumeric Homepage <http://www.gnome.org/projects/gnumeric/>.
The GNOME project page <http://www.gnome.org/>.
gnumeric 2009-02-08 SSGREP(1)