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

[Paul Hartland]

My approach would be to use a loop using instr to find the sqaure brackets
and pull them out that way, on way to work at moment but if need some code
example i should be able to do something tomorrow
On 21 Aug 2015 04:38, "Darryl Collins" <darryl at whittleconsulting.com.au>
wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>