Shell Programming and Scripting

Hi Folks,

I have a input file of the below format.


~~~OLKIT~OLKIT~1~~TBD~BEST PAGER & WIRELESS~4899 COMMON MARKET PLACE~~~DUBLIN~KS~43016~I~Y~DIRECT~D~~0
BPGRWRLS~~~OLKIT~OLKIT~1~~TBD~BEST PAGER & WIRELESS~4899 COMMON MARKET PLACE~~~DUBLIN~KS~43016~I~Y~DIRECT~D~~0
BPI~~~OLKIT~OLKIT~1~~TBD~CITI CONNECTION~6413 18TH AVE~~~BROOKLYN~KS~11204~~Y~DIRECT~D~~0
BPNABOF~~~OLKIT~OLKIT~1~~TBD~BRIGHTPOINT NORTH AMERICA~501 AIRTECH PARKWAY~~~PLAINFIELD~KS~46168~~Y~DIRECT~DT~~0
BRADSINC~~~OLKIT~OLKIT~1~~TBD~BRADSHAW INC~4662 HORN LAKE RD~~~MEMPHIS~KS~38109~I~Y~DIRECT~D~~0
BWRES07TM~~~OLKIT~OLKIT~1~~TBD~BLUEFISH WIRELESS INC.~6100 WEST 96TH ST., SUITE 140~~~INDIANAPOLIS~KS~46278~~Y~DIRECT~J~~0
BYFGRPTM~~~OLKIT~OLKIT~1~~TBD~BYF GROUP, INC.~4810 BEAUREGARD ST.~~~ALEXANDRIA~KS~22312~~Y~DIRECT~F~~0



In the input file I have many no of lines which have "~" symbols in them.
In every line, I need to count the no. of times "~" occurs and compare it with a variable which is passed along with the shell script in the command line.

I have highlited each line in diffn color.

The command line format is
shell_script input_file.dat 20

In the above line 20 is the no to which the no of "~" are compared

Help is very much required as I am very new into shell scripting.


Regards
Srikanth GR

Try this:

Code:

#!/usr/bin/ksh

numtilde=$1

while read line; do
        tildeinline=$(($(echo $line | tr '~' '\n' | wc -l)-1))
        echo "Comparing with $numtilde. Current line has $tildeinline ~s"
done < test

The file test contains your data. BTW, I think that all lines have the same number of ~s (at least in the example they do).

Something like this?

Code:

awk 'NF!=n+1{print "Record",NR,"has",NF-1,"[~] :",$0}' FS="~" n=20 inputfile

Set n to your shell variable (n="var").

Code:

tildeinline=$(echo $line | tr -dc '~' | wc -c)

Or (with bash/ksh93?):

Code:

lno=1;while IFS= read -r;do 
	l=${REPLY//[^~]/} 
	printf "%s ~s in record number %s\n" ${#l} $lno 
	lno=$((lno+1))
done<inputfile

Hi

I have a small doubt in the above code.
How can i capture the NF variable out of that line
and use this variable for validation ?

Regards
Srikanth GR

Can you give some example for what validation you do?