Re: manipulate csv module

Bob Lanteigne wrote:
onlineviewer wrote:

Hello All,

I have a .csv file which has 3 columns of data. Is there a
module that i can use that will allow me to manipulate this file.
Like remove some data from 1 column and add it to another, add
and remove columns etc...

Thanks,


Googling "perl text csv" returns a link to:

Module: Text::CSV

Description:
Text::CSV provides facilities for the composition and decomposition
of
comma-separated values. An instance of the Text::CSV class can
combine
fields into a CSV string and parse a CSV string into fields.
<snip>

Might be a good place to start.


Searching http://search.cpan.org/ for CSV also works.

Tom Wyant
.

Relevant Pages

  • Re: How can I remove leading zeros?
    ... And you can remove the "dim cctr as long", ... create additional CSV files ... 'CREATE A CSV FILE ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.programming)
  • Re: How can I remove leading zeros?
    ... RemoveLeadingZeros = myStr ... create additional CSV files ... 'CREATE A CSV FILE ... Dim myCell As Range ...
    (microsoft.public.excel.programming)
  • Re: How can I remove leading zeros?
    ... Function RemoveLeadingZeros(myStr As String) As String ... create additional CSV files ... 'CREATE A CSV FILE ... Dim myCell As Range ...
    (microsoft.public.excel.programming)
  • Re: How can I remove leading zeros?
    ... RemoveLeadingZeros = myStr ... create additional CSV files ... 'CREATE A CSV FILE ... Dim myCell As Range ...
    (microsoft.public.excel.programming)
  • Re: convert number to text without losing zeroes
    ... I am not opening the .csv file.. ... I believe excel brings each item in as a custom format if it is all numbers, ... in Excel converting it to a number and dropping the zero. ...
    (microsoft.public.excel.misc)