By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,466 Members | 1,148 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,466 IT Pros & Developers. It's quick & easy.

Split function

P: n/a
Hi

Could someone please post a split function to split a string into an array
based on a separator such as comma?

Thanks

Regards
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi John,

Reasonably staright forward:

Dim Arr, TStr as string

TStr ="Here,is,the,string,separated,by,commas"
Arr = Split(Tstr,",")

This won't work with Acc97 only 2000 upwards

HTH
Martin

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:41***********************@news-text.dial.pipex.com...
Hi

Could someone please post a split function to split a string into an array
based on a separator such as comma?

Thanks

Regards

Nov 13 '05 #2

P: n/a
Take a look at these functions on the Access Web:

http://www.mvps.org/access/strings/str0003.htm

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:41***********************@news-text.dial.pipex.com...
Hi

Could someone please post a split function to split a string into an array
based on a separator such as comma?

Thanks

Regards

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.