Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: AWK using two input files
Top Forums Shell Programming and Scripting AWK using two input files Post 302519412 by Ajoy on Wednesday 4th of May 2011 12:35:09 AM
Old 05-04-2011
AWK using two input files
Hi ,
i have two input files one is input.gz and another is ( input.txt) text file.in gz format input file each record contains 10 fields and corresponding header value is present in the text file as a single record i.e text file contains only 10 records which is header value,so output of the awk command should contain print field value from first field value from gz file and header value from text file,like that every field value should be associated with its field column name from the text file.
Code:
gzcat input.gz|tail -3
aaa,bbb,ccc,ddd,eee,fff,ggg,hhh,jjj,eee
aaa,8888,ccc,ddd,555,fff,ggg,333,jjj,eee
222,8888,aaa,bbb,555,888,ggg,333,jjj,hai

cat input.txt
Code:
name
designation
DOB
place
address1
address2
address3
phoneno
emailid
mobileno

I tried with the following command ,i am unable to achieve it.
Code:
gzcat  input.gz|nawk -F"," '{for (i=1;i<=NF;i++) print "field no",i,"file value",$i,system("sed -n {$i}p input.txt")}'

Can someone guide me in getting the output.
Last edited by Franklin52; 05-04-2011 at 03:26 AM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

2 input files for awk

Hi, i have 2 files like f1 and f2 f1: 1 Note: some times it will be cahnged to 2 and 3. f2: 1:20 2:30 4:50 6:70 8:90 3:20 1:30 1:40 output: 1:80 (sum of 1) (6 Replies)
Discussion started by: koti_rama
6 Replies

2. Shell Programming and Scripting

awk reading 2 input files but not getting expected value

I'm reading 2 input files but not getting expected value. I should get an alpha value on file_1_data but not getting any. Please help. >cat test6.sh awk ' FILENAME==ARGV { file_1_data=$0; print "----- 1 Line " NR " -----" $1; next } FILENAME==ARGV { file_2_data=$0; print "----- 2... (1 Reply)
Discussion started by: pdtak
1 Replies

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

4. Shell Programming and Scripting

awk read input files

hi, i'm a beginner in writing awk scripts and I have a problem with reading input files. Requirement for my programm: compare file1 to file2 and check if value in column1 is equal and value in column5 is different. File 1: 180 P 01.01.2008 30.06.2008 2 180 P 01.07.2008 ... (10 Replies)
Discussion started by: tgooper
10 Replies

5. Shell Programming and Scripting

Comparing 2 input files -Awk

Compare 2 files and print the values input1 (c1 20 100 X_y10) along with one closest highest (c1 100 200 X_y10) and one lowest values (c1 10 15 X_y10) from input2 input1 c1 20 100 X_y10 input2 c1 5 10 X_y10 c1 10 15 X_y10 c1 100 200 X_y10 c1 200 300 X_y10 output ... (8 Replies)
Discussion started by: bumblebee_2010
8 Replies

6. Shell Programming and Scripting

Help with reading two input files in awk

Hello, I'm trying to write an awk program that reads two files inputs. example, file 1: 0.00017835 0.000176738 0.00018811 0.000189504 0.000188155 0.000180065 0.000178991 0.000178252 0.000182513 file 2: 1.7871769E-05 1.5139576E-16 1.5140196E-16 1.5139874E-16 1.7827407E-04 ... (5 Replies)
Discussion started by: joseamck
5 Replies

7. UNIX Desktop Questions & Answers

awk using 2 input files instead of while loops

Hi Friends, I have two files as input with data that looks like this: file1.txt 1 2 3 4 file2.txt a,aa b,bb c,cc d,dd e,ee f,ff instead of me doing 2 while loops to get the combinations while read line_file1 (2 Replies)
Discussion started by: kokoro
2 Replies

8. Shell Programming and Scripting

FOR loop with multiple files as input and awk

Hi all , i want to pass multiple files as input to a for loop for i in file1 file2 file3 do some awk action < $i >> $i.out done but im getting error in that for loop is the way i use to pass files to awk using for correct and 2.we can directly pass multiple files to awk as... (7 Replies)
Discussion started by: zozoo
7 Replies

9. Shell Programming and Scripting

Awk: Replacement using 2 diff files input and comparison

Requirement: If $5(date field) in ipfile is less than $7(date field) in deact file & $1 of ipfile is present in deactfile then $1 to be replaced by $2,$3,$4,$5,$6 of deact file else if $5(date field) in ipfile is greater than $7(date field) in actfile & $1 of ipfile is present in actfile then... (5 Replies)
Discussion started by: siramitsharma
5 Replies

10. Shell Programming and Scripting

Parse input of two files to be the same in awk

I have two files that I am going to use diff to find the differences but need to parse them before I do that. I have include the format of each file1 and file2 with the desired output of each (the first 5 fields in each file). The first file has a "chr" before the # that needs to be removed. I... (1 Reply)
Discussion started by: cmccabe
1 Replies

LEARN ABOUT DEBIAN

sylseg-sk

sylseg-sk(1)							   USER COMMANDS						      sylseg-sk(1)

NAME

       sylseg-sk - segments a Slovak words in to the sylables

SYNOPSIS

       sylseg-sk [--best] [--color] [--dl debug level] [--help] [--ofile <file_name>] [<input_file>]

DESCRIPTION

       The sylabic segmentation is esential for some linguistic or speech recognition applications. Depending on the language either rule based or
       statistical approach is beying used. For Slovak the statistical approach seems to be more suitable.

       sylseg-sk implements one of the statistical approaches for the syllabic segmentaion. Each input word is segmented into the syllables.   The
       several	possible  segmentations are generated and sorted by the likelihood. If no input file is specified, the standard input is expected.
       If input file is used then the output is written in to the file as well. The filename is input filename with the extension ".syllables".

       The input output code page is ISO 8859-2. To use it with different CP use some CP convertor and pipes. For example to have input and output
       in  UTF-8 use (for interactive use): filterm UTF8-iso2 iso2-UTF8 sylseg-sk or (for batch processing) iconv -f UTF-8 -t ISO_8859-2 | sylseg-
       sk | iconv -f ISO_8859-2 -t UTF-8

       Performance of the syllabic segmentation depend on the used statistics.	To improve the quality of the segmentaion is possible to train the
       better system with the sylseg-sk-training tool and replace the original file located in /usr/share/sylseg_sk/sylseg-sk.stats

       The design of the sylseg-sk is language independent. With retrained statistics it theoreticaly should work for any language.

OPTIONS

       --best Print the best result only.

       --color
	      Enable color output.

       --dl 1..5
	      Set  the	debug  level. Control the amount of displayed information The debug level 0 displays nothing. The maximum level 5 displays
	      full debugging report. The default debug level is 1.

       --help display a short help text

       --ofile <file_name>
	      Write output also in to given file.

EXAMPLES

       Use standard input and debug level 3:
	      sylseg-sk --dl 3

       Process all the from file aaa.txt and print just the best segmentation:
	      sylseg-sk --best aaa.txt

EXIT STATUS

       sylseg-sk returns a zero if it succeeds to process all the input words

AUTHOR

       Jozef Ivanecky (dodo (at) kanoistika.sk)

SEE ALSO

       sylseg-sk-training(1), filterm(1), iconv(1), konwert(1)

version 0.5							 December 1, 2006						      sylseg-sk(1)
All times are GMT -4. The time now is 10:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy