Search Results

bump..

If I echo $PATH I get details, but echo-ing $SCREENPATH or $CLASSPATH returns a blank.

As I get this error message - it must be related..

'/<file structure>/<little script>.sh: line...

OK, thanks for ther update Tom but does it matter that the CLASSPATH is mentioned in the actual script I am running too?

actual script reads..

cat <littlescript>.sh...

hi gurus.

I have a little script that runs java from a certain directory. This script runs fine when run manually but when I try to schedule it, it fails to find the script.
...

well, inadvertantly unix.com forum still found the answer!

Whilst reading others' posts I found when using my nawk command instead of the '1' at the end of the find and replace line, Ive used...

Yes, the format of the newdatafile IS the same as the original - all Ive done is nulled a few comma-separated fields in the file.
Also, as I created the table where the file is being loaded into I...

yes I think you understand right its just I'm not using it correctly. When I do that, then try and call the 'newfile' later down the script it doesnt recognise it as the midified version of the...

hello there.
I have a script that loads data files into ORACLE tables.
I had to then add an awk line to take any zeros out of any fields prior to load which works perfectly well on its own but I...

Mr Franklin32 you're an absolute star. The output file flew into ORACLE tables via Financials ['nark' worked a treat..] and now I can modify it so no matter what rubbish data they send I can check...

..its stilll not running Im afraid..

$ awk 'BEGIN{FS=OFS=","}{for(i=1;i<=NF;i++){if($i=="0"){$i=""}}}1' SLsTester_DataFile.csv > SLsOUtputFile.csv;
awk: syntax error near line 1
awk: bailing...

..an error is being returned when I try to run this either by itself or in a script - am I not running it right?

$ cat SLsTester_DataFile.csv | awk...

thanks for the quick reply..

the csv's first two lines look like:

13426,Williams,Robyn,Robyn,20031106,0,0,20080421,0,NASP39,Casual Sport & Recreation...

hello.

I'm somewhat a novice here so please be patient. My stumbling block when loading csvs into ORACLE tables is this:

I need to read a csv datafile, check several fields in each line, and...