[AccessD] Split with multiple delimiters?

James Button jamesbutton at blueyonder.co.uk
Fri Sep 16 13:26:16 CDT 2016


Maybe substitute (all of) one delimiter for the other within the string before
the split.

JimB


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David
McAfee
Sent: Friday, September 16, 2016 5:59 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: [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



More information about the AccessD mailing list