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

Darryl Collins darryl at whittleconsulting.com.au
Thu Aug 20 19:57:01 CDT 2015


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



More information about the AccessD mailing list