help using split command

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6
help using split command

Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

June 21st, 2003, 01:33 PM

[email protected] chrisangus@btinternet.com is offline

chrisangus@btinternet.com is offline

Authorized User

Join Date: Jun 2003

Posts: 11

Thanks: 0

Thanked 0 Times in 0 Posts

Default

help using split command

Hi I'm using the following split command.

ArrFields(0) = Split(sLine, ",", , vbTextCompare)(0)

Which gives me the data "001"
is it possible to ignore the "
and just get the 001

Thanks

Chris

Old

June 23rd, 2003, 06:38 AM

pgtips

pgtips is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 1,212

Thanks: 0

Thanked 1 Time in 1 Post

Default

Code:

ArrFields(0) = Replace(Split(sLine, ",", , vbTextCompare)(0), """", "")

Old

June 23rd, 2003, 12:28 PM

[email protected] chrisangus@btinternet.com is offline

chrisangus@btinternet.com is offline

Authorized User

Join Date: Jun 2003

Posts: 11

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Thanks for that.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Command text was not set for the command object	Sheraz Khan	Classic ASP Databases	2	May 29th, 2007 12:57 AM
split()	darkhalf	Javascript	1	October 21st, 2005 11:34 AM
Command text was not set for the command object.	deepa12	BOOK: Beginning ASP 3.0	5	November 2nd, 2004 05:37 PM
Split MRU Button (Outlook Command Bars)	Pj	Pro VB 6	0	September 10th, 2003 10:20 PM