Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to read a two files, line by line in UNIX script and how to assign shell variable to awk ..?
Top Forums Shell Programming and Scripting How to read a two files, line by line in UNIX script and how to assign shell variable to awk ..? Post 302880973 by veeruasu on Wednesday 25th of December 2013 10:29:07 AM
Old 12-25-2013
How to read a two files, line by line in UNIX script and how to assign shell variable to awk ..?
Input are file and file1

file contains
Code:
store.bal
product.bal
category.bal
admin.bal

file1 contains
Code:
flip.store.bal ::FFFF:BADC:CD28,::FFFF:558E:11C5,6,8,2,1,::FFFF:81C8:CA8B,::FFFF:BADC:CD28,1,0,0,0,::FFFF:81C8:11C5,2,1,0,0,::FFFF:81DC:3111,1,0,1,0
store.bal. ::FFFF:F9CC:C5B9,::FFFF:356F:73C3,4,8,7,6,::FFFF:93CC:C9CF,::FFFF:F9CC:C5B9,1,0,0,0,::FFFF:93CC:73C3,2,1,0,0,::FFFF:93CC:3371,1,0,1,0
es.product.bal. ::FFFF:F9CC:C5B9,::FFFF:356F:73C3,4,8,7,6,::FFFF:93CC:C9CF,::FFFF:F9CC:C5B9,1,0,0,0,::FFFF:93CC:73C3,2,1,0,0,::FFFF:93CC:3371,1,0,1,0
many.category.bal. ::FFFF:F9CC:C5B9,::FFFF:356F:73C3,4,8,7,6,::FFFF:93CC:C9CF,::FFFF:F9CC:C5B9,1,0,0,0,::FFFF:93CC:73C3,2,1,0,0,::FFFF:93CC:3371,1,0,1,0
comp.admin.bal. ::FFFF:732B:649F,::FFFF:23EB:6EB2,2,3,8,7,::FFFF:FE66:6367,::FFFF:732B:649F,1,0,0,0,::FFFF:FE66:6EB2,2,1,0,0,::FFFF:FE2B:FE61,1,0,1,0
admin.bal. ::FFFF:FB85:A1BE,::FFFF:BC64:B35B,9,1,5,9,::FFFF:E3A2:AB2F,::FFFF:FB85:A1BE,1,0,0,0,::FFFF:E3A2:B35B,2,1,0,0,::FFFF:E385:13B1,1,0,1,0

output
Code:
store.bal|8|54
product.bal|4|31
category.bal|4|31
admin.bal|8|56

in above code insted of each field replace with file ... presently code is reading only one filed for ex: store.bal
Code:
cat file1|awk '{split($1,dp,"."); lend=length(dp); if(lend>2) { dom=dp[lend-2]"."dp[lend-1]; 
split($2,ipl,","); for(i=1; i<=length(ipl); i++) 
{ if(ipl[i]~/:/) { 
if(ipl[i+1]~/:/) i++; rip=ipl[i]; i++; raq=ipl[i]; rtq=0; si=i+4; 
for(;i<si;i++) rtq+=ipl[i]; rsub=""; r32ip=""; 
if(rip ~ /^::FFFF:/) { r32ip=rip; rsub=substr(rip,8,7);
 } 
print tolower(dom)"|"rip"|"r32ip"|"rsub"|"raq"|"rtq; i--}} }
 }' |awk -F "|" '{if($1=="store.bal" && $4 != "") { cnt[$4]=1; cnt2[$3]++; qc+=$6; }}
................

if($1=="store.bal" && $4 != "") { cnt[$4]=1; cnt2[$3]++; qc+=$6; }} in this line, instead of store.bal ,need to call file having all 4 data i.e store.bal,procut.bal,caterogy.bal and admin.bal

Last edited by Scott; 12-25-2013 at 02:19 PM.. Reason: Use code tags, please...
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

shell script to read file line by line

