Search Results

Thanks anbu23!

#if [ -z $1 ] ; then
echo 'Assuming LIVE database '
export db='LIVE'
else
export db=$1
echo "Running against $db database"
fi

ORACLE_SID=$db

#collect file from inputf folder
cd...

It does, if I do:

awk '/^0/ { print "AA"substr($0,10,6)"00"}' $filename > TEST_FILE

all works fine, however I need to process files with two different names in a slightly different manner,...

have tried

awk '/^0/ && FILENAME ~ /^AA/ { print "AA"substr($0,10,6)"00"}' $filename > TEST_FILE

however there is nothing being printed out to the TEST_FILE even though the file I'm...

Should it be:

awk '/^0/ && $filename ~ /^AA/ { print "AA"substr($0,10,6)"00"}' $filename > TEST_FILE
awk '/^0/ && $filename ~ /^XX/ { print "XX"substr($0,10,6)"00"}' $filename >> TEST_FILE
...

Should it be:

awk '/^0/ && $filename ~ /^AA/ { print "AA"substr($0,10,6)"00"}' $filename > TEST_FILE
awk '/^0/ && $filename ~ /^XX/ { print "AA"substr($0,10,6)"00"}' $filename >> TEST_FILE
...

??

Can you explain that a little further?
How does that compare the first two characters of the filename to match a string such as "AA"

Thanks.

ksh.

Hi,

I am trying to loop through the files in a directory, and process them one by one where a naming convention is met, this is fine.

As part of the looping process I need to check the...

Hi,

I'm trying loop through all files in a directory that have a filename starting with 'CC', and process them one by one. Can any provide an example of how I could do this. I've started with:
...

Hi,

I am using the following awk command to parse an exchange rates file:
awk '{if(substr($0,0,8) == "GBP_EUR=") print "3 Euros "substr($0,9,18)" NOW() SYSADMIN"}'...

Didn't come accross anything for MYSQL, only Oracle and DB2

Hi,

Can anyone help me with the correct syntax to call a MYSQL stored procedure from a shell script.

I have tried the following, (no input params):
/usr/bin/mysql -uadmin -ppassword call...

Great reply that, thanks it gives me somewhere to start.

Where to start?

Ok, I need to pick up a Worldpay exchange rates file from a url such as:
https://select.worldpay.com/wcc/info?op=rates&instId=12345&op=rates-today

the http response returns a...

I am trying to nawk through a file and if the 24.25.26 charachters in the file are "000" then print a line to a new file in one format, otherwise print a line in a different format.

So far I have...

I am trying to nawk through a file and if the 24.25.26 charachters in the file are "000" then print a line to a new file in one format, otherwise print a line in a different format.

So far I have...

Hi,

Thanks for that, it seems to work fine although it puts an unwanted space between the row number and the next value printed out, for example if ($0,1,8) is ABCDEFGH then the output to the...

Hi,

I am trying to parse a file of fixed length transactions into a new file. Using awk I need to add the line number as a 5 digit long numeric value to each of the transactional rows.

i.e....

Quick question,

File A has one line (10 charachters), File B has one line (10 charachters).

how do a concat these two files together to produce a file (File C) that has the contents of Files A...

Hi,

Is it possible to initialise a shell variable and set it to a value from an awk command?

i.e.

#set myvalue = to the first 8 charachters of the line that begins with 0
myvalue = awk...