You can use VB to extract the data you want and write the extracted data to a
new text (csv) file. If you only want the extracted data and no changes then
not a problem but if you want to modify the columns then that is another
matter, however if the input data is known then it can bre added whenthe new
file is created.
You be best to hire someone to do the job. I could do it but my rates are
very high.

Look in VB Editor Help for "csv" or "input". All the answers are in VB help.
You could do it yourself.

- -Mark




"RichardOKeefe" wrote:

I'm retrieving data from an Oracle database ino a CSV file so that it can be
manipulated in Excel, saved back to a CSV file and then imported back the
Oracle database. Part of the manipulation is to remove the last couple of
columns which are for display purposes only. The last column left after
deleting the display columns can have null values ie blank cells. My problem
is that when I save the file back to CSV format, rows that end in a blank
column sometimes end with a comma to denote the last blank or null column and
sometimes don't. The ones that are missing the trailing comma don't load
into Oracle properly. They do load into a table becasue Oracle recognises
trailing null columns but I'm loading the last several columns as one to
process them separately It is this process that is failing because rows that
are missing the trailing comma cause a mismatch with the expected number of
columns being loaded back in.

The first row of the CSV file is a set of headers that define the columns in
each row.

Is there some way of getting around this eg cell formatting?

Thanks in advance.