awk with two files Post: 302377234

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting input files into multiple files through AWK command

Hi, I needs to split *.txt files from single directory depends on the some mutltiple input values. i have wrote the code like below for file in *.txt do grep -i -h "value1|value2" $file > $file; done. My requirment is more input values needs to be given in grep; let us say 50...

2. Shell Programming and Scripting

Merge files of differrent size with one field common in both files using awk

hi, i am facing a problem in merging two files using awk, the problem is as stated below, file1: A|B|C|D|E|F|G|H|I|1 M|N|O|P|Q|R|S|T|U|2 AA|BB|CC|DD|EE|FF|GG|HH|II|1 .... .... .... file2 : 1|Mn|op|qr

3. UNIX for Dummies Questions & Answers

Using Awk within awk to read all files in directory

I am wondering if anyone has any idea how to use an awk within awk to read files and find a match which adds to count. Say I am searching how many times the word crap appears in each files within a directory. How would i do that from the command prompt ... thanks

4. Shell Programming and Scripting

Awk : too many files 10

Hi, I m trying to split the one file into small segments based on userid field.I m getting the error "AWK : too many output files 10 record number 71". Can any one help me to resolve this issue or provide me someother code? Please note that, I don't have root admin previlege. I m login...

5. Shell Programming and Scripting

Comparison and editing of files using awk.(And also a possible bug in awk for loop?)

I have two files which I would like to compare and then manipulate in a way. File1: pictures.txt 1.1 1.3 dance.txt 1.2 1.4 treehouse.txt 1.3 1.5 File2: pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244 dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2...

6. UNIX for Dummies Questions & Answers

Using AWK: Extract data from multiple files and output to multiple new files

Hi, I'd like to process multiple files. For example: file1.txt file2.txt file3.txt Each file contains several lines of data. I want to extract a piece of data and output it to a new file. file1.txt ----> newfile1.txt file2.txt ----> newfile2.txt file3.txt ----> newfile3.txt Here is...

7. Shell Programming and Scripting

Apply 'awk' to all files in a directory or individual files from a command line

Hi All, I am using the awk command to replace ',' by '\t' (tabs) in a csv file. I would like to apply this to all .csv files in a directory and create .txt files with the tabs. How would I do this in a script? I have the following script called "csvtabs": awk 'BEGIN { FS...

8. Shell Programming and Scripting

Comparing the matches in two files using awk when both files have their own field separators

I've two files with data like below: file1.txt: AAA,Apples,123 BBB,Bananas,124 CCC,Carrot,125 file2.txt: Store1|AAA|123|11 Store2|BBB|124|23 Store3|CCC|125|57 Store4|DDD|126|38 So,the field separator in file1.txt is a comma and in file2.txt,it is | Now,the output should be...

9. Shell Programming and Scripting

awk, multiple files input and multiple files output

Hi! I'm new in awk and I need some help. I have a folder with a lot of files and I need that awk do something in each file and print a new file with the output. The input file name should be modified when I print the outpu files. Thanks in advance for help! :-) ciao

10. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Hi, I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files. To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the...

LEARN ABOUT OPENSOLARIS

fmlgrep

fmlgrep(1F)							   FMLI Commands						       fmlgrep(1F)

NAME

       fmlgrep - search a file for a pattern

SYNOPSIS

       fmlgrep [-b] [-c] [-i] [-l] [-n] [-s] [-v]
	    limited_regular_expression [filename]...

DESCRIPTION

       fmlgrep	searches  filename for a pattern and prints all lines that contain that pattern. fmlgrep uses limited regular expressions (expres-
       sions that have string values that use a subset of the possible alphanumeric and special characters) like those described on the  regexp(5)
       manual page to match the patterns. It uses a compact non-deterministic algorithm.

       Be careful when using  FMLI special characters (for instance, $, `, ', ") in limited_regular_expression. It is safest to enclose the entire
       limited_regular_expression in single quotes ' ... '.

       If filename is not specified, fmlgrep assumes standard input. Normally, each line matched is copied to standard output. The  file  name	is
       printed before each line matched if there is more than one input file.

OPTIONS

       The following options are supported:

       -b    Precede  each line by the block number on which it was found. This can be useful in locating block numbers by context (first block is
	     0).

       -c    Print only a count of the lines that contain the pattern.

       -i    Ignore upper/lower case distinction during comparisons.

       -l    Print only the names of files with matching lines, separated by new-lines. Does not repeat the names of files  when  the  pattern	is
	     found more than once.

       -n    Precede each line by its line number in the file (first line is 1).

       -s    Suppress error messages about nonexistent or unreadable files.

       -v    Print all lines except those that contain the pattern.

EXIT STATUS

       The following exit values are returned:

       0    if the pattern is found (that is, TRUE)

       1    if the pattern is not found (that is, FALSE)

       2    if an invalid expression was used or filename is inaccessible

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       egrep(1), fgrep(1), fmlcut(1F), grep(1), attributes(5), regexp(5)

NOTES

       Lines are limited to  BUFSIZ characters; longer lines are truncated. BUFSIZ is defined in /usr/include/stdio.h.

       If there is a line with embedded nulls, fmlgrep will only match up to the first null; if it matches, it will print the entire line.

SunOS 5.11							    28 Mar 1995 						       fmlgrep(1F)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting input files into multiple files through AWK command

Discussion started by: arund_01

2. Shell Programming and Scripting

Merge files of differrent size with one field common in both files using awk

Discussion started by: shashi1982

3. UNIX for Dummies Questions & Answers

Using Awk within awk to read all files in directory

Discussion started by: flevongo

4. Shell Programming and Scripting

Awk : too many files 10

Discussion started by: prabuk1