Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

validating a input file for numeric and character

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting validating a input file for numeric and character
# 1  
Old 01-07-2009
validating a input file for numeric and character
i have a input file like this

001|rahim|bajaj|20090102

while reading the file i need to check whether the first column is a number
second column is a name

is there any methodology to check for the same

thanks in advance
# 2  
Old 01-07-2009
Quote:
Originally Posted by trichyselva
i have a input file like this

001|rahim|bajaj|20090102

while reading the file i need to check whether the first column is a number
second column is a name

is there any methodology to check for the same

Code:
while IFS='|' read a b c d
do
  case $a in
    *[![:digit:]]*) echo First column is not a number ;;
    *) echo First column is a number ;;
  esac

  case $b in
   *[![:alpha:]]*) echo Second column is not a name ;;
   *) echo Second column is a name ;;
  esac
done < "$FILE"

# 3  
Old 01-07-2009
using awk:
Code:
awk -F '|' '{ if($1 !~ /^[0-9]*$/) { print $1 " is not numeric in " $0; }  if($2 !~/^[a-zA-Z]*$/) { print $2 " is not alphabetic in " $0 } }' filename

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Validating user input

I'm trying to set up a script that takes user input and validates that the user input was entered correctly. So far I have this: while : do echo "Please enter your name." read NAME if then echo "You have not entered a name." echo... (13 Replies)
Discussion started by: fufaso
13 Replies

2. Shell Programming and Scripting

Validating Input parameters

Hi All, I have tried to use ckdate (sun) command in script. It checks the input parameter which should be in 'YYYYMMDD format. date=$( echo $1 | ckdate -f "%Y%m%d") | true if ] then print " success" else print "no success" fi But in whatever format i pass the parameter,... (3 Replies)
Discussion started by: Amit.Sagpariya
3 Replies

3. UNIX for Dummies Questions & Answers

Validating input based on fixed number of fields

Yes, i did... let me state my problem in more detail Inputs: I have one input CSV file And, i have stored no. of comma each line should in a variable. e.g. $ cat cmt.csv this, is a ,comma ,count test1 ,,this, is a ,comma ,count test2 this, is a ,comma ,count test3... (6 Replies)
Discussion started by: Dipali
6 Replies

4. Shell Programming and Scripting

Validating user input is not blank

Trying to create a script in BASH that would ask the user to enter another user name making sure the input is not blank before they hit enter then to check the home directory of that user does exist, I have the check folder sorted it's just the loop to make sure the user has entered chars (5 Replies)
Discussion started by: MBN
5 Replies

5. Shell Programming and Scripting

How can I get rid of the ` character from input file?

A sed command works most of the time however it fails sometimes. I put each line (record) I read of a file through the following command data=$(cat file | sed 's///g' | sed 's|.*ex:Msg\(.*\)ex:Msg.*|\1|' ) When I run the script I get a message that states that there is an invalid format... (6 Replies)
Discussion started by: gugs
6 Replies

6. Shell Programming and Scripting

Validating the input date format

I have one script.for that the inputs are fromdate(dd/mon/yyyy) and todate(dd/mon/yyyy). How i can validate the input format?for eg.27/08/2008 is not valid.27/aug/2008 or 27/Aug/2008 are valid. and the todate is optional.so if the todate is not present in the input then i need to assign the... (6 Replies)
Discussion started by: Sharmila_P
6 Replies

7. Shell Programming and Scripting

Perl code to differentiate numeric and non-numeric input

Hi All, Is there any code in Perl which can differentiate between numeric and non-numeric input? (11 Replies)
Discussion started by: Raynon
11 Replies

8. Shell Programming and Scripting

validating variables (numeric)

Hi I need to get a user to enter a number (an exchange rate) into a script. I have the following: #!/bin/ksh echo "Enter exchange rate:" read EX_RATE if \"`" ] then echo "Well done - only numeric here" else echo "Not so well done - there is NON numeric stuff here!" fi This works... (3 Replies)
Discussion started by: pjd1
3 Replies

9. Shell Programming and Scripting

validating input using regular expressions

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 conditional. I have tried using grep from a temp file, sed from a temp file, sed from command line, comparison in an if condition and I cannot... (1 Reply)
Discussion started by: nrodolfich
1 Replies

10. Programming

validating input

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
Login or Register to Ask a Question