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...
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...
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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.