RE: finding rows in a large file (22 millions of rows)

2003-02-11 Thread Westgate, Jared
Madhu Reddy Wrote: We are trying to load date into teradata [which is data warehousing, stores Terabytes of data, and which is 10 times faster than any other database..) Data warehousing is always an exciting subject! However, I'd be surprised to see this kind of performance increase. A

RE: Formatting Variables.

2003-02-11 Thread Westgate, Jared
Ramón Chávez wrote: I mean, if I don't want to get printed 3.1415926535 (Or any irrational number) but something like 3.14, is there a way to use format?? I agree with the other posts. Use printf. Here is some more reading, to check out: perldoc -q long decimals perldoc -q round Hope this

RE: still needing help

2003-01-30 Thread Westgate, Jared
Warning: opinionated text follows, so please don't take offense :) stepping onto soapbox whatever it gets text where it needs to go... and if all you need is text the form parser below is fine.. also...if your not offering any real help...maybe you can keep your comments to yourself

RE: how do i get rid of and , chars ??????

2003-01-28 Thread Westgate, Jared
Swami wrote: I am reading a line from a file and splitting it into a 2 dimensional array, this is no probs.. BUT i want to get rid ofand , out of each line - how do i do this ??? You can use the transliteration operator for this. You will have to use the d modifier to tell it to

RE: Getting Perl

2003-01-22 Thread Westgate, Jared
Scott Barnett wrote: Is there a free version of Perl that I can get that will run on Win98 machine. I want to start learning Perl. checked ActiveState but it looks like that is only a 15 or 30 day evaluation, I may be wrong? I assume you want a binary, not the source code? Well, check

RE: Size of number in scalar

2003-01-22 Thread Westgate, Jared
Chris Said: Someone posted a question as to the size of number which a scalar would tolerate. I guess I missed this thread, so I hope I'm not repeating information. :) Perl seems to tolerate quite a bit of this, as the app has been churning away, printing every so many number just to

RE: printing number with commas in it

2003-01-15 Thread Westgate, Jared
Reggie Wrote: I am trying to print a number with commas in it. I cannot find the correct syntax to do this with printf. I considered using the substr function but this depends on mealways knowing the size of the number. Can you help me with this? I like to use the method listed in the

RE: uploading and downloading files to MySQL (--2--)

2003-01-09 Thread Westgate, Jared
Mariusz wrote: What type of field should I use for storing the path; just VARCHAR I guess? And as far as the filenames - make up some random file name for each submitted file? This is a little off topic for a Perl list, but I'll give it a shot. Be forewarned, that I do not know much

RE: Beginners -- a suggestion

2002-11-21 Thread Westgate, Jared
Just to help out Huan Huang below: Huan Huang wrote: I have set up Activeperl in my windows NT system. I have some source file. But I really get no idea how to run the source file. Could anybody give me a go? You basically need to associate the file type with the perl interpreter. I am not

RE: Working with text files.Please help!

2002-11-21 Thread Westgate, Jared
Hey Vitali, I am also a beginner, so I don't know if I am doing everything most efficiently... but, here is what I wrote to do this. I wouldn't normally just write a program for someone, but the problem intrigued me. Take a look through the code and it will hopefully make sense. I hope