Visual Basic/VB, Parsing CSV strings like "Doe, John",33, "6'2"""

Parsing CSV strings like "Doe, John",33, "6'2"""

Author	Message
Dan #1 / 3	Parsing CSV strings like "Doe, John",33, "6'2""" This is a multi-part message in MIME format. ------=_NextPart_000_01BC9377.CEDFDC60 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hello fellow VBers! I needed to parse strings containing a comma delimited variables (quotes around strings). For example, to convert a string like: "Doe, John",33, "6'2""" into an array, such that: Arr(0)= Doe, John Arr(1)= 33 Arr(2)= 6'2" Ok, so I wrote a procedure that does this, and it works. But, the procedure is huge, slow and very ugly. It's so ugly that I feel that I'm overlooking a simpler way to do this. I am wondering if any other coders would care to suggest such a technique? ------=_NextPart_000_01BC9377.CEDFDC60 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <html><head></head><BODY bgcolor=3D"#FFFFFF"><p><font size=3D2 = color=3D"#000000" face=3D"Arial">Hello fellow VBers!<br><br>I needed to = parse strings containing a comma delimited variables (quotes around = strings).<br><br>For example, to convert a string = like:<br> "Doe, John",33, = "6'2"""<br>into an array, such = that:<br> Arr(0)=3D Doe, John<br> Arr(1)=3D = 33<br> Arr(2)=3D 6'2"<br> <br><br>Ok, so I wrote a = procedure that does this, and it works.  But, the procedure is = huge, slow and very ugly.<br><br>It's so ugly that I feel that I'm = overlooking a simpler way to do this.<br><br>I am wondering if any other = coders would care to suggest such a = </font></body></html> ------=_NextPart_000_01BC9377.CEDFDC60--
Tue, 04 Jan 2000 03:00:00 GMT

Chris Spies #2 / 3	Parsing CSV strings like "Doe, John",33, "6'2""" String manipulation, and parsing in particular, is not one of VBs strongest attributes, actually it just as you described it -- slow and ugly. the best solution would be to write a simple C/C++ DLL to pass the delimited string and return an array. VBPJ published an article on this technique a couple of months ago. Hello fellow VBers! I needed to parse strings containing a comma delimited variables (quotes around strings). For example, to convert a string like: "Doe, John",33, "6'2""" into an array, such that: Arr(0)= Doe, John Arr(1)= 33 Arr(2)= 6'2" Ok, so I wrote a procedure that does this, and it works. But, the procedure is huge, slow and very ugly. It's so ugly that I feel that I'm overlooking a simpler way to do this. I am wondering if any other coders would care to suggest such a technique?
Fri, 07 Jan 2000 03:00:00 GMT

Todd Whit #3 / 3	Parsing CSV strings like "Doe, John",33, "6'2""" I do this all the time using Videosoft's VSAwk control - comes with their VSOCX control. Could do it without a control, but this does the job in just a couple lines and I am usually in a hurry. Todd Quote: >I needed to parse strings containing a comma delimited variables (quotes >around strings). >For example, to convert a string like: > "Doe, John",33, "6'2""" >into an array, such that: > Arr(0)= Doe, John > Arr(1)= 33 > Arr(2)= 6'2" >Ok, so I wrote a procedure that does this, and it works. But, the >procedure is huge, slow and very ugly. >It's so ugly that I feel that I'm overlooking a simpler way to do this. >I am wondering if any other coders would care to suggest such a technique?
Fri, 14 Jan 2000 03:00:00 GMT

Page 1 of 1

[ 3 post ]