[AccessD] Split with multiple delimiters?

[Rocky Smolin]

Brilliant!
R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gustav Brock
Sent: Friday, September 16, 2016 10:07 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Split with multiple delimiters?

Hi David

I don't think you can - that's a feature of dotNet.

But perhaps you could first replace the split characters with a single rare
character like "¤", and then use:

    varx = Split("some-Text: like'this","¤")

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af David
McAfee
Sendt: 16. september 2016 18:59
Til: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Emne: [AccessD] Split with multiple delimiters?

Does anyone know of a way to use SPLIT() with multiple delimiters?

Something like varx = Split("some-Text: like'this","-', ")

I don't think I can nest them because of the arrays that they create as the
result.

Thanks,
David 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com