Reading file and assigning that to Variable Post: 302181675

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Reading from a file and assigning values

HI I have something like this in a file ABC = 1 DEF = 2 GHI = 3 JKL = 4 MNO = 5 QRS = 6 TUV = 7 I need to assign ABC to V_abc (that is to a variable) GHI to V_ghi (that is to another variable) TUV to say V_tuv ...

2. UNIX for Dummies Questions & Answers

Assigning value in a text file to a variable

Hi, I need to place a number located in a text file in a variable so I can perform if/then comparison. How would I go about doing this? Using A=awk '{print $2}' maintenance_date.tmp does not seem to work. Thanks

3. UNIX for Dummies Questions & Answers

Searching a text file and assigning it to a variable

Hi Gurus, I am new to unix.I have a requirement as below I have text file like a.txt which contains a.txt hi hello process update status Ok to Proceed no issues good data arrangement My requirement here is i need to read the file and check for the words "OK to Proceed" and if...

4. Shell Programming and Scripting

Reading data from file and assigning to variable

I was trying to store the number of lines in a file and store it in a file.after that i want to store the information in a file to a variable which is further used in the if loop to check certain condition. #!/bin/bash cat <file> | wc -l > count.txt x="$count.txt"; i=10; if ; then cat...

5. Shell Programming and Scripting

how to Read a file and assigning each line to a variable?

Friends, I have a file output.txt with values as below: 092307135717 061910135717 I want to know how to read this file and then assign each value to a variable. say like var1=092307135717 var2=061910135717 So that I can use this VAR1 and Var2 in the shell script for further processing....

6. Shell Programming and Scripting

Assigning a value as a variable from a text file

I have a txt file output.txt Freq = 1900 L = 159I want to assign the values to a variable so that i can further use it in some other script. like F=1900 Len=159 etc i tried doing something with awk but dosent work F=$(awk 'BEGIN {}/Freq/ {split ($2,a);depth=a};printf "%d\t,...

7. Shell Programming and Scripting

Bash: Reading a file and assigning variables from file

I have a file that has four values on each line and I'd like to give each column a variable name and then use those values in each step of a loop. In bash, I believe you could use a while loop to do this or possibly a cat command, but I am super new to programming and I'm having trouble decoding...

8. Shell Programming and Scripting

Reading from a file and assigning to an array in perl

I wrote a simply perl that searched a file for a particualr value and if it found it, rite it and the next three lines to a file. Now I have been asked to check those next three lines for a different value and only write those lines if it finds the second value. I was thinking the best way to...

9. Shell Programming and Scripting

assigning variable in txt file

Hi all, One of my txt file has common format like . And I need to manually assign variable to "/a/b/c/file1/txt" , which has common text before "Calculated summary file:". I wonder if I can use some command to do that for me, that it read the file and check for that comonn text and assign...

10. Shell Programming and Scripting

Assigning file to a variable

Hi, I have a list of files in a directory. Each file has a .txt and a .log extension i.e. file.txt & file.log, file1.txt & file1.log etc. The file with the .log extension may not always exist alongside the file with the .txt extension. I need to copy the .txt file if there is a corresponding...

LEARN ABOUT CENTOS

mysqldumpslow

MYSQLDUMPSLOW(1)					       MySQL Database System						  MYSQLDUMPSLOW(1)

NAME

       mysqldumpslow - Summarize slow query log files

SYNOPSIS

       mysqldumpslow [options] [log_file ...]

DESCRIPTION

       The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.2.5, "The Slow Query Log").
       mysqldumpslow parses MySQL slow query log files and prints a summary of their contents.

       Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. It "abstracts"
       these values to N and 'S' when displaying summary output. The -a and -n options can be used to modify value abstracting behavior.

       Invoke mysqldumpslow like this:

	   shell> mysqldumpslow [options] [log_file ...]

       mysqldumpslow supports the following options.

       o   --help

	   Display a help message and exit.

       o   -a

	   Do not abstract all numbers to N and strings to 'S'.

       o   --debug, -d

	   Run in debug mode.

       o   -g pattern

	   Consider only queries that match the (grep-style) pattern.

       o   -h host_name

	   Host name of MySQL server for *-slow.log file name. The value can contain a wildcare. The default is * (match all).

       o   -i name

	   Name of server instance (if using mysql.server startup script).

       o   -l

	   Do not subtract lock time from total time.

       o   -n N

	   Abstract numbers with at least N digits within names.

       o   -r

	   Reverse the sort order.

       o   -s sort_type

	   How to sort the output. The value of sort_type should be chosen from the following list:

	   o   t, at: Sort by query time or average query time

	   o   l, al: Sort by lock time or average lock time

	   o   s, as: Sort by rows sent or average rows sent

	   o   c: Sort by count

       o   -t N

	   Display only the first N queries in the output.

       o   --verbose, -v

	   Verbose mode. Print more information about what the program does.

       Example of usage:

	   shell> mysqldumpslow
	   Reading mysql slow query log from /usr/local/mysql/data/mysqld51-apple-slow.log
	   Count: 1  Time=4.32s (4s)  Lock=0.00s (0s)  Rows=0.0 (0), root[root]@localhost
	    insert into t2 select * from t1
	   Count: 3  Time=2.53s (7s)  Lock=0.00s (0s)  Rows=0.0 (0), root[root]@localhost
	    insert into t2 select * from t1 limit N
	   Count: 3  Time=2.13s (6s)  Lock=0.00s (0s)  Rows=0.0 (0), root[root]@localhost
	    insert into t1 select * from t1

COPYRIGHT

       Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Sun Microsystems, Inc. (http://www.mysql.com/).

MySQL 5.1							    04/06/2010							  MYSQLDUMPSLOW(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Reading from a file and assigning values

Discussion started by: ssuresh1999

2. UNIX for Dummies Questions & Answers

Assigning value in a text file to a variable

Discussion started by: mojoman

3. UNIX for Dummies Questions & Answers

Searching a text file and assigning it to a variable

Discussion started by: pssandeep

4. Shell Programming and Scripting

Reading data from file and assigning to variable

Discussion started by: sudhakaryadav