Doug - thanks again for the response.

A CSV file means the same thing to me as it does to the rest of world, and
you are correct that I don't actually have "cells", but I thought that using
the "cell" analogy would help explain the task at hand.

Here's an example of what I'm talking about (in csv format):

CSV format:

Order_ID, Customer_Name, Part_Numbers

Sample Data for above format:

"1001", "John Smith", "001" "010" "007"
"1002", "Jill Jones", "031" "002"
"1003", "Bill Williams", "014" "002" "001"

I need to sort the third value (Part_Numbers) so that they appear in
ascending order on my mailmerge document. It would be great if the data
could come to me with either one Part_Number per record (with multiple
records for each order) or with each Part_Number seperated by commas, but the
client is not willing to change this feed (I guess it's used to feed other
programs so they do not want to change anythng for risk of breaking something
else that uses the feed).

Any ideas?

I'm actually thinking about just telling the client that they're out of luck
unless they presort the Part_Numbers during the build of the csv file.

Jon


"Doug Robbins - Word MVP" wrote:

A csv file must mean something different to you than it does to me (and I
think most other people). For starters, it does not contain cells.

A CSV (comma-separated values) file contains the values in a table as a
series of ASCII text lines organized so that each column value is separated
by a comma from the next column's value and each record starts a new line.

Provide an example of the data in the file and we can probably tell you how
to go about it.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP