Search Results

If you want to capture the output of any command, we then will be writing the system command in `` or qx.

`` an qx works fine with all linux and windows system commands.

But when I execute the...

Thank you Robin.

The data that I pasted is the output of Data dumper itself.
In the below code $xml_ref variable contains that Data dumper output and I am trying to read that data through...

Hi team,

# PERL
I have Dumper variable in perl and containing the below data and trying to fetch value and name from the reference variable.


$VAR1 = {
'retainSysIds' => 'true',
...

I am working on requirement on spreadsheet in python scripting.

I have a spreadsheet containing cell values and with background color.

I am able to read the value value but unable to get the...

There is no such condition. But the only thing is the final output should not contain

00000000:00000000 values

I have a log containing the below lines.
file1.log
-----------

module:
module1
module10
module2
module002
module9
moduleRT100.2.1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0...

vat.log
--------
null
null statistics
null


null
null
Storage Response Time
disk space1
disk space2


I have a log as mentioned above in which I need to copy only the below content...

Thourgh Perl scripting, Is it possible to upload excel sheet to sharepoint portal ?

If the answer is YES.. Could you please share your thoughts and required CPAN modules or any examples to proceed...

I have 4 files in a directory and want to delete only first 2 files only..


$ ls -ltr
total 640
-rw-r--r-- 1 user other 148779 Oct 12 10:50 file1.xls
-rw-r--r-- 1 user other ...

Many thanks for replying over my post.
Tried the below code but no luck... black space was printed instead of expected 2 and 51.


$var1 = "2% / 51%";
if($var1 =~ /^(\d+)%.*(\d +)%$/) {
my...

Tons of thanks balajesuri...

one small doubt... based on requirement we write some scripts on UNIX and windows environment.

For one specific requirement I have used spreadsheet::xlsx in...

I have a perl variable which contains the below value.

$var1 = "2% / 51%"

Now I would like to split the data into 2 different variables.
For example

$part1 = 2
$part2 = 51

Could...

Many thanks for replying the post.

Actually what my problem is, I have written few scripts which I need to provide them to my client.Since client is not aware of modules installations and all, he...

I have installed perl in windows.

Now I would like to install spreadsheet::xlsx & DateTime::Format::Excel modules(also few more) at a time instead of installing them seperately.

Could you...

In windows, my script is working perfect on excel sheet 2007.

Now I am about to try the same script(that reads xlsx file) on UNIX machine.

I will check it and let you know.

Thanks &...

I have an Excel 2007 excel sheet on windows machine and using
Spreadsheet::XLSX I had written a script to read the excel sheet and was successful.

My requirement is I need to generate another...

Many thanks... It helped me a lot... Thanks once again...

Also one more doubt..
I had a text file which contains the data as below.
Now I need to check only the lines that start with a digit....

There are 2 strings as below.


$str1 = "41148,,,,,,,,,,,,,,,,,,,,,,,,";
$date = "TUE 08-28-2012";


The output should be as below

$str1 = "TUE 08-28-2012,,,,,,,,,,,,,,,,,,,,,,,,";

...

I have a CSV file in the below format.
while generating CSV file from excel sheet , date in excel sheet(Format :Mon 8/28/2012) got converted into the below format with numbers 41148,41149 so on.
...

I am trying to convert xlsx sheet to a csv file.
In .xlsx file there a cell with date

Mon 08/27/12


while reading this cell using Spreadsheet::XLSX, the output is display with numeric value...

Is there any perl module to convert .xlsx file(excel sheet 2007) to a csv file.

While going through the below perl code, there is a line
which contains

$sheet -> {MaxRow} ||= $sheet -> {MinRow};


Could anyone please explain the meaning of ||= and where it is used
...

I have a excel sheet with contains the records as below..
also uploaded the input excelsheet and the output excel sheet(expected output).



322mpls32.net.xyz.comBW: 44.0 M ...

Thanks boss....

But I haven't understood the below line.
Is that any external program(.exe) or any other ?

trace_program=>"tracert"
Could you please explain with the code ?

Thanks once...

Could anyone please help me in sorting this issue or provide me the alternative script?