10-08-2006
validating data
I have a file like the following
aaaaa00005bbbbb
aaaaa00108bbbbb
The code "00005" and "00108" need to be validated and the list of valid codes are stored in a database.
While I loop through the file, should call a sql statement for every records to do the validation? or is there a better way to do it?
Thanks in advance.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
This is what I have to check date entries in an interactive script with the end users... I use this to build control cards for a reporting utility supplied by a software vendor.
I also want to check to make sure its a valid day based on the month (ie 30days has sept, april, june and Nov..)... ... (2 Replies)
Discussion started by: MizzGail
2 Replies
2. Programming
how do i validate y script so that it only accepts values between 1 and 3 and against any character input, cause at the moment i can only validate against numbers outside 1 and 3 but not characters
cheers (4 Replies)
Discussion started by: ruffenator
4 Replies
3. UNIX for Dummies Questions & Answers
What's wrong with this syntax? It's part of my 'if' statement but it doesn't seem to pass and it keeps going to the 'else' part.
I thought it says that userid must start with a non-numeric character and is between 6 and 10 characters long (alphanumeric).
$userid|grep -Eq '^?\{6,10\}+$'
if... (2 Replies)
Discussion started by: giannicello
2 Replies
4. Shell Programming and Scripting
Hi there,
I'm trying to validate my $1 and $2 before I use them in the sqlplus update, I think I have the validation rules set correctly??? however when I test my script, it jumps straight into the sql. It doesn't seem to validate the vars....even when I know they are incorrect.
if ; then
... (6 Replies)
Discussion started by: nhatch
6 Replies
5. Shell Programming and Scripting
HELP: validating IP addresses any way possible
--------------------------------------------------------------------------------
I am trying to validate input from the user in a script. I thought is was easy to do using regular expressions but I can't figure out how to use REs in a... (1 Reply)
Discussion started by: nrodolfich
1 Replies
6. UNIX for Dummies Questions & Answers
Dear All,
Need your help.
In my day to day activities I have to validate/search Excel Sheet data (eg.say Application No. 0066782345) data into the Unix environment file whether the same data is present in that file or not.
There are hundreds of records coming in excel file and I am doing grep... (1 Reply)
Discussion started by: ravijunghare
1 Replies
7. UNIX for Dummies Questions & Answers
Pardon my ignorance but I am lost on how to do this
I have a file called "Sample.txt", it is pipe delimited, it should have 13 fields. But some of the records do not, I would like to set up a shell script
where I can pass in a parameter "Sample.txt" and it would split the file into records... (2 Replies)
Discussion started by: dgeehot
2 Replies
8. Shell Programming and Scripting
I have a file that contains records in the below format:
23857250998423948239482348239580923682396829682398094823049823948
23492780582305829852095820958293582093585823095892386293583203248
23482038509825098230958235234230502958205983958235820358205892095... (10 Replies)
Discussion started by: shellhelp
10 Replies
9. Shell Programming and Scripting
Hello All,
I have the following file. The first column is Type. Always the file will have one H and one T type in between all D type reocrds.
Need todo some validations.
H|ABCD
D|TAB N0003107809CD2013-11-14|RYAN|FRY|7 DR|RICHMOND HILL|GA|32431|X|C95|000009999|000000001|TAB||C0001
D|TAB... (3 Replies)
Discussion started by: karumudi7
3 Replies
LEARN ABOUT MOJAVE
vconsole.conf
VCONSOLE.CONF(5) vconsole.conf VCONSOLE.CONF(5)
NAME
vconsole.conf - configuration file for the virtual console
SYNOPSIS
/etc/vconsole.conf
DESCRIPTION
The /etc/vconsole.conf file configures the virtual console, i.e. keyboard mapping and console font.
The basic file format of the vconsole.conf is a newline-separated list environment-like shell-compatible variable assignments. It is
possible to source the configuration from shell scripts, however, beyond mere variable assignments no shell features are supported,
allowing applications to read the file without implementing a shell compatible execution engine.
Note that the kernel command line options vconsole.keymap=, vconsole.keymap.toggle=, vconsole.font=, vconsole.font.map=,
vconsole.font.unimap= may be used to override the console settings at boot.
Depending on the operating system other configuration files might be checked for configuration of the virtual console as well, however only
as fallback.
OPTIONS
The following options are understood:
KEYMAP=, KEYMAP_TOGGLE=
Configures the key mapping table of for they keyboard. KEYMAP= defaults to us if not set. The KEYMAP_TOGGLE= can be used to configured
a second toggle keymap and is by default unset.
FONT=, FONT_MAP=, FONT_UNIMAP=
Configures the console font, the console map and the unicode font map. FONT= defaults to latarcyrheb-sun16.
EXAMPLE
Example 1. German keyboard and console
/etc/vconsole.conf:
KEYMAP=de-latin1
FONT=latarcyrheb-sun16
SEE ALSO
systemd(1), loadkeys(1), setfont(8), locale.conf(5)
AUTHOR
Lennart Poettering <lennart@poettering.net>
Developer
systemd 10/07/2013 VCONSOLE.CONF(5)