Hi, I need to read a text file from shell script line by line and copy the feilds of each line. Below is the complete requirement. I've text file which contains ... pgm1 file11 file12 file13 pgm2 file21 file22 pgm3 file31 file32 file33 I'll give input as... (4 Replies)
Discussion started by: ani12345
4 Replies

2. Shell Programming and Scripting

assign awk's variable to shell script's variable?

Dear All, we have a command output which looks like : Total 200 queues in 30000 Kbytes and we're going to get "200" and "30000" for further process. currently, i'm using : numA=echo $OUTPUT | awk '{print $2}' numB=echo $OUTPUT | awk '{print $5}' my question is : can I use just one... (4 Replies)
Discussion started by: tiger2000
4 Replies

3. Shell Programming and Scripting

how can u read a file line by line in shell script ?

hello , plz help for below script req:- how can we read a file line by line in shell script ? (4 Replies)
Discussion started by: abhigrkist
4 Replies

4. Shell Programming and Scripting

Shell script to read a text file line by line & process it...

Hi , I am trying to write an shell, which reads a text file (from a location) having a list of numbers of strictly 5 digits only ex: 33144 Now my script will check : 1) that each entry is only 5 digits & numeric only, no alphabets, & its not empty. 2)then it executes a shell script called... (8 Replies)
Discussion started by: new_to_shell
8 Replies

5. Shell Programming and Scripting

Shell script to read multiple options from file, line by line

Hi all I have spent half a day trying to create a shell script which reads a configuration file on a line by line basis. The idea of the file is that each will contain server information, such as IP address and various port numbers. The line could also be blank (The file is user created). Here... (1 Reply)
Discussion started by: haggismn
1 Replies

6. Shell Programming and Scripting

HELP: Shell Script to read a Log file line by line and extract Info based on KEYWORDS matching

I have a LOG file which looks like this Import started at: Mon Jul 23 02:13:01 EDT 2012 Initialization completed in 2.146 seconds. -------------------------------------------------------------------------------- -- Import summary for Import item: PolicyInformation... (8 Replies)
Discussion started by: biztank
8 Replies

7. Shell Programming and Scripting

How to read a file, line by line in UNIX script?

#!/bin/bash file1="yxd" for file in `cat file3.txt`; do cat $file1 | awk '{split($1,dp,"."); lend=length(dp); if(lend>2) { dom=dp"."dp; split($2,ipl,","); for(i=1; i<=length(ipl); i++) { if(ipl~/:/) { if(ipl~/:/) i++; rip=ipl; i++; raq=ipl; rtq=0; si=i+4; for(;i<si;i++) rtq+=ipl; rsub="";... (2 Replies)
Discussion started by: veeruasu
2 Replies

8. Shell Programming and Scripting

Do While Loop + Read From File + assign line to a variable

Hello, I am using below code for reading from a file and assigning the values to a variable , but it is loosing the value after the loop , please suggest to retain the value of the variable after the loop , while IFS=: read -r line do set $dsc=$line echo 'printing line variable ' $line... (1 Reply)
Discussion started by: ParthThakkar
1 Replies

9. Shell Programming and Scripting

Shell script UNIX to read text file line by line

i have a text file as belows, it includes 2 columns, 1st is the column name, 2nd is the file_name data_file.txt column_name file_name col1 file1 col2 file2 col3 file1 col4 file1 col5 file2 now, i would like to... (4 Replies)
Discussion started by: tester111
4 Replies

10. UNIX for Beginners Questions & Answers

How can I assign awk's variable to shell script's variable?

I have the following script, and I want to assign the output ($10 and $5) from awk to N and L: grdinfo data.grd | awk '{print $10,$5}'| read N L output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use... (8 Replies)
Discussion started by: geomarine
8 Replies

LEARN ABOUT REDHAT

wavelan_cs

WAVELAN_CS(4)						     Kernel Interfaces Manual						     WAVELAN_CS(4)

NAME

       wavelan_cs - AT&T GIS WaveLAN PCMCIA device driver

SYNOPSIS

       insmod wavelan_cs.o [irq_list=i,j,...]  [mem_speed=n] [do_roaming=n]

DESCRIPTION

       wavelan_cs  is the low-level Card Services driver for the NCR / AT&T / Lucent WaveLAN PCMCIA and Digital (DEC) RoamAbout DS wireless ether-
       net adapter.  When this driver is attached to a card, it allocates the next available ethernet device (eth0..eth#).  This device name  will
       be passed on to cardmgr(8) for the card configuration, and reported in the kernel log file with the MAC address, NWID and frequency used by
       the card.

PARAMETERS

       irq_list=i,j,...
	      Specifies the set of interrupts that may be allocated by this driver.

       mem_speed=n
	      Sets the access speed of the shared memory window, in nanoseconds.  The default is 0 (i.e., no extra wait states).

       do_roaming=n
	      Enables or disables roaming mode.  The default is 1 (roam).

WIRELESS EXTENSIONS

       Use iwconfig(8) to manipulate wireless extensions.

   Mode
       Set the operating mode to Ad-Hoc or Managed.  This in fact disable or enable roaming support. This setting is not saved in hardware.

   Network ID
       Set the network ID [0 to FFFF] or disable it [off] or reenable it [on].	As the NWID is stored in the card Permanent Storage Area, it  will
       be reuse at any further invocation of the driver.

   Frequency & channels
       For  the 2.4GHz 2.00 Hardware, you are able to set the frequency by specifying one of the 10 defined channels (2.412, 2.422, 2.425, 2.4305,
       2.432, 2.442, 2.452, 2.460, 2.462 or 2.484) or directly by its value. The frequency is  changed	immediately  and  permanentely.  Frequency
       availability depend on the regulations...

   Sensitivity
       Signal level threshold for packet reception [0 to 63].  Should be set according to the ambiant noise level.

   Encryption key
       Set  the encryption key [0 to FFFF-FFFF-FFFF-FFFF].  Use [off] and [on] to disable and reenable the hardware encryption. This feature works
       only for device with encryption option (DES or AES).

   Statistics spy
       Set a list of MAC addresses in the driver (up to 8) and get the last quality of link for each of those (see iwspy(8)).

   /proc/net/wireless
       status is the status reported by the modem.  Link quality reports the quality of the modulation on the air (direct  sequence  spread  spec-
       trum)  [max  =  16].   Level and Noise refer to the signal level and noise level [max = 64].  The crypt discarded packet and misc discarded
       packet counters are not implemented.

PRIVATE IOCTL

       You may use iwpriv(8) to manipulate private ioctls.

   Quality threshold
       Enable you the define the quality threshold used by the modem (packet below that level are discarded).

   Histogram
       This functionality allow to set a number of signal level intervals and to count the number of packets received in  each	of  those  defined
       intervals. This distribution might be used to calculate the mean value and standard deviation of the signal level.

OTHER FEATURES

       Hot unplug support.
       Power saving (use 'ifconfig down').

SPECIFIC NOTES

       This  driver  will  fail to load some non NCR/ATT&T/Lucent Wavelan cards. If it's your case, you must look in the source code on how to add
       your card to the detection routine.

       Some of the mentioned features are optional. You may enable to disable them by changing flags in the driver header and recompile.

AUTHOR

       Anthony D. Joseph - adj@lcs.mit.edu
       Jean Tourrilhes - jt@hplb.hpl.hp.com
       (+ others - see source code for details)

SEE ALSO

       wavelan(4), cardmgr(8), pcmcia(5), ifconfig(8), insmod(1), iwconfig(8), iwspy(8), iwpriv(8).

MIT Lab. for Comp. Sci. 					      4/16/95							     WAVELAN_CS(4)
All times are GMT -4. The time now is 03:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy