Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Lookup in another file and conditionally modify it inline
Top Forums Shell Programming and Scripting Lookup in another file and conditionally modify it inline Post 302989591 by Don Cragun on Monday 16th of January 2017 03:59:51 AM
Old 01-16-2017
Assuming that your first sample file is named f1 rather than f1 being the first line of your first file and that your second input file is named f2 rather than the first line of your second input file being f2 (tran number is second field), then you can use whichever one of the suggestions RudiC provided that matches the actual input you need to process. If those two lines are actually in your input files, the following seems to produce the output you want:
Code:
awk '
BEGIN {	FS = OFS = ","
}
FNR == 1 {
	next
}
FNR == NR {
	tn[$1]
	next
}
$2 in tn {
	if($5 == "X")
		$2 = $2 "_P"
	else if($5 == "Y")
		$2 = $2 "_T"
}
1' f1 f2

If you want to try this (or either of RudiC's suggestions) on a Solaris/SunOS operating system, change awk to /usr/xpg4/bin/awk or nawk.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to update the contents in a file conditionally?

Hi All, I have a data file which has two columns Location and the Count. The file looks like this India 1 US 0 UK 2 China 0 What I have to do is whenever I fails to login to Oracle then I have to add 1 to the count for that location. Whenever my script fails to login to Oracle for a... (5 Replies)
Discussion started by: rajus19
5 Replies

2. UNIX for Advanced & Expert Users

Clueless about how to lookup and reverse lookup IP addresses under a file!!.pls help

Write a quick shell snippet to find all of the IPV4 IP addresses in any and all of the files under /var/lib/output/*, ignoring whatever else may be in those files. Perform a reverse lookup on each, and format the output neatly, like "IP=192.168.0.1, ... (0 Replies)
Discussion started by: choco4202002
0 Replies

3. Shell Programming and Scripting

using sed to conditionally extract stanzas of a file based on a search string

Dear All, I have a file with the syntax below (composed of several <log ..... </log> stanzas) I need to search this file for a number e.g. 2348022225919, and if it is found in a stanza, copy the whole stanza/section (<log .... </log>) to another output file. The numbers to search for are... (0 Replies)
Discussion started by: aitayemi
0 Replies

4. Shell Programming and Scripting

perl - reading from a file conditionally

Hi, I am new to perl. I want to read from a file on the basis of some conditions.. I want to define parameters in a configuration file in such a manner like... etc.. in my perl script, theer is a variable like this.. then i want to read values from first if block from the file... (1 Reply)
Discussion started by: shellwell
1 Replies

5. Shell Programming and Scripting

Inline searc and replace inside file

Hello, I have a text file that i want to redirect into a new file , searching and replacing certain string during the opertaion. This should be done using shell script , so it should not be interactive. The script should get four parameters : source file target file source string target... (1 Reply)
Discussion started by: yoavbe
1 Replies

6. Shell Programming and Scripting

Remove file conditionally between two server using sftp

Hi, I am having 2 servers, Need to delete files from server1 if those files exist in server2 other wise no action using sftp .And the process is non-interactive way. I have got confused how to check the condition in sftp because there is non of the shell condition or loop command is executing.... (2 Replies)
Discussion started by: posix
2 Replies

7. Shell Programming and Scripting

Loop through file to sum conditionally

Hi, I have a file with header, detail and trailer records. HDR|111 DTL|abc|100|xyz DTL|abc|50|xyz TRL|150 I need to add the values in 3rd field from DTL records. Using awk, I am doing it as follows: awk -F'|' '$1=="DTL"{a += $3} END {print a}' <source_file> However, I want to... (3 Replies)
Discussion started by: delta21
3 Replies

8. Shell Programming and Scripting

How to replace a text in a file conditionally?

I have got about 100 ascii files and I want replace some variable with a new one on an HP-UX system. But I want to put a line of comments before the change. I want to make file1 to file2. I am explaining below. file1: line1 line2 export QNAME=ABC line4 line5 file2: line1 line2 #... (3 Replies)
Discussion started by: asutoshch
3 Replies

9. Shell Programming and Scripting

Removing inline binary data from txt file

I am trying to parse a file but the filehas binary data inline mixed with text fields. I tried the binutils strings function , it get the binary data out but put the char following the binary data in a new line . input file app_id:1936 pgm_num:0 branch:TBNY ord_num:0500012(–QMK) deal_num:0... (12 Replies)
Discussion started by: tasmac
12 Replies

10. UNIX for Advanced & Expert Users

Combining awk Inline and File Code

I've ended up with a small collection of libraries I like to use with awk, but this means I can't do awk -f librarycode.awk '{ program code }' filename because awk will assume that anything after -f is a filename, not code. Is there any way I can do both? (6 Replies)
Discussion started by: Corona688
6 Replies

LEARN ABOUT CENTOS

yum-shell

yum(8)																	    yum(8)

NAME

       yum - Yellowdog Updater Modified shell

SYNOPSIS

       yum shell [filename]

DESCRIPTION

       yum includes an interactive shell for conducting multiple commands or sets of commands during a single execution of yum. These commands can
       be issued manually or passed to yum from a file. The commands are much the same as the normal yum command line options. See here yum(8) for
       that information. There are a few additional commands documented below.

       config
		 [argument] [value]
		 args: debuglevel, errorlevel, obsoletes, gpgcheck, assumeyes, exclude
		   If no value is given it prints the current value.
		   If value is given it sets that value.

       repo
		 [argument] [option]
		   list: lists repositories and their status
		   enable: enable repositories. option = repository id
		   disable: disable repositories. option = repository id

       transaction
		 [argument]
		   list: lists the contents of the transaction
		   reset: reset (zero-out) the transaction
		   solve: run the dependency solver on the transaction
		   run: run the transaction

Examples
       The following are examples of using the yum shell.

	       list available packagename*
	       groupinfo 'Some Group'
	       install foo
	       remove bar
	       update baz
	       run

	      That  will  list	available packages matching the glob 'packagename*'.  It will return information on the group 'Some Group' It will
	      then queue the following commands into  the transaction: install foo, remove bar, update baz. Then the 'run'  command  will  resolve
	      dependencies for the transaction commands and run the transaction.

SEE ALSO

       yum (8)
       http://yum.baseurl.org/

AUTHORS

       See the Authors file included with this program.

BUGS

       There of course aren't any bugs, but if you find any, they should be sent to the mailing list: yum@lists.baseurl.org or filed in bugzilla.

Seth Vidal																    yum(8)
All times are GMT -4. The time now is 06:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy