05-09-2011
awk for validating
HI,
I am trying to write a validation script as below
awk '($1=="ABC"&&$2="XYZ" ,then check the value in $8,$10 these columns should not be null.
so their should be some corresponding value n the $8 and $10 column,if their is no value the script has to give error saying that at a particular line there is no corresponding value and it should throw error.
please give me some hint how to do this.
Regards,
Gaur
10 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. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: joanneho
1 Replies
7. Shell Programming and Scripting
Hi All,
This is a small snippet that I am using to validate the format of IP address.This is working fine.
Since this is not elegant, please let me know if anyone has a better working code than the one below.
Also I am planning to ping the ip address given by the user and check the $?... (3 Replies)
Discussion started by: nua7
3 Replies
8. 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
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
10. Shell Programming and Scripting
can someone please help me fix this command:
somecommand.sh | awk -F"---" 'BEGIN{count=0} /P/ && /ERROR/ {if (($3 ~ /^P$/) && ($6 ~ /ERROR/)) {print; count++ }END { print count } ;}'
basically, what i'm attempting to do here is print all the matching lines, then, at the end, print the total... (2 Replies)
Discussion started by: SkySmart
2 Replies
LEARN ABOUT FREEBSD
colrm
COLRM(1) BSD General Commands Manual COLRM(1)
NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
awk(1), column(1), cut(1), paste(1)
HISTORY
The colrm command appeared in 3.0BSD.
BSD
August 4, 2004 BSD