Getting information from strings

[Andi]

Hi,

I have created a database which takes the audit history of tickets, and
stores it in a memo field.

I have some code which will examine this field to find the first team that a
ticket was assigned to, however I have a requirement to build an "assignment
history".

This history should consist of each team in turn that the ticket was
assigned to, which will be output to a text file (I have written code for
outputting to the file). I have tried using left$ and right$ to no avail,
so any advice I could get would be great.

For information, every time a ticket is assigned, an entry into the audit
history is made like so:

Assigned to Team: Team 1
Assigned to Team: Team 2

etc.

Many thanks in advance of any replies,

Andi

 

[John W. Vinson]

Hi,

I have created a database which takes the audit history of tickets, and
stores it in a memo field.

That's a Very Bad Idea.

You're using a memo field to store multiple records. Memo fields store
freeform text, not records. Fields - even Memo fields - should be atomic,
having only one value.

You'ld be much better off having an AuditHistory table, related one to many to
the tickets table; each record in AuditHistory would refer to one audit. You
could have fields for TeamAssigned, DateAssigned, whatever is relevant.

I have some code which will examine this field to find the first team that a
ticket was assigned to, however I have a requirement to build an "assignment
history".

This history should consist of each team in turn that the ticket was
assigned to, which will be output to a text file (I have written code for
outputting to the file). I have tried using left$ and right$ to no avail,
so any advice I could get would be great.

For information, every time a ticket is assigned, an entry into the audit
history is made like so:

Assigned to Team: Team 1
Assigned to Team: Team 2

It'll be possible to extract this... but *quite* difficult. It might be
easiest to export all the tickets' memo fields, with the ticket number, to a
big external text file, and either import it into a table or write code to
parse it.

John W. Vinson [MVP]