awk file to read values from Db2 table replacing hard coded values
Hi,
I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below...
May be I'm looking to populate an array and loop through it.Is is even possible ? any help is greatly appreciated.
Seeing from the response I think its more complicated than I thought.To make it simple can we program an .awk file to read a one column CSV file and loop through it?
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
The file that contains list to compare will look like below, name it compare.txt
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
=======================================================================
=======================================================================
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
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)
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)
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)
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)
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)
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)
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)
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)
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)