Search Results

Hi,

I want your help to see if there is a way wherein we can load a set of files which are lying in unix server into my database using sql loader.
Also the person who will be running sql loader...

Hi,
Can you please advise on answers of below 4 questions as I am not sure on the answers.
1.
You are porting a C program that interacts over a network with remote systems. The program was...

Hi Unix geniuses,

I need your help for the answers of few objective Q&A.
i dont know if my answers are correct or not.
So i really need your help to provide the answers which will help me in...

hi,


source directory as /home/home01
target directort as /home/home02

I have below files in source directory:

FrontOf_history.dat
FrontOf_history1.dat

In target directory have many...

hi,
Need your help.
I need to write a script for below..
i have two files in directory /home/abc as below:

Watch_20140203_abc.dat
Watchnow_20140203_abc.dat

I have to copy this file from
...

Hi,

I have the below script which is fetching the data from a file as below:

awk -F "~" 'NR>1 {print $5}' 1.txt
The o/p is like:

1452350
1458638
1452350
2
5696837


No i want to...

i want to search the file in this way only as sometimetimes the file name is
Account_20090213_abc.dat and sometimes Account_20090213_bcd.dat and various other combinations..
so how can i do...

Hi,

I want to check if the file exists or not in the directory.
i am trying below code but not working.


File="/home/va59657/Account_20090213*.dat"
echo "$File"
if [[ -e "$File" ]]; then...

HI,

I have two scripts which is sending the mail in html format.


Script 1:

1.IFILE=/home/home01/Report.csv
if [ -r $IFILE ] #Checks if file exists and readable
then
if awk -F, '{ T...

I tried below but not working:


} ' ${IFILE} >> $OFILE1

But still output not coming and something loke below is getting printed:


<TR><TD>* * * * * End Of Report * * * *...

all the echo statements are getting printed correctly.
I triied sendmail -t option in script 2 but still the output is same.
below code is not getting executed corrcetly in 2nd script:
Not sure if...

Can you pls guide what excactly should be written and how?
Also how come script 1 is working perfectly fine and output not coming in Script 2.

Hi,

I am running two scripts as below.
In Script 1 i am getting correct output in proper HTML format while in script 2 i am not getting output in mail and only html code is getting printed.I...

Thanks.i am using this code as I have only one row in the file..
The other code was perfectly working for all the cases.
But I want HTML output only but through email sent by output.sh.
When I am...

Hi,

I am calling a script log.sh from output.sh.
Log.sh has below pice of code:


IFILE=/home/home1/Report1.csv
if awk -F, '$6==0 && $7==0{exit 1}' ${IFILE}
then
awk -F, '
BEGIN{...

Hi,

gawk not working.
Sample:



Case 1:Mail should come
Report
,,,,,,,Report generating
Column 1,column 2,column 3,column 4,column 5,column 6,column 7
1,2,3,4,5,0.00,0.00...

No..initially column has 0 value.Now if i want to check 0.00 then this logic doesnt seem to working with decimal values.
Please guide.

Sorry i didnt see your reply and edited my last post.
I want to check now 0.00 both in cloumns.
Please guide.

Thanks a lot..It worked....
last question..if instead of 0 column value is either 0 or 0.00 then what should be the logic.
Please guide.

This is what it is writing when i am running in debug mode.
In this case both cloumns 6 and 7are 0 in all the rows.


+ awk -F, '{ T += $6 + $7 } END { exit(!T) }' /home/home01/file.csv
+...

Actual data is somwething like below:


Case 1:Mail should come
Report
,,,,,,,Report generating
Column 1,column 2,column 3,column 4,column 5,column 6,column 7
1,2,3,4,5,0,0
1,3,5,6,7,1,1...

i tried the code suggested by Corona,case 1 is success but in others also i am not getting the mail.

Case 1
0,0
0,0
0,0

No mail..success


Case 2:
0,0
0,1
0,0

No...

Thnaks..I tried the soln proposed by Corona and Franklin but still i am getting the mail if column 6 and cloumn 7 both are 0 in file.
I want that if in any row of the file (either or both) of cloumn...

Yes..no email should be sent and entire program should be skipped if both columns have 0 in all the lines.

Still the mail is coming...It seems that the problem is not with this condion but in opening and closing of if statement and location of sendmail -t in html code.Please guide me.

...