Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Read a file and search a value in another file create third file using AWK
Top Forums Shell Programming and Scripting Read a file and search a value in another file create third file using AWK Post 302326359 by King Kalyan on Wednesday 17th of June 2009 06:17:55 PM
Old 06-17-2009
MySQL
Perfect!! Thanks a lot!!!
It works great!! I never thought it in that angle.

I added one more part, please check and let me know if I did it right.
If there is no match for a value in file 2 then I need to take first 11 digits from any value and append zeros to it and output the record.

It was working fine before but now it's not working not sure where I went wrong.

Addition:

FNR==NR{f1[$1]=($1 in f1)? f1[$1] SUBSEP $2 : $2;next}
$3 in f1 {
n=split(f1[$3], a, SUBSEP)
delete f1[$3]
printf("%s<RESULT>%s\n", $0, a[1])
for(i=2;i<=n;i++)
f1[$3]=(i==2)?a[i]:f1[$3] SUBSEP a[i] ; next}
for ( temp in f1) {
tmp_value=substr(f1[temp],1,11)
print $0 "<RESULT>" tmp_value "000000000"
}
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read words from file and create new file using K-shell.

Hi All, Please help me in creating files through K-shell scripts. I am having one file in this format. OWNER.TABLE_NAME OWNER.TABLE_NAME1 OWNER1.TABLE_NAME OWNER1.TABLE_NAME1 I want to read the above file and create new file through k shell script. The new file should looks like this.... (4 Replies)
Discussion started by: bsrajirs
4 Replies

2. Shell Programming and Scripting

Need help with awk - how to read a content of a file from every file from file list

Hi Experts. I need to list the file and the filename comes from the file ListOfFile.txt. Basicly I have a filename "ListOfFile.txt" and it contain Example of ListOfFile.txt /home/Dave/Program/Tran1.P /home/Dave/Program/Tran2.P /home/Dave/Program/Tran3.P /home/Dave/Program/Tran4.P... (7 Replies)
Discussion started by: tanit
7 Replies

3. Shell Programming and Scripting

Select some lines from a txt file and create a new file with awk

Hi there, I have a text file with several colums separated by "|;#" I need to search the file extracting all columns starting with the value of "1" or "2" saving in a separate file just the first 7 columns of each row maching the criteria, with replacement of the saparators in the nearly created... (4 Replies)
Discussion started by: capnino
4 Replies

4. Shell Programming and Scripting

Want to read data from a file name.txt and search it in another file and then matching...

Hi Frnds... I have an input file name.txt and another file named as source.. name.txt is having only one column and source is having around 25 columns...i need to read from name.txt line by line and search it in source file and then save the result in results file.. I have a rough idea about the... (15 Replies)
Discussion started by: ektubbe
15 Replies

5. Shell Programming and Scripting

awk read one delimited file, search another delimited file

Hello folks, I have another doozy. I have two files. The first file has four fields in it. These four fields map to different locations in my second file. What I want to do is read the master file (file 2 - 23 fields) and compare each line against each record in file 1. If I get a match in all four... (4 Replies)
Discussion started by: dagamier
4 Replies

6. Shell Programming and Scripting

Using awk to read one file and search in another file

Hi Forum. I did some google search on what I'm trying to do but I cannot get my code to work correctly. I have 2 files which are very large and I want to read text from file1 and search in file2 - if present, keep the records. I've tried fgrep -f file1 file2 but it is too slow. File1:... (10 Replies)
Discussion started by: pchang
10 Replies

7. Shell Programming and Scripting

Bash to search file based off user input then create new file

In the below bash a file is downloaded when the program is opened and then that file is searched based on user input and the result is written to a new file. For example, the bash is opened and the download.txt is downloaded, the user then enters the id (NA04520). The id is used to search... (5 Replies)
Discussion started by: cmccabe
5 Replies

8. Shell Programming and Scripting

Read in search strings from text file, search for string in second text file and output to CSV

Hi guys, I have a text file named file1.txt that is formatted like this: 001 , ID , 20000 002 , Name , Brandon 003 , Phone_Number , 616-234-1999 004 , SSNumber , 234-23-234 005 , Model , Toyota 007 , Engine ,V8 008 , GPS , OFF and I have file2.txt formatted like this: ... (2 Replies)
Discussion started by: An0mander
2 Replies

9. Shell Programming and Scripting

Use while loop to read file and use ${file} for both filename input into awk and as string to print

I have files named with different prefixes. From each I want to extract the first line containing a specific string, and then print that line along with the prefix. I've tried to do this with a while loop, but instead of printing the prefix I print the first line of the file twice. Files:... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

10. Shell Programming and Scripting

Splitting a text file into smaller files with awk, how to create a different name for each new file

Hello, I have some large text files that look like, putrescine Mrv1583 01041713302D 6 5 0 0 0 0 999 V2000 2.0928 -0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0 5.6650 0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0 3.5217 ... (3 Replies)
Discussion started by: LMHmedchem
3 Replies

LEARN ABOUT HPUX

rcsdiff

rcsdiff(1)						      General Commands Manual							rcsdiff(1)

NAME

       rcsdiff - compareRCS revisions

SYNOPSIS

       rev1] rev2] file ...

DESCRIPTION

       compares two revisions of each given RCS file and creates output very similar to (see diff(1)).	A file name ending in is an RCS file name,
       otherwise it is a working file name.  derives the working file name from the RCS file name and vice versa,  as  explained  in  rcsintro(5).
       Pairs consisting of both an RCS and a working file name can also be specified.

       recognizes the following options:

	      Same as described in
		    diff(1);

	      Same as described in
		    diff(1);

	      Same as described in
		    diff(1);

	      Same as described in
		    diff(1);

	      Generate an edit script of the format used by
		    RCS.

	      Generate a diff with lines of context.
		    The default is to present 3 lines of context.  To change, specify n; for example, gives 10 lines of context.

		    modifies  the output format slightly from the normal diff(1) output.  The ``context'' output begins with identification of the
		    files involved and their creation dates, then each change is separated by a line with a dozen (asterisks).	Lines removed from
		    file1  are	marked	with  (dashes); those added to file2 with (pluses).  Lines that are changed from one file to the other are
		    marked in both files with (exclamation marks).

       If both rev1 and rev2 are omitted, compares the latest revision on the trunk with the contents of the corresponding working file.  This	is
       useful for determining what was changed since the last check-in.

       If rev1 is given, but rev2 is omitted, compares revision rev1 of the RCS file with the contents of the corresponding working file.

       If both rev1 and rev2 are given, compares revisions rev1 and rev2 of the RCS file.

       Both rev1 and rev2 can be given numerically or symbolically.

EXAMPLES

       Compare the latest trunk revision of RCS file and the contents of working file

       Compare the revisions 1.1 and 1.2 in the RCS file

AUTHOR

       was developed by Walter F. Tichy.

SEE ALSO

       ci(1), co(1), diff(1), ident(1), rcs(1), rcsmerge(1), rlog(1), rcsfile(4), rcsintro(5).

																	rcsdiff(1)
All times are GMT -4. The time now is 03:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy