Search Results

Hi All,

Could experts in the forum suggest me a good book to create web based applications using Perl.

Much thanks in advance

Karthick

Hi Pludi,

Thanks for your reply .....

So I need to use

my $sth= $dbh->prepare( qq{select * from www});

$worksheet->set_column("A:A", 8);...

Hi All,

I need to take a dump of a table and load into excel and send as an attachment and for this am using a Perl script.
I know the usual way of doing this by writing all the fields next to...

Hi All,

I am using ingres in perl
select count(*) rec from user_tables where table_name = 'abc';
I want to use the alias variable 'rec' and check the value if >0 insert values else create table....

This command will change the permission for all specified files but I want to find files with this permission -r-xr-xr-x and change it to -r-xr-xr-- for a group of files

Hi there,

I want to change from this permission -r-xr-xr-x to -r-xr-xr-- for a set of files under unix.

Can someone help me to go-about doing this in one shot.

Cheers,
RN

Hi there,

How to calculate the elapsed time in minutes for a particular job run under unix.

I tried the following
$ ps -efo user,pid,etime,comm,args | grep myscript | grep -v grep | awk -F" "...

Got it worked using nawk.

Thanks for all responders

Thanks for your reply.

Pls find below the sample.
...

My awk command failed saying "awk: record `000450^2009^1^13^001...' too long". I've an alternate way of making this to work using grep but i would like to know is there something in 'awk' to be...

Hi,

I need to automate a script.
The process in the script is as follows
Running the script abc.ksh
The report is stored in xyz (flat file)
Need to store the flat file content in an excel...

Great franklin .... thanks for your help

This command removes all the lines leaving C^E^2008^ZAT08^14.

My welcome1 file should have a content that does not have 'M' in the first col and '2' in the fifth col.

also it should not have...

I need an o/p which does not have the one's highlighted below in red as per my command.
S^E^2008^12G43^7
C^E^2008^ZAT08^14
S^E^2008^ZAR48^22
M^E^2008^0TL69^2
S^E^2008^FCB67^30

pls find below welcome content

S^E^2008^12G43^7
C^E^2008^ZAT08^14
S^E^2008^ZAR48^22
M^E^2008^0TL69^2
S^E^2008^FCB67^30

Nothing is happening ...the command is just redirecting the contents of welcome to welcome1 without any difference.

awk -F^ '{ if ((($1 != "M") && ($5 != "2")) || (($1 != "S") && ($5 != "7"))) print $0}' welcome > welcome1


The "&&" and "||" in the above command is not working with awk.

When I run the above...

Can you try working of this below command.

awk -F^ '{ if ((($1 != "M") && ($5 != "2")) || (($1 != "S") && ($5 != "7"))) print $0}' welcome > welcome1

awk -F^ '{ if ((($1 == "M") && ($5 == "2")) || (($1 == "S") && ($5 == "7"))) print $0}' welcome > welcome1

When I run the above awk command, I could see the same content of welcome in welcome1.
...

awk -F^ '{ if (($1 != "X") && ($5 != "3")) || if (($1 != "S") && ($5 != "2")) print $0}' abc> xyz

The above command returns this error

awk: syntax error near line 1
awk: illegal statement...