Sponsored Content
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
inet(3SOCKET)															     inet(3SOCKET)

NAME
inet, inet6, inet_ntop, inet_pton, inet_addr, inet_network, inet_makeaddr, inet_lnaof, inet_netof, inet_ntoa - Internet address manipula- tion SYNOPSIS
cc [ flag ... ] file... -lsocket -lnsl [ library...] #include <sys/types.h> #include <sys/socket.h> #include <netinet/in.h> #include <arpa/inet.h> const char *inet_ntop(int af, const void *addr, char *cp, size_t size); int inet_pton(int af, const char *cp, void *addr); in_addr_t inet_addr(const char *cp); in_addr_t inet_network(const char *cp); struct in_addr inet_makeaddr(const int net, const int lna); int inet_lnaof(const struct in_addr in); int inet_netof(const struct in_addr in); char *inet_ntoa(const struct in_addr in); The inet_ntop() and inet_pton() functions can manipulate both IPv4 and IPv6 addresses. The inet_addr(), inet_network(), inet_makeaddr(), inet_lnaof(), inet_netof(), and inet_ntoa() functions can only manipulate IPv4 addresses. The inet_ntop() function converts a numeric address into a string suitable for presentation. The af argument specifies the family of the address which can be AF_INET or AF_INET6. The addr argument points to a buffer that holds an IPv4 address if the af argument is AF_INET. The addr argument points to a buffer that holds an IPv6 address if the af argument is AF_INET6. The address must be in network byte order. The cp argument points to a buffer where the function stores the resulting string. The application must specify a non-NULL cp argument. The size argument specifies the size of this buffer. For IPv6 addresses, the buffer must be at least 46-octets. For IPv4 addresses, the buffer must be at least 16-octets. To allow applications to easily declare buffers of the proper size to store IPv4 and IPv6 addresses in string form, the following two constants are defined in <netinet/in.h>: #define INET_ADDRSTRLEN 16 #define INET6_ADDRSTRLEN 46 The inet_pton() function converts the standard text presentation form of a function to the numeric binary form. The af argument specifies the family of the address. Currently, the AF_INET and AF_INET6 address families are supported. The cp argument points to the string being passed in. The addr argument points to a buffer where the function stores the numeric address. The calling application must ensure that the buffer referred to by addr is large enough to hold the numeric address, at least 4 bytes for AF_INET or 16 bytes for AF_INET6. The inet_addr() and inet_network() functions interpret character strings that represent numbers expressed in the IPv4 standard `.' nota- tion, returning numbers suitable for use as IPv4 addresses and IPv4 network numbers, respectively. The inet_makeaddr() function uses an IPv4 network number and a local network address to construct an IPv4 address. The inet_netof() and inet_lnaof() functions break apart IPv4 host addresses, then return the network number and local network address, respectively. The inet_ntoa() function returns a pointer to a string in the base 256 notation d.d.d.d. See the following section on IPv4 addresses. Internet addresses are returned in network order, bytes ordered from left to right. Network numbers and local address parts are returned as machine format integer values. IPv6 Addresses There are three conventional forms for representing IPv6 addresses as strings: 1. The preferred form is x:x:x:x:x:x:x:x, where the 'x's are the hexadecimal values of the eight 16-bit pieces of the address. For exam- ple: 1080:0:0:0:8:800:200C:417A It is not necessary to write the leading zeros in an individual field. There must be at least one numeral in every field, except when the special syntax described in the following is used. 2. It is common for addresses to contain long strings of zero bits in some methods used to allocate certain IPv6 address styles. A special syntax is available to compress the zeros. The use of "::" indicates multiple groups of 16 bits of zeros. The :: may only appear once in an address. The :: can also be used to compress the leading and trailing zeros in an address. For example: 1080::8:800:200C:417A 3. The alternative form x:x:x:x:x:x:d.d.d.d is sometimes more convenient when dealing with a mixed environment of IPv4 and IPv6 nodes. The x's in this form represent the hexadecimal values of the six high-order 16-bit pieces of the address. The d's represent the decimal values of the four low-order 8-bit pieces of the standard IPv4 address. For example: ::FFFF:129.144.52.38 ::129.144.52.38 The ::FFFF:d.d.d.d and ::d.d.d.d pieces are the general forms of an IPv4-mapped IPv6 address and an IPv4-compatible IPv6 address. The IPv4 portion must be in the d.d.d.d form. The following forms are invalid: ::FFFF:d.d.d ::FFFF:d.d ::d.d.d ::d.d The ::FFFF:d form is a valid but unconventional representation of the IPv4-compatible IPv6 address ::255.255.0.d. The ::d form corresponds to the general IPv6 address 0:0:0:0:0:0:0:d. IPv4 Addresses Values specified using `.' notation take one of the following forms: d.d.d.d d.d.d d.d d When four parts are specified, each part is interpreted as a byte of data and assigned from left to right to the four bytes of an IPv4 address. When a three-part address is specified, the last part is interpreted as a 16-bit quantity and placed in the right most two bytes of the network address. The three part address format is convenient for specifying Class B network addresses such as 128.net.host. When a two-part address is supplied, the last part is interpreted as a 24-bit quantity and placed in the right most three bytes of the net- work address. The two part address format is convenient for specifying Class A network addresses such as net.host. When only one part is given, the value is stored directly in the network address without any byte rearrangement. With the exception of inet_pton(), numbers supplied as parts in '.' notation may be decimal, octal, or hexadecimal, as specified in C lan- guage. For example, a leading 0x or 0X implies hexadecimal. A leading 0 implies octal. Otherwise, the number is interpreted as decimal. For IPv4 addresses, inet_pton() accepts only a string in standard IPv4 dot notation: d.d.d.d Each number has one to three digits with a decimal value between 0 and 255. The inet_ntop() function returns a pointer to the buffer that contains a string if the conversion succeeds. Otherwise, NULL is returned. Upon failure, errno is set to EAFNOSUPPORT if the af argument is invalid or ENOSPC if the size of the result buffer is inadequate. The inet_pton() function returns 1 if the conversion succeeds, 0 if the input is not a valid IPv4 dotted-decimal string or a valid IPv6 address string. The function returns -1 with errno set to EAFNOSUPPORT if the af argument is unknown. The value (in_addr_t)(-1) is returned by inet_addr() and inet_network() for malformed requests. The functions inet_netof() and inet_lnaof() break apart IPv4 host addresses, returning the network number and local network address part, respectively. The function inet_ntoa() returns a pointer to a string in the base 256 notation d.d.d.d, described in the section on IPv4 addresses. See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |MT-Level |Safe | +-----------------------------+-----------------------------+ gethostbyname(3NSL), getipnodebyname(3SOCKET), getnetbyname(3SOCKET), inet.h(3HEAD), hosts(4), ipnodes(4), networks(4), attributes(5) The return value from inet_ntoa() points to a buffer which is overwritten on each call. This buffer is implemented as thread-specific data in multithreaded applications. The problem of host byte ordering versus network byte ordering is confusing. A simple way to specify Class C network addresses in a manner similar to that for Class B and Class A is needed. 28 Jan 2005 inet(3SOCKET)
All times are GMT -4. The time now is 06:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy