Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to validate a column?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to validate a column?
# 8  
Old 11-02-2008
Quote:
Originally Posted by muruganksk
can you post your scriplet over here.. So that I can have a look.
#!/bin/bash
while read num domain
do
if [ $num -ge 200 ] ; then
echo "postmaster@"$domain
fi
done < /export/home/john/columns.txt


columns.txt:

220 shoes.com
217 dishwashers.net
209 cars.org
201 bikes.gov
175 beer.org
160 wine.net
154 food.com
148 paintball.com
132 pingpong.net
122 macaroni.com
# 9  
Old 11-03-2008
modify below print code with the mail.... script bracketed with () should be ok.

Code:
awk '($1>=200){print "mail to postmaster@"$2}' filename

# 10  
Old 11-03-2008
Quote:
Originally Posted by summer_cherry
modify below print code with the mail.... script bracketed with () should be ok.

Code:
awk '($1>=200){print "mail to postmaster@"$2}' filename

Hi,
Thanks.
To be sure: your piece of code entirely replaced by this snippet?

while read num domain
do
if [ $num -ge 200 ] ; then
echo "postmaster@"$domain
fi
done < /export/home/john/columns.txt
# 11  
Old 11-03-2008
u may try this;
awk ' { if ($1>199) print " postmaster@" $2 " } ' yourfilename >outfile

i presume second column is domain.
# 12  
Old 11-03-2008
Some double quotes are missed in the previous script.
try this....

Code:

while read num domain
do
if [ "$num" -ge "200" ]
then
echo "postmaster@"$domain
fi
done < inputfilename
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Difference of the same column when two other column matches and one column differs less than 1 hour

This is my input file : # cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9 This is the required output ... (1 Reply)
Discussion started by: Lakshmikumari
1 Replies

2. Shell Programming and Scripting

validate timestamp

How to validate the user supplied timestamp? Ther requirement is as follows. While invoking the script, the parameters passed to the script are minimum and maixmum timestamps. let's say min_tstmp and max_tstmp ksh abc.ksh 2011-09-01-00:00:00 2011-12-01-00:00:00 so... (3 Replies)
Discussion started by: kmanivan82
3 Replies

3. Shell Programming and Scripting

Need to validate that all 24 hr are in a table

I have a table that looks like this, but for a whole year: Hourly weather history for XXX 7 Jun 0:00 Clear weather 28 1:00 Clear weather 23 2:00 Clear weather 21 3:00 Clear weather 22 4:00 Clear weather 22 5:00 Clear weather 22 6:00 Clear weather 23 7:00 Clear... (12 Replies)
Discussion started by: paulyester
12 Replies

4. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2 file 1 sample SNDK 80004C101 AT XLNX 983919101 BB NETL 64118B100 BS AMD 007903107 CC KLAC 482480100 DC TER 880770102 KATS ATHR 04743P108 KATS... (7 Replies)
Discussion started by: rydz00
7 Replies

5. Shell Programming and Scripting

Validate and Calculate

Hi, i am trying to validate 2 variables and then subtract, the following code works well in AiX but when i try in Solaris it doesnt work. ((TIME1>TIME2)) && ((TIME2=TIME2+864)) ((DIF=TIME2-TIME1)) echo difference = $DIF Seconds is there any way the validation can be done using... (2 Replies)
Discussion started by: Shellslave
2 Replies

6. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12... (5 Replies)
Discussion started by: manneni prakash
5 Replies

7. Shell Programming and Scripting

How to validate an IP address

hi I need a simple script to do the following. I need to check the user input for 1. quad dotted notation. 2. check that all of the inputs are numeric and within 1-255 range. Could someone please help me? I tried to use egrep to check for dotted notation. quad=1.1.1.12 ... (5 Replies)
Discussion started by: sabina
5 Replies

8. Shell Programming and Scripting

How to Validate

I have one script by which I am taking Extraction Schedule in the following format ,,,...... Here I want validate the Input from user is okey or not. Let say i have one variable SCH SCH=12:34,23:12,11:20 Could you please tell me how I will validate it. HH & MM Both should be Numeric HH... (10 Replies)
Discussion started by: SanjayLinux
10 Replies

9. Shell Programming and Scripting

Better way to Validate column data in file.

I am trying to validate the third column in a pipe delimited file. The column must be 10 char long and all digits 0-9. I am writing out two new files from the existing file, if it would be quicker, I could leave the bad rows in the file and ignore them in the next process. What I have is... (12 Replies)
Discussion started by: barry1
12 Replies

10. Shell Programming and Scripting

validate

hi need help here, a bit of code im doing requires a number to be enetered i have got validation and loop if its outside a ceratain range, but was wondering what code i need to validate if a character has been entered. cheers (3 Replies)
Discussion started by: ruffenator
3 Replies
Login or Register to Ask a Question