Search Results

Dear all,

Given that the coordinates of 4 points such as c1(x1,y1), c2(x2,y2), c3(x3,y3), c4(x4,y4).

Does any body know how to use plain sql / plsql to determine coordinates of a point e.g....

since the excel has a lot of formulas, can perl keep all formulas intact? if so, which perl package can do so?

Dear all,

I got a perl script to write some data into an excel file using Spreadsheet::ParseExcel::SaveParser. After that I find all formulas in the excel file are gone.


Does any body...

Dear all,

I got a template excel file which contains several worksheets. Each worksheet contains some formulas in the cells.

I am using the perl script to read a CSV file and then put the data...

HI pravin27 (https://www.unix.com/members/302068616.html)

Since I am newbie in perl, I find that the code above includes
the package
use Spreadsheet::WriteExcel;
As far as I know, the package...

Hi balajesuri , Thank you for your reply,

Actually my requirement is that I want to find a perl scripts which can read a CSV file
with the format
"xxxx","xxxx","xxxx","xxxxx"

and then...

what is purpose of (?: (?=\\.[^\"\\]*))* for the code above

Dear all,

Does any body knows what the following pattern matching means ?
"([^\"\\]*(?:\\.[^\"\\]*)*)",?
| ([^,]+),?
| ,

Dear all,

I find a perl script that contains the following codes. Does anybody know the meaning of codes highlight.

.....
@field = parse_csv($file);
chomp(@field);
........
...........

Dear all

Does anybody know how to pass the password as input parameter to scp or rsync in unix scripts?

I have tried echo <password> | scp filename username@<ip address>:/filepath/ .
But it...

Dear all,

I find a shell script about awk command in the forum regarding
"Find and replace duplicate column values in a row"

In this thread, there is a command line as shown below to replace...

Dear all ,

Can any people explain this awk command?
What is the purpose of if (v[i,$i]++){b[$i]=$i;$i=""}?

awk -F, '{for (i=1;i<=NF;i++){if (v[i,$i]++){b[$i]=$i;$i=""}};print $0} END { print...