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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
truncate fields
Hi all, I have a csv file and I am using the Text::CSV_XS module to parse it. This works fine. However, for a particular column (the 8th one), I need to truncate the field to only having 50 characters. For example, if the field has 90 characters in total, I need to delete everything from the... -
manipulating csv file with perl
I'm sorry I meant to say % in my first specifications. But Thanks!! It works fine! Thanks a lot to all that replied! I really appreciated it. Thanks again. Just wondering, does Perl support Unicode? I've got a couple records that didn't show up at all in the output file. In the input file, the... -
manipulating csv file with perl
Thanks for replying mikevh! Here's what it looks like.... Full Name,Initials,Tax Code,Client ID,Email,Company,Address,Contract Code,Phone Number,Secondary Phone John Smith,J,g50=:x700OHTAX:00029%@JohnSmith;y=80,546728,John.smith@company.com,Company,50 Ford Drive... -
manipulating csv file with perl
Thanks to both KevinADC and mikevh!! However, I ran into a big problem. Some of the fields contain comma and I ran both of your quote and obviously with the split function it splits up the field when it sees the comma and with the CSV_XS module it does the same thing. Please help! Thanks... -
manipulating csv file with perl
wow....thanks a lot! just another question: How can I make the output file name to be in the following format? taxout050505.csv where 050505 is date that the csv file is created in the format ddmmyy Thanks in advance! and Thanks again for all the help -Lory -
manipulating csv file with perl
Hi all, I'm a newbie in using Perl. I've got a csv file that is comma delimited. (Basically, there are 10 fields separated by commas on each line. Each field is a string field.) I need to: 1) get rid of the first line of the input file, the 2nd and 5th field for all the records 2) for the 3rd...
