To count a string with in a variable Post: 302450127

Sponsored Content

Top Forums Shell Programming and Scripting To count a string with in a variable Post 302450127 by vpv0002 on Wednesday 1st of September 2010 06:41:18 PM

09-01-2010

Registered User

To count a string with in a variable

I am writing a ksh to check for duplicate records in two different set of tables on oracle database, to get this i am running two plsql qurries at a time through the ksh, so the output of the qurries will be stored in variable say "SQL_STRING". So now to say if duplicate records exists in table or not i have to write a script which checks the count of the word "no rows selected" in the SQL_STRING variable.

One of our friend on UNIX.COM helped me with the code below which counts from a file instead of from a variable

Code:

#!/bin/ksh
str='no rows selected'
num=$(awk '{n+=gsub(str,"")}END{print n}' str="${str}" mySampleFile.txt)
echo "Total number of [${str}] = ${num}"

For example the variable SQL_STRING has data as below:

no rows selected no rows selected
ora-1234 sql querry failed
no rows selected

Now we should look for the string "no rows selected" (note: it has spaces between) in the variable SQL_STRING and then store the count of the string in a variable.
for the above data the output should be 3 since the string "no rows selected" occurred three times.
Any help is appreciated.

vpv0002

View Public Profile for vpv0002

Find all posts by vpv0002

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

select count(*) into a variable

Hi, Could anybody help me how can I assign the value of "select count(*) from table1" to a variable in an unix shell script. Thanks.

2. Shell Programming and Scripting

Using sed to replace a string in file with a string in a variable that contains spaces

Hi, i call my shell like: my_shell "my project name" my script: #!/bin/bash -vx projectname=$1 sed s/'PROJECT_NAME ='/'PROJECT_NAME = '$projectname/ <test_config_doxy >temp cp temp test_config_doxy the following error occurres: sed s/'PROJECT_NAME ...

3. Shell Programming and Scripting

Appending string, variable to file at the start and string at end

Hi , I have below file with 13 columns. I need 2-13 columns seperated by comma and I want to append each row with a string "INSERT INTO xxx" in the begining as 1st column and then a variable "$node" and then $2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13 and at the end another string " ; COMMIT;" ...

4. Shell Programming and Scripting

count of a string within a variable

I am writing ksh to check for duplicate records in two different set of tables on oracle database, to get this i am running two plsql qurries at a time through the ksh, so the output of the qurries will be stored in variable say "SQL_STRING". So now to say if duplicate records exists in table or...

5. UNIX for Dummies Questions & Answers

How to set a variable with a count variable i.e. VARIABLE$COUNT

Hi All I've very nearly finished this script I'm working on but have hit another idiots problem, after googling I can't see a solution for this one. I have a while count loop that checks checks two consecutive values then increments the count by two. What the script has to do is then check...

6. Shell Programming and Scripting

replace (sed?) a string in file with multiple lines (string) from variable

Can someone tell me how I can do this? e.g: a=$(echo -e wert trewt ertert ertert ertert erttert erterte rterter tertertert ert) How do i replace the STRING with $a? I try this: sed -i 's/STRING/'"$a"'/g' filename.ext but this don' t work

7. UNIX for Dummies Questions & Answers

Comparing a String variable with a string literal in a Debian shell script

Hi All, I am trying to to compare a string variable with a string literal inside a loop but keep getting the ./testifstructure.sh: line 6: #!/bin/sh BOOK_LIST="BOOK1 BOOK2" for BOOK in ${BOOK_LIST} do if then echo '1' else echo '2' fi done Please use next...

8. Shell Programming and Scripting

Grep a string and count following lines starting with another string

I have a large dataset with following structure; C 0001 Carbon D SAR001 methane D SAR002 ethane D SAR003 propane D SAR004 butane D SAR005 pentane C 0002 Hydrogen C 0003 Nitrogen C 0004 Oxygen D SAR011 ozone D SAR012 super oxide C 0005 Sulphur D SAR013...

9. Shell Programming and Scripting

awk variable search and line count between variable-search pattern

10. UNIX for Beginners Questions & Answers

Check if string variable is a subset of another string variable

Below is my ksh shell script where I need to check if variable fileprops is a subset of $1 argument. echo "FILE PROPERTY: $fileprops" echo "PARAMETER3: $1" if ; then echo "We are Good. $line FILE is found to be INTACT !! " else echo...

LEARN ABOUT CENTOS

rgb2ycbcr

RGB2YCBCR(1)						      General Commands Manual						      RGB2YCBCR(1)

NAME

       rgb2ycbcr - convert non-YCbCr TIFF images to a YCbCr TIFF image

SYNOPSIS

       rgb2ycbcr [ options ] src1.tif src2.tif ... dst.tif

DESCRIPTION

       rgb2ycbcr converts RGB color, greyscale, or bi-level TIFF images to YCbCr images by transforming and sampling pixel data. If multiple files
       are specified on the command line each source file is converted to a separate directory in the destination file.

       By default, chrominance samples are created by sampling 2 by 2 blocks of luminance values; this can be changed with the -h and -v  options.
       Output  data  are  compressed with the PackBits compression scheme, by default; an alternate scheme can be selected with the -c option.	By
       default, output data are compressed in strips with the number of rows in each strip selected so that the size of a strip is never more than
       8 kilobytes; the -r option can be used to explicitly set the number of rows per strip.

OPTIONS

       -c     Specify  a  compression  scheme to use when writing image data: -c none for no compression, -c packbits for the PackBits compression
	      algorithm (the default), -c jpeg for the JPEG compression algorithm, -c zip for the deflate compression algorithm, and  -c  lzw  for
	      Lempel-Ziv & Welch.

       -h     Set the horizontal sampling dimension to one of: 1, 2 (default), or 4.

       -r     Write data with a specified number of rows per strip; by default the number of rows/strip is selected so that each strip is approxi-
	      mately 8 kilobytes.

       -v     Set the vertical sampling dimension to one of: 1, 2 (default), or 4.

SEE ALSO

       tiffinfo(1), tiffcp(1), libtiff(3)

       Libtiff library home page: http://www.remotesensing.org/libtiff

libtiff 							 November 2, 2005						      RGB2YCBCR(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

select count(*) into a variable

Discussion started by: nguda

2. Shell Programming and Scripting

Using sed to replace a string in file with a string in a variable that contains spaces

Discussion started by: vivelafete

3. Shell Programming and Scripting

Appending string, variable to file at the start and string at end

Discussion started by: Vaddadi

4. Shell Programming and Scripting

count of a string within a variable

Discussion started by: vpv0002