View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Extract data from csv file

Or it could be that the .csv file is turning out to be close to a fixed field
length file and he means that there's a comma at the 76th and 109th character
position in a record? Definitely needs clarification.

"KC" wrote:

Interesting exercise.
I am guessing that you have one workbook with one worksheet where
A1, B1 only are filled. Nothing further;
Only search in each csv file for 76th and 109th comma,
In what way is the matching done please? as the following 19 positions are
DIGITS only.

"L.Mathe" wrote in message
...
I was looking through this discussion group, found something close to what
I
need, but not being a programmer, I haven't been able to modify it to what
I
am attempting to do and I hope someone can help.

The .csv files are split into groups by month (ie: "c:\Jan\file
name.csv)".
I need to search within the group of csv files and extract data into an
Excel
file. What I would like to do is if Cell A1 in my active wb matches the
data
to the right of the 76 comma in the csv file, extract the 'text' value
(must
be specified as text as this data is a 19 digit number and can't have it
tuncated), in cell A2. Then in cell B2, extract the data that is to the
right of the 109 comma. Continue searching the current file and loop
through
all remaining files, extract subsequent data into the next line below.

Hopefully this is possible and someone can help!

Thanks
--
Linda



.