Shell Programming and Scripting

#!/bin/ksh

isnumeric()
{
	result=$(echo "$1" | tr -d '[[:digit:]]')
	echo ${#result}
}

isalpha()
{
	result=$(echo "$1" | tr -d '[[:alpha:]]')
	echo ${#result}
}
col1=""
col2=""
col3=""
col4=""
let retval=1

while read record
do
	echo "$record" | awk -F"|" '{print $1, $2, $3, $4 }' | read col1 col2 col3 col4
	
	if [[ $(isnumeric "$col1") -eq 1 && $(isnumeric "$col4") -eq 1 ]]; then
		 retval=1
	else
		 retval=0
		 break
	fi

	if [[ $(isalpha "$col2") -eq 1 && $(isalpha "$col3") -eq 1 ]]; then
		 retval=1
	else
		 retval=0
		 break
	fi
done  < filename

if [[ $retval -eq 1 ]]; then
	echo "test is okay"
else
	echo "test failed for this row:"
	echo "$col1 $col2 $col3 $col4"
fi

awk -F"|" ' $2~ "^[a-zA-Z][a-z[A-Z]*$" { print $2 }' file

awk -F"|" ' $2~ "^[^0-9][^0-9]*$" { print $2 }' file

awk -F"|" ' $1 ~ "^[0-9][0-9]*$" { print $1 }' file

>>> for lines in open("clientname_filename.csv"):
... 	lines = lines.strip().split("|")
... 	if not lines[0].isdigit() or not lines[3].isdigit():
...  		print "First or  fourth col not numeric: %s" %(lines)
... 	elif not lines[1].isalnum():
... 		print "Second col not alphanumeric: %s" %(lines)
... 	elif not lines[2].isalpha():
... 		print "Third col not char type: %s" %(lines)

awk -F"|" ' 
BEGIN {
getline var < "constraintfile"
getline var < "constraintfile" 
n = split( var , arr , "|" )
for ( i = 1 ; i <= n ; ++i )
{
        if( arr[i] == "Nu" )
                regexp[i] = "^[0-9][0-9]*$"
        if( arr[i] == "char" )
                regexp[i] = "^[a-zA-Z][a-z[A-Z]*$"
print regexp[i]
}
}
$1 ~ regexp[1] && $2 ~ regexp[2] && $3 ~ regexp[3] && $4 ~ regexp[4] {
print $0
}' file