[AccessD] Split with multiple delimiters?

[Gustav Brock]

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