Search results for query: *

thankyou :-)

Not quite sure what you mean by that-- here is the entire section: while (<FILE>) { $csv->parse($_) or die "parse() failed: " . $csv->error_input(); my @data = $csv->fields(); if ($searchkey <= $#data && $data[$searchkey] =~ m/\Q$searchField\E/) { print "\n\n"...

I am trying to run a loop which ends after it satisfies the If for the first time. I read that you are supposed to use the last command, similar to Break in C#. Can someone perhaps explain why the last is being ignored in this code, and where it should go. THanks! for (my $i=0; $i < $#UndlyPx...

I don't think I have tie::file

it's funny you should mention that, I just figured it out! Thanks for your help. my $x = <STDIN> ; chop $x; in case anyone was interested.

This is my newer version of the code, which does compile: #!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel; use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; $Win32::OLE::Warn = 3; # die on errors... print "Please Enter mSym:" ; my $x...

As of now it doesn't run-- As far as finding a match goes, I need it to ask the user for input, and then go down column C and search for that input, then print out the values in that row in columns J, W, and X... Not exactly sure how to do it.

The file is a regular excel CSV file, with information in many of the columns. Here is the code I have so far, which doesn't work. #!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel; my $FILE = "c/location/Works3.csv"; #my $SHEETNAME = $Book->Worksheets("Works3"); # the column that...

I am trying to write a script which will take the users input, and then look to match that input in a specific column. THen once that input is found in the column, I want the script to print the values of two different cells in that row. For example, if the data is in cell C4, I want the script...

essentially, I need to know how to access the SRC property in line 1, without src being tagged i.e: <src>

Those tutorials are for much more basic XML, I have to do my conversion using a much more sophisticated code. This is a sample of my code, and perhaps someone can show me in this example how it would be converted using XSLT. THANKS! - <MktDataFull src="Information"...

Tom, thanks for your response, however that tutorial is with a semicolon separated file, and using VBA rather than XSLT.

Hey, I have 3 xml files which I need to convert to csv files. I must use XSLT to do this, and apparently accessing xalan from my command prompt is a helpful way to do this. If anyone can please give me some advice / code to point me in the right direction it would be most helpful. Thanks!

In one of my old perl scripts, I pull data from a database, and then load that data into excell. Now, I need to load basically the same info-- all of the columns are the same, however the data in 1 of the columns is different, thus changing the data on the other 3 columns. Essentially, I need...

this is what I have so far, it doesn't work but maybe someone can point me in the right direction: #!/usr/bin/perl -w use strict; use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; $Win32::OLE::Warn = 3; # die on errors... # get already active...

I'm not sure how to go about changing this code so that it looks for specific text.. have been looking and can't find the right code

Well, I have this code that I was using from an old script to remove the first column from a csv file. I figured maybe I could have it look through the rows, and say for example if this cell in column D = "a", then cut it and paste it into another sheet. If not, then continue down the column...

yea I meant that it is a csv file, sorry for the confusion

Hey, I'm trying to get a perl script working which would essentially go down a specific column in my spreadsheet (column D) and, baside on whether the text in the cell is "A" or "B," do something. If the text in the cell is "a" I want to remove the ENTIRE rown from the sheet, and add it to a...

I wrote a perl file which opens up a CSV file and removes the first row of the file, and the last column of the file. What I need to somehow do is save the text from the first row of the file (which I then remove), so as to add it to the top of another sheet in the same workbook. Any ideas...