delimiter output has c arriage returns and commas but not consiste

J

Janis

I have a cell with multiple program numbers in it. I have to parse the
program numbers for various functions like checking for duplicates and
sometimes removing one or two programs for a weekly report.

The problem is the output excel sheet from Access comes out with comma
delimiters for the program numbers sometimes and carriage returns. Every
program number is on a separate line in the cell so I guess the delimiter is
the carriage return and somehow the output also sometimes gets a comma from
somewhere.

ie
----
1234,
123245,
123
----
567
8910
1112
---
3489,
5689,

So since I have to loop through this cells to parse the data do I need to
have this delimiter problem fixed? I have trouble accessing the db since it
is another dept.

thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Creating Auto Separation of Numbers thru Defining Delimiter 1
Import a comma delimited file & match records 3
Parsing imported csv data 12
Converting Tab Delimited Text File to A Comma Delimited Text File 1
del comma in excel output, in a split cell, access macro 5
Replacing carriage returns with a comma 5
Comma-delimited text format 9
How change cell to another character, add comma, & continue next c 20

Top