[AccessD] Extract data from Single field

[David Emerson]

Hi Listers,

I have some data that is currently stored in a single field in the following
format:

[TransactionDate1]:[Merchant1]:[Amount1]:[ARN1]:[Note1];[TransactionDate2]:[
Merchant2]:[Amount2]:[ARN2]:[Note2];etc

The ";" separates records and the ":" separates the data within a record.

Before I start reinventing the wheel, does anyone have a code snippet that
will extract the fields?

Regards
David Emerson
Dalyn Software Ltd
Wellington, New Zealand