[AccessD] how to split text into its letters...

Kostas Konstantinidis kost36 at otenet.gr
Sat Jul 25 13:42:35 CDT 2015


Hi Rocky,
I didn't manage to get syntax info or any example about split() for a 
continuously string without separating points (space, comma, or anything 
familiar)

thank's
/kostas

-----Αρχικό μήνυμα----- 
From: Rocky Smolin
Sent: Saturday, July 25, 2015 8:22 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] how to split text into its letters...

I'd probably write that function in VBA, put it in a Public module, and call
it from the query.

Rocky


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Kostas Konstantinidis
Sent: Saturday, July 25, 2015 10:09 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] how to split text into its letters...

hi,
In a field there text values, something like
1234-5679(1678)68:3;1-
What I need is to split text with every character separate by a comma e.g.
1,2,3,4,-,.......,-

Is that possible via query?

thank's
/kostas

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