Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Match and retrieve information from file
Top Forums Shell Programming and Scripting Match and retrieve information from file Post 302944282 by subrkann on Monday 18th of May 2015 12:07:50 PM
Old 05-18-2015
Check this following code:

Code:
# cat MergeInfo.sh
#!/bin/ksh

[[ $# -ne 2 ]] && {
        echo "Usage:  $0 <File1> <File2>" 1>&2
        exit 1;
}

[ -e $1 ] || {
        echo "$1 does not exists!!!!!." 1>&2
        exit 1;
}

[ -e $2 ] || {
        echo "$2 does not exists!!!!!." 1>&2
        exit 1;
}

awk '{ if (( NF != "4" )) { print FILENAME " - Incorrect file format!!!!!."; exit 1; } }' $1

[[ `echo $?` -ne "0" ]] && {
        exit 1;
}

awk '{ if (( NF != "3" )) { print FILENAME " - Incorrect file format!!!!!."; exit 1; } }' $2

[[ `echo $?` -ne "0" ]] && {
        exit 1;
}

cat $1 | while read COLUMN1 COLUMN2 COLUMN3 COLUMN4;
do
        CODE=`grep -w ${COLUMN2} File2 | grep -w ${COLUMN3} | awk '{print $NF}'`;
        echo "${COLUMN1}  ${COLUMN2} ${COLUMN3}  ${COLUMN4}  ${CODE}";
done

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

A script pls( To retrieve database information)

KSH - Unix -AIX - db2 ************** Get the input from the user say '123' (It varies) Then i want to connect to a database say "D1" then i want th extract from the database by giving "select * from tablename where input = '123' I also want to connect to another database "D2" then i... (3 Replies)
Discussion started by: rollthecoin
3 Replies

2. Solaris

command to retrieve user information

Hi, I want the command to retrieve the existing user information such as * authorization * Profile * role * exipre(expiration date of login) * inactive please tell me how to do that Thank you. (3 Replies)
Discussion started by: S_venkatesh
3 Replies

3. UNIX for Dummies Questions & Answers

retrieve lines that match a pattern

Hi, I would like to know how can I get lines from a text file that match no more than 2 '>'. Example: Input file: a >cr1 4 a>b b>c a >cr2 5 a>b Output file: a >cr2 5 a>b Thanks in advance (2 Replies)
Discussion started by: fadista
2 Replies

4. Shell Programming and Scripting

Execute a C program and retrieve information

Hi I have the following script: #!/bin/sh gcc -o program program.c ./program & PID=$! where i execute a C program and i get its pid. I want to retrieve information about this program (e.g memory consumption) using command top. So far i have: top -d 1.0 -p $PID But i dont know how to... (6 Replies)
Discussion started by: nteath
6 Replies

5. Shell Programming and Scripting

Retrieve lines that match any occurence in a list of patterns

I have two files. The first containing a header and six columns of data. Example file 1: Number SNP ID dbSNP RS ID Chromosome Result_Call Physical Position 787066 SNP_A-8575395 RS6650104 1 NOCALL 564477 786872 SNP_A-8575125 RS10458597 1 AA ... (13 Replies)
Discussion started by: Selftaught
13 Replies

6. Shell Programming and Scripting

Match pattern1 in file, match pattern2, substitute value1 in line

not getting anywhere with this an xml file contains multiple clients set up with same tags, different values. I need to parse the file for client foo, and change the value of tag "64bit" from false to true. cat clients.xml <Client type"FIX"> <ClientName>foo</ClientName>... (3 Replies)
Discussion started by: jack.bauer
3 Replies

7. Shell Programming and Scripting

Retrieve information Text/Word from HTML code using awk/sed

awk/sed newbie here. I have a HTML file and from that file and I would like to retrieve a text word. <font face=arial size=-1><li><a href=/value_for_clients/Tokyo/abc_process.txt>abc</a> NDK Version: 4.0 </li> <font face=arial size=-1><li><a... (6 Replies)
Discussion started by: sk2code
6 Replies

8. Shell Programming and Scripting

Display match or no match and write a text file to a directory

The below bash connects to a site, downloads a file, searches that file based of user input - could be multiple (all that seems to work). What I am not able to figure out is how to display on the screen match found or no match found" and write a file to a directory (C:\Users\cmccabe\Desktop\wget)... (4 Replies)
Discussion started by: cmccabe
4 Replies

9. Solaris

Solaris commands to retrieve chipset information

I need to know what are the commands in Solaris to retrieve the below information about the hardware platform. 1. Chipset information (information about various hardware controller cards on the mother boards, system BIOS versions, PCI firmware version etc..) 2. Serial number of the work... (2 Replies)
Discussion started by: rajujayanthy
2 Replies

10. Shell Programming and Scripting

awk to update file based on partial match in field1 and exact match in field2

I am trying to create a cronjob that will run on startup that will look at a list.txt file to see if there is a later version of a database using database.txt as the source. The matching lines are written to output. $1 in database.txt will be in list.txt as a partial match. $2 of database.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies

LEARN ABOUT OPENSOLARIS

noecho

echo(3XCURSES)						  X/Open Curses Library Functions					    echo(3XCURSES)

NAME

       echo, noecho - enable/disable terminal echo

SYNOPSIS

       cc [ flag... ] file... -I /usr/xpg4/include  -L	/usr/xpg4/lib 
	-R  /usr/xpg4/lib  -lcurses  [ library... ]

       c89 [ flag... ] file... -lcurses [ library... ]

       #include <curses.h>

       int echo(void);

       int noecho(void);

DESCRIPTION

       The  echo()  function enables Echo mode for the current screen. The noecho() function disables Echo mode for the current screen. Initially,
       curses software echo mode is enabled and hardware echo mode of the tty driver is disabled. The echo() and noecho() functions control  soft-
       ware echo only. Hardware echo must remain disabled for the duration of the application, else the behavior is undefined.

RETURN VALUES

       Upon successful completion, these functions return OK. Otherwise, they return ERR.

ERRORS

       No errors are defined.

ATTRIBUTES

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

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |Unsafe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       getch(3XCURSES), getstr(3XCURSES), initscr(3XCURSES), libcurses(3XCURSES), scanw(3XCURSES), attributes(5), standards(5)

SunOS 5.11							    5 Jun 2002							    echo(3XCURSES)
All times are GMT -4. The time now is 05:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy