Sponsored Content
Top Forums Shell Programming and Scripting awk file to read values from Db2 table replacing hard coded values Post 302902481 by asandy1234 on Tuesday 20th of May 2014 05:24:45 PM
Old 05-20-2014
Quote:
Originally Posted by Akshay Hegde
Code:
$ awk -F, 'FNR==NR{A[$1];next}!($3 in A)' compare.txt input.txt

Thanks Akshay for the prompt reply but I'm getting an error as below(The name of the KSh file is remove_admin.ksh) ...

remove_admin.ksh[6]: $: not found.


Code:
#!/usr/bin/ksh
inputfile="/home/xxxx/input.csv"
comparefile="/home/xxxx/compare.csv"
touch $inputfile
touch $comparefile
$ awk -F, 'FNR==NR{A[$1];next}!($3 in A)' $comparefile $inputfile

 

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
WMC(1)							      Wine Developers Manual							    WMC(1)

NAME
wrc - Wine Message Compiler SYNOPSIS
wmc [options] [inputfile] DESCRIPTION
wmc compiles messages from inputfile into FormatMessage[AW] compatible format encapsulated in a resourcescript format. wmc outputs the data either in a standard .bin formatted binary file, or can generated inline resource data. wmc takes only one inputfile as argument (see BUGS). The inputfile normally has extension .mc. The messages are read from standard input if no inputfile is given. If the outputfile is not specified with -o, then wmc will write the output to inputfile.{rc,h}. The outputfile is named wmc.tab.{rc,h} if no inputfile was given. OPTIONS
-B x Set output byte-order x={n[ative], l[ittle], b[ig]}. Default is n[ative]. -c Set 'custom-bit' in message-code values. -d NON-FUNCTIONAL; Use decimal values in output -D Set debug flag. This results is a parser trace and a lot of extra messages. -h Print an informative usage message. -H file Write headerfile to file. Default is inputfile.h. -i Inline messagetable(s). This option skips the generation of all .bin files and writes all output into the .rc file. This encoding is parsable with wrc(1). -o file Output to file. Default is inputfile.rc. -u Assume that the inputfile is in unicode. -U Write resource output in unicode formatted messagetable(s). -v Show all supported codepages and languages. -V Print version end exit. -W Enable pedantic warnings. EXTENSIONS
The original syntax is extended to support codepages more smoothly. Normally, codepages are based on the DOS-codepage from the language setting. The original syntax only allows the destination codepage to be set. However, this is not enough for non-DOS systems which do not use unicode source-files. A new keyword Codepages is introduced to set both input and output codepages to anything one wants for each language. The syntax is similar to the other constructs: Codepages '=' '(' language '=' cpin ':' cpout ... ')' The language is the numerical language-ID or the alias set with LanguageNames. The input-codepage cpin and output-codepage cpout are the numerical codepage-IDs. There can be multiple mapping within the definition and the definition may occur more than once. AUTHORS
wmc was written by Bertho A. Stultiens. BUGS
The message compiler should be able to have multiple inputfiles and combine them into one outputfile. This would enable the splitting of languages into separate files. Unicode detection of the input is suboptimal, to say the least. It should recognize byte-order-marks (BOM) and decide what to do. Decimal output is completely lacking. Don't know whether it should be implemented because it is a, well, non-informative format change. It is recognized on the commandline for some form of compatibility. AVAILABILITY
wmc is part of the wine distribution, which is available through WineHQ, the wine development headquarters, at http://www.winehq.org/. SEE ALSO
wine(1), wrc(1) Wine 1.2-rc6 October 2005 WMC(1)
All times are GMT -4. The time now is 09:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy