Searching for similar row(s) across multiple files

10 More Discussions You Might Find Interesting

1. BSD

Searching in multiple files

I am new to unix and I would like to search multiple log files to find earliest occurrence of a text. Ex: Say I have 10 logs file each ending with .log and I want to find the text “CustomeError” . I want to find the which log file “CustomeError” comes first and lines which surround’s ...

2. Shell Programming and Scripting

Help on searching for a string on multiple files

Hi all, I am sure some gurus will find a better way of doing this. FYI, I've manually modified some of the data 'coz they are somewhat confidential, so there may be some typo errors. At the moment, I have 3 files that I am trying to search for. Sometime in the future, it may go beyond 3...

3. UNIX for Dummies Questions & Answers

Grep in Perl - Searching through multiple files

I'm attempting to use grep in Perl with very little success. What I would like to do in Perl is get the output of the following grep code: grep -l 'pattern' * This gives me a list of all the files in a directory that contain the pattern that was searched. My attempts to do this in Perl...

4. Shell Programming and Scripting

Help converting column to row for multiple files

Hi all, I am pretty new at this so be gentle. Also, if there is any chance you could explain what the code you use is actually doing, that would really help me out, Im learning after all :) So I am trying to convert a selected column of numbers from input file1 into a row in output file2 ...

5. Shell Programming and Scripting

Joining multiple files based on one column with different and similar values (shell or perl)

Hi, I have nine files looking similar to file1 & file2 below. File1: 1 ABCA1 1 ABCC8 1 ABR:N 1 ACACB 1 ACAP2 1 ACOT1 1 ACSBG 1 ACTR1 1 ACTRT 1 ADAMT 1 AEN:N 1 AKAP1File2: 1 A4GAL 1 ACTBL 1 ACTL7

6. Shell Programming and Scripting

Searching across multiple files if pattern is available in all files searched

I have a list of pattern in a file, I want each of these pattern been searched from 4 files. I was wondering this can be done in SED / AWK. say my 4 files to be searched are > cat f1 abc/x(12) 1 abc/x 3 cde 2 zzz 3 fdf 4 > cat f2 fdf 4 cde 3 abc 2...

7. Shell Programming and Scripting

Searching a word in multiple files

Hi All, I have a issue in pulling some heavy records , I have my input file has 10,000 records which i need to compare with daily appended log files from (sep 1st 2009 to till date) . I tried to use grep fgrep and even sed , but the as time is factor for me , i cannot wait for 5 days to get the...

8. Shell Programming and Scripting

Searching for multiple patterns in files

I have a situation where I need to search for multiple strings (error messages) such as 'aborted' 'file not found' etc in directory having logs. I have put all the error messages in a text file and using the command. grep -f <textfile> <filetobegrepped> I'm doing this thru a script where I...

9. Shell Programming and Scripting

Searching for multiple criteria in log files?

I would like a simple shell script that will allow me to display to screen all unsuccessful su attempts in my sulog file, for the present date. I have been trying several different combinations of commands, but I can't quite get the syntax correct. The mess I have right now (don't laugh) is...

10. Shell Programming and Scripting

Searching multiple files with multiple expressions

I am using a DEC ALPHA running Digital UNIX (formly DEC OSF/1) and ksh. I have a directory with hundreds of files that only share the extension .rpt. I would like to search that directory based on serial number and operation number and only files that meet both requirements to be printed out. I...

LEARN ABOUT PHP

mysqli_fetch_all

MYSQLI_FETCH_ALL(3)							 1						       MYSQLI_FETCH_ALL(3)

mysqli_result::fetch_all - Fetches all result rows as an associative array, a numeric array, or both

       Object oriented style

SYNOPSIS

       mixed mysqli_result::fetch_all ([int  $resulttype = MYSQLI_NUM])

DESCRIPTION

       Procedural style
       mixed mysqli_fetch_all (mysqli_result  $result, [int  $resulttype = MYSQLI_NUM])

       mysqli_fetch_all(3) fetches all result rows and returns the result set as an associative array, a numeric array, or both.

PARAMETERS

	      o $
		result	 -Procedural   style   only:   A   result   set   identifier   returned   by  mysqli_query(3),	mysqli_store_result(3)	or
		mysqli_use_result(3).

	      o $resulttype
		- This optional parameter is a constant indicating what type of array should be produced from the current row data.  The  possible
		values for this parameter are the constants MYSQLI_ASSOC, MYSQLI_NUM, or MYSQLI_BOTH.

RETURN VALUES

	Returns an array of associative or numeric arrays holding result rows.

MYSQL NATIVE DRIVER ONLY

	Available only with mysqlnd.

	As  mysqli_fetch_all(3)  returns all the rows as an array in a single step, it may consume more memory than some similar functions such as
       mysqli_fetch_array(3), which only returns one row at a time from the result set. Further, if you need to iterate over the result  set,  you
       will need a looping construct that will further impact performance. For these reasons mysqli_fetch_all(3) should only be used in those sit-
       uations where the fetched result set will be sent to another layer for processing.

SEE ALSO

       mysqli_fetch_array(3), mysqli_query(3).

PHP Documentation Group 												       MYSQLI_FETCH_ALL(3)

Shell Programming and Scripting