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

[Rocky Smolin]

Kostas:

You can't use the split function because the string isn't already delimited.
You need to pass the string to the function, and then in the function loop
through the string character by character,  and using the mid() function
copy each character out to a target string adding a comma every time.  

HTH

Rocky

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

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 

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