[AccessD] Extract data from Single field

[Bill Benson]

What will you do if the Notes contain character like [ or ] or ; or :

?

What mind of delimiter can be counted on with data like that?

[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





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