Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk file to read values from Db2 table replacing hard coded values
Top Forums Shell Programming and Scripting awk file to read values from Db2 table replacing hard coded values Post 302902420 by asandy1234 on Tuesday 20th of May 2014 12:57:37 PM
Old 05-20-2014
Quote:
Originally Posted by Akshay Hegde
I really did not understand your query, please show input and desired output with brief description.
Sorry for not being clear in my question.

The input file will look like this, name it input.txt
Code:
a1,b1,c1,d1,e1
a2,b2,c2,d2,e2
a3,b3,c3,d3,e3

The file that contains list to compare will look like below, name it compare.txt
Code:
c2,
c5,
c20,


The awk file should compare column 3 in input.txt with compare.txt and delete rows that is in the list.

In the example above, since c2 is there in the list the row containing c2 should be deleted.
The final output is
=======================================================================
Code:
a1,b1,c1,d1,e1
a3,b3,c3,d3,e3

=======================================================================

The input.txt will contain around 10 million records and compare.txt will have around 100 entries.

Hope I made it clear.

Thanks,
Last edited by Franklin52; 05-21-2014 at 09:39 AM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Converting Binary decimal coded values to Ascii Values

Hi All, Is there any command which can convert binary decimal coded values to ascii values... i have bcd values like below îîîîîîîîîîîî0î-- -v - Pls suggest a way to convert this. Thanks, Deepti.Gaur (3 Replies)
Discussion started by: gaur.deepti
3 Replies

2. Shell Programming and Scripting

Replacing File values

Currently I am using the tr command in 3 scenarios for a ksh script. 1) Replacing any spaces in the file with a ~ tr ' ' '~' <$orignalFile> $newFile 2) After certain processing is done at the end of the scirpt i convert the Tilde back to spaces tr ' ' '~' <$newFile> $newFile2 3) Last... (4 Replies)
Discussion started by: hgjdv
4 Replies

3. Shell Programming and Scripting

Reading values from a file using DB2 SQL

I have some alphbetical codes in that (1 Reply)
Discussion started by: kavithakuttyk
1 Replies

4. Shell Programming and Scripting

AWK: read values from file1; search for values in file2

I have read another post about this issue and am wondering how to adapt it to my own, much simpler, issue. I have a file of user IDs like so: 333333 321321 546465 ...etc I need to take each number and use it to print records wherein the 5th field matches the user ID pulled from the... (2 Replies)
Discussion started by: Bubnoff
2 Replies

5. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

6. Shell Programming and Scripting

Replacing values in a file based on values in another file

Hi I have 2 files:- 1. List of files which consists of names of some output files. 2. A delimited file; delimted by "|" I want to replace the value of the $23 (23rd column) in the delimited file with name in the first file. It is always position to position. Meaning first row of the first... (5 Replies)
Discussion started by: pparthiv
5 Replies

7. Shell Programming and Scripting

Read parameter file in a shell script to unload a DB2 Table???

Hi , I Have following requirement: DB2 Sql query to pass from a parameter file for example, I would create a parameter file with (SELECT column 1, column 2 FROM Table name) then job would read it and create a file with the contents named table.txt How to write/modify below ksh script to... (10 Replies)
Discussion started by: developer.dwh9
10 Replies

8. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies

9. Shell Programming and Scripting

Read record from the text file contain multiple separated values & assign those values to variables

I have a file containing multiple values, some of them are pipe separated which are to be read as separate values and some of them are single value all are these need to store in variables. I need to read this file which is an input to my script Config.txt file name, first path, second... (7 Replies)
Discussion started by: ketanraut
7 Replies

10. Shell Programming and Scripting

Read values from second file in awk

Hello Friends, I have written a script like the following, which finds some logs and fetchs some desired rows and then calculate average processing time of a spesific application. if then echo echo "----- There are three arguments which is expected to run this script! ... (5 Replies)
Discussion started by: EAGL€
5 Replies

LEARN ABOUT DEBIAN

trcs

trcs(1) 							   User Manuals 							   trcs(1)

NAME

       trcs - convert text files from one codeset to other

SYNOPSIS

       trcs -C | -l | -h

       trcs [-s] [-f input-codeset ] [-t output-codeset ] [ file ]...

DESCRIPTION

       trcs  is a program for translation of text files from one codeset to other.  When exact translation is impossible it tries to make approxi-
       mations.  For example pseudographic characters are approximated by ASCII characters in codesets that have no pseudographic  characters  and
       characters with diacritical marks are approximated by existing characters.

       If the option -s or --gen-script is given trcs will generate simple script that invokes tr(1) This is useful if you want to include this in
       your script or for faster conversion of many files.

       If none of -C, -s, -l, -h and their equivalents is given each file will be read assuming it is coded with codeset input-codeset On standard
       output  it will be recoded so to use codeset output-codeset If there is no file given trcs will act as filter.  Both input-codeset and out-
       put-codeset are case insensitive and default to `cp1251'.

OPTIONS

       -C, --copyright
	      Display copying conditions and warranty information.

       -s, --gen-script
	      Generates conversion script for given input and output encodings instead to convert text files.

       -l, --list
	      List all known codesets with their aliases.

       -h, --help
	      Display this help and exit.

       -f input-codeset, --from[=]input-codeset
	      Codeset of the source.

       -f output-codeset, --to[=]output-codeset
	      Codeset of the output.

EXAMPLES

       trcs -fcyrillic -t koi8-r letter.txt
	      Convert letter.txt from ISO-8859-5 (cyrillic) to KOI8-R and output the result on standard output.

       trcs --from cp437 --to=mik --gen-script >ibm2mik
	      Generates script ibm2mik for converting from CP437 to MIK.

       sh ibm2mik screen.txt
	      Convert screen.txt from CP437 to MIK.  Output the result on standard output.  Without parameters ibm2mik acts as filter.

AUTHOR

       Anton Zinoviev <anton@lml.bas.bg>, <zinoviev@fmi.uni-sofia.bg>

SEE ALSO

       tr(1)

Linux								     JUN 2000								   trcs(1)
All times are GMT -4. The time now is 08:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy