Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

To Count a particular string with spaces in a file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting To Count a particular string with spaces in a file
# 8  
Old 09-01-2010
[/COLOR]
Quote:
Originally Posted by vgersh99
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}"


The above code is working great if we are looking in a file, simillarly can anyone help me getting the same output by looking in a variable instead of a file which has data.

for example when looking for count of a string "no rows selected" in a variable $SQL_STRING with data:

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

should get me an output 3.
Last edited by vpv0002; 09-01-2010 at 08:00 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I replace a string in file that is in a certain position with spaces?

I am trying to replace the string in position 26 through 35 of the data file with 10 spaces and I want the remaining file to stay as is, the record length is over 900 characters? I am trying to use the AWK and substr but I am not getting it formatted correctly. Before... (6 Replies)
Discussion started by: fnwine1500
6 Replies

2. Shell Programming and Scripting

Count number of occurrence of a string in file

if there's a file containing: money king money queen money cat money also money king all those strings are on one line in the file. how can i find out how many times "money king" shows up in the line? egrep -c "money king" wont work. (7 Replies)
Discussion started by: SkySmart
7 Replies

3. Shell Programming and Scripting

Recursive find / grep within a file / count of a string

Hi All, This is the first time I have posted to this forum so please bear with me. Thanks also advance for any help or guidance. For a project I need to do the following. 1. There are multiple files in multiple locations so I need to find them and the location. So I had planned to use... (9 Replies)
Discussion started by: Charlie6742
9 Replies

4. Post Here to Contact Site Administrators and Moderators

Want a tcl script to compare a string in a file ignoring white spaces

Hi , I want a tcl script to search a string ignoring whitespaces in a .log file . It should correctly match . The string are as follows "Output-Maps 1 1 0 0 0" 1 and Active Intermediate-Maps 0 0 0 ... (1 Reply)
Discussion started by: kulua
1 Replies

5. Shell Programming and Scripting

How to count number of occurances of string in a file?

Gurus, Need little guidance. I have A.txt and B.txt file. B.txt file contains Unique strings. Sample content of B.txt file for which i cut the fourth column uniquely and output directed to B.txt file And A.txt file contains the above string as a fourth column which is last column. So A.txt... (7 Replies)
Discussion started by: Shirisha
7 Replies

6. Shell Programming and Scripting

Parse file from remote server to calculate count of string existence in that file

Hi I need to parse the file of same name which exist on different servers and calculate the count of string existed in both files. Say a file abc.log exist on 2 servers. I want to search for string "test" on both files and calculate the total count of search string's existence. For... (6 Replies)
Discussion started by: poweroflinux
6 Replies

7. 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 ... (2 Replies)
Discussion started by: vivelafete
2 Replies

8. Shell Programming and Scripting

Searching a particular string with spaces in a data file

Hi, I'm new to shell scripting and require your help in achieving the requirement. I have a data file which stores organization name as one of the column data in a csv data file. Organization name stored in data file is: Canadian OU CAD Sample Data file: 1,5,4,5,, ... (9 Replies)
Discussion started by: andy4013
9 Replies

9. UNIX for Dummies Questions & Answers

Grep and count the string in a file.

Hi, I have to grep a word 'XYZ' from 900 files ( from 2007 till date), take its count month wise. The output should display month, count , word 'XYZ' . I tried searching the forum for solution but could find any. I would apprieciate if any one can help me asap .... Many Thanks:) (12 Replies)
Discussion started by: vikram2008
12 Replies

10. UNIX for Dummies Questions & Answers

count string occurance in a file hourly

Hi, I file that has all the status for one day (24hours). Now what I want to do is to count the occurence of a string in its output hourly like for example count occurance of successful or asynchronous clear destinon for every hour and redirect it to file. Please see sample file below. Please... (2 Replies)
Discussion started by: ayhanne
2 Replies
Login or Register to Ask a Question

LEARN ABOUT HPUX

expand

expand(1)						      General Commands Manual							 expand(1)

NAME

       expand, unexpand - expand tabs to spaces, and vice versa

SYNOPSIS

       tablist] [file ...]

       tablist] [file ...]

   Obsolescent:
       tabstop] tabn] [file ...]

DESCRIPTION

       processes  the named files or the standard input and writes to the standard output with tabs changed into spaces.  Backspace characters are
       preserved in the output, and the column count is decreased by one column for tab calculations.  For proper tab calculation, if a multi-col-
       umn  character  is  to be "backspace'd", it should be followed by multiple backspace characters which equal to it's column width.  If a tab
       character is found after the last tab position, it is replaced by a single space.  is useful for preprocessing character files that contain
       tabs (before sorting, looking at specific columns, etc).

       recognizes the following command-line options and arguments:

	      tablist	     specifies	where  to set the tab positions instead of the default tablist can take two forms.  If it is a single num-
			     ber, tabs are set tablist spaces apart.  tablist can also be a blank- or comma-separated list of increasing positions
			     where tabs are to be set.

	      This option is obsolescent and is equivalent to using

	      This option is obsolescent and is equivalent to using

       processes  the  named  files  or  the  standard	input  and writes to the standard output with spaces changed into tabs where possible.	By
       default, only leading spaces and tabs are converted to maximal strings of tabs.	The default tab position is every 8 characters.  Backspace
       characters  are	preserved  into the output, and the column count is decreased by one column for tab calculations.  For proper tab calcula-
       tion, if a multi-column character is to be "backspace'd", it should be followed by multiple backspace characters which equal to it's column
       width.

       recognizes the following command-line options and arguments:

	      Tabs are inserted whenever they would compress the resultant file
			     by replacing two or more spaces before a tab position.

	      tablist	     specifies	the tab positions.  tablist can take two forms.  If it is a single number, tabs are set every tablist spa-
			     ces apart.  If tablist is a blank- or comma-separated list of increasing positions, tabs are set at those	locations.
			     The  option  implies the option.  If the option is not specified, the default is equivalent to specifying except that
			     is not implied for this case.

EXTERNAL INFLUENCES

   Environment Variables
       determines the interpretation of text as single and/or multi-byte characters.

       determines the language in which messages are displayed.

       If or is not specified in the environment or is set to the empty string, the value of is used as a default for each  unspecified  or  empty
       variable.  If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of

       If  any internationalization variable contains an invalid setting, and behave as if all internationalization variables are set to "C".  See
       environ(5).

       If is set to a non-empty string value, it overrides the values of all the other internationalization variables.

   International Code Set Support
       Single- and multi-byte character code sets are supported with the exception that do not recognize multi-byte alternative space characters.

STANDARDS CONFORMANCE

																	 expand(1)