[AccessD] Split with multiple delimiters?

David McAfee davidmcafee at gmail.com
Fri Sep 16 16:12:28 CDT 2016


Thanks, I dodn't think about using REPLACE() inside of the split. :)

Now that I think about it, there is different logic for a couple of the
delimiters, so I guess I still have to run Split() in multiple passes
anyway.  :/

On Fri, Sep 16, 2016 at 11:26 AM, James Button <jamesbutton at blueyonder.co.uk
> wrote:

> 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
>
> --
> 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