Search Results

balajesuri,

thank you for showing me that this is also be done using perl.

regards,
Pgonzalez.

Im loosing my mind here...no matter what I do... it is still showing incorrect format. Consitontly showing errors no matter what I do.
usage: date [-jnu] [-d dst] [-r seconds] [-t west]...

Im afraid it is still not working for me.
usage: date [-jnu] [-d dst] [-r seconds] [-t west] [-v[+|-]val[ymwdHMS]] ...
[-f fmt date | [[[mm]dd]HH]MM[[cc]yy][.ss]] [+format]
usage:...

Yes, when I run this, I get this error.
date -d "2012-01-04 + 6 day" "+%Y_%m_%d"


usage: date [-jnu] [-d dst] [-r seconds] [-t west] [-v[+|-]val[ymwdHMS]] ...
[-f fmt date |...

Hi Mirni,

I want it to display the next few days untill it reaches the value of c. To explain more clear,

Lets say if we pass a date of '2011-11-20' as argument then we want to see the next...

Hi Experts,

I tried to stay away from posting stuff here and asking for help.

I want to print date valeu for a given variable and that is not working.

#!/bin/bash
START=`echo $1 | tr -d _`;...

Radoulov,

That was a deliberate mistake by me. At anyrate, I shall let you know how it goes as I need to get off the shift now but when I just ran the script on dual table, it did show the...

radoulov,

The script errors with the following msg -

hdflldRR3:/Users/PGonzalez 06:26:57 cat SBR.sh

printf 'select %s from dual;' "$(
printf "'%s'\n" $(<infile) |
paste -sd, -A
...

Hi All,

My flat file lets say has the following contents

AT & T
CITIZENS MOHAVE CELLULAR
COMMNET
DRR
E1CELLULAR
....

Now, Im trying to select data from a flat file(sitting on unix...

Scrutinizer,

You truly are exalted !

regards,
PGonzalez.

Scrutinizer,

Thank you for the reply.

To make it a bit more clear, SETT is the final part of the puzzle & is an abbreviation for SETTLEMENT. These three records have to looked at together and...

Scrutinizer,

Yes, after a second glance, I realized the extra "]" and when I took out, it just ran well.

Sure here is the sample set of records with 3 records instead of two.

11393 18.77(E)...

Scrutinizer,

Thanks a bunch for making yourself clear in you are doing here but I dont get it completely. I think I should pick up the Kernighan's book on Awk.

First things first, "Thanks for...

Scrutinizer,

Just great ! but I couldn't follow you as well.

Im simply embarrassed to even pose this question to you. Can you please explain this to me as to what you are doing here ?
...

Ctsgnb,

Amazing. Perfect results. Ran this even on a file with 200,000 rows and came back at me under 1 minute.

Big big thanks.

Btw, can you please please decipher this for me as I might...

Hi Experts,

back at this forum again. Have a tab separated file like this ---

ACCNN AMT(E/$) TYPE ID
11233 23.20($) AUTH 339
11233 ...

Peasant,

You are so correct. I did which on the expr and it did not show anything under there. Thanks a bunch.

Appreciate your help and I cant believe that I was doing such a silly mistake.
...

Hi Experts,

Im running a bit complicated sql script and for reasons of scheduling,I wrapped it around in a simple shell script. So, when I run it, it do creates an output file and writes to it...

Ctsgnb & Ygor,

This script was working fine for me till day before yesterday. I had to make some changes by adding few columns which have null values or spaces. So, when I run the same script, it...

Mr. Macnamara,

That was Sheer Brilliance ! Absolutely mind boggling.

Thank you and super big Thank you !

Now, here are my questions. First I edited your code in here by adding another...

Hi Experts,

Need some help with a script which is definetly beyond my scripting skills.

Here is flat file that I have with 4 Key Columns


KEYCOLUMN1 KEYCOLUMN2 ...

Ctsgnb & Ygor,

Yes, the size of the file that we are talking is pretty small only 60 lines or so and hence I thought this could be the *easy* way out.

Ygor, I shall post any further questions...

Hey Thanks for the quick response. Im as new as they come to Oracle itself. I read couple of posts here pointing me in this direction as it looks pretty simple & easy to follow & ofcourse it doesnt...

Hi Folks,

Im going through this forum down here looking for some clues as how to insert a CSV file into a table in Oracle. Im in the same situation as the one who posted their question in here.
...

Klashxx & ygemici,

Both your answers worked perfectly for me.

Greatly thank your contribution and as always your contribution to many a minion like me is truely cherished.

Pgonzalez.