Posted to microsoft.public.excel.programming

external usenet poster

Posts: 8

csv with embedded commas???

I have a csv. There are no text " delimiters. I am trying to validate
the parsing, but within some fields there are embedded commas. This is
in fields that have things like an email where it might say:

2/24/2006,1:23PM,Smith, John ,next field,next
field,etc

I can't seem to figure this out. Can anyone help me to get this to
parse right?

Thank you,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inserting commas	slezama	Excel Discussion (Misc queries)	1	April 18th 09 02:46 PM
So many commas	Alan[_5_]	Excel Worksheet Functions	2	May 24th 07 07:44 PM
removing commas in csv	ziggynorton	Excel Programming	4	June 14th 06 11:09 AM
help commas before data	James	Excel Discussion (Misc queries)	5	March 8th 05 06:25 PM
Replacing Tab with commas	Dan T[_3_]	Excel Programming	1	July 17th 04 10:09 PM

All times are GMT +1. The time now is 07:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us