[AccessD] A2003 - Build a List/Array from Tokens in a blurb

[Darryl Collins]

Aaaah, bugger.  Thought I had a easy solution for you..

Are you working with the actual output text (so sans token brackets)?





-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren - Active Billing
Sent: Friday, 21 August 2015 1:06 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003 - Build a List/Array from Tokens in a blurb

Hi Daz,

Thanks for the reply. No, the blurbs are all different about (30 of them) with differing tokens.
Just wanted to know if I could scan each blurb and build a token list from each blurb.


thanks

D

> On 21 Aug 2015, at 10:57 am, Darryl Collins <darryl at whittleconsulting.com.au> wrote:
> 
> If the 'fixed' text is consistent for every entry, I would take the opposite approach and remove it.  Then what you have left is the data you are seeking to extract.
> 
> For example.  First line
> 
> .replace("Dear",vbnullstring)
> 
> And all you have left is the [FirstName]
> 
> Cheers
> Darryl
> 
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren - Active Billing
> Sent: Friday, 21 August 2015 10:35 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] A2003 - Build a List/Array from Tokens in a blurb
> 
> Hi Team
> 
> if I had a field with the following blurb...
> 
> Dear [FirstName],
> Today is [NameOfDay] and the date is the [DateOfMonth] of [NameOfMonth].
> Kind Regards,
> {SignatoryName}
> 
> I can see in that blurb there are 5 tokens surrounded by Square and or Curley brackets.
> How could I run though that text and build a list of the 5 tokens such that I can produce a list/array like...
> 
> [FirstName]
> [NameOfDay] 
> [DateOfMonth]
> [NameOfMonth]
> {SignatoryName}
> 
> Many thanks in advance.
> 
> Darren
> 
> -- 
> 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