Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: zincyo
- Order by date
-
-
Perl Last Command (Break)
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"... -
Perl Last Command (Break)
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... -
-
Print Cell Value, based on Input
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. -
Print Cell Value, based on Input
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... -
Print Cell Value, based on Input
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. -
Print Cell Value, based on Input
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... -
Print Cell Value, based on Input
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... -
XML to CSV with XSLT
essentially, I need to know how to access the SRC property in line 1, without src being tagged i.e: <src> -
XML to CSV with XSLT
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"... -
XML to CSV with XSLT
Tom, thanks for your response, however that tutorial is with a semicolon separated file, and using VBA rather than XSLT. -
XML to CSV with 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! -
Viewing SQL table
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... -
separate rows based on specific cell text
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... -
separate rows based on specific cell text
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 -
separate rows based on specific cell text
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... -
separate rows based on specific cell text
yea I meant that it is a csv file, sorry for the confusion -
separate rows based on specific cell text
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... -
remove line, save contents
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...
