How to split the Memo field

[Roy]

Hi All,

I have a table in A2K application.I get a memo field via download from
a .csv file.The contents are as below:

field name is TicketStatus,

For example,a single ticket,TicketID 12345 has a track history
contained in TicketStatus field.It starts right from problem opened
until problem closed with date/time.
Each entry is seperated by a tab delimiter (chr (9)),when it is
imported from the .csv file.

02/01/2007 14:23:35 EDT: Problem Closed.
01/04/2007 09:05:31 EDT: PD Report Published
01/03/2007 17:29:34 EDT: Problem updated.
01/03/2007 12:00:24 EDT: Problem updated.
01/03/2007 11:56:53 EDT: Problem updated.
01/03/2007 10:37:38 EDT: Problem opened.

My problem is how to split each entry so as to show it as

12345 02/01/2007 14:23:35 EDT: Problem Closed.
12345 01/04/2007 09:05:31 EDT: PD Report Published
12345 01/03/2007 17:29:34 EDT: Problem updated.
12345 01/03/2007 12:00:24 EDT: Problem updated.
12345 01/03/2007 11:56:53 EDT: Problem updated.
12345 01/03/2007 10:37:38 EDT: Problem opened.

Thanks in advance,
PG

[storrboy]

On Mar 1, 10:13 pm, "Roy" <[e-mail]:

Hi All,

I have a table in A2K application.I get a memo field via download from
a .csv file.The contents are as below:

field name is TicketStatus,

For example,a single ticket,TicketID 12345 has a track history
contained in TicketStatus field.It starts right from problem opened
until problem closed with date/time.
Each entry is seperated by a tab delimiter (chr (9)),when it is
imported from the .csv file.

02/01/2007 14:23:35 EDT: Problem Closed.
01/04/2007 09:05:31 EDT: PD Report Published
01/03/2007 17:29:34 EDT: Problem updated.
01/03/2007 12:00:24 EDT: Problem updated.
01/03/2007 11:56:53 EDT: Problem updated.
01/03/2007 10:37:38 EDT: Problem opened.

My problem is how to split each entry so as to show it as

12345 02/01/2007 14:23:35 EDT: Problem Closed.
12345 01/04/2007 09:05:31 EDT: PD Report Published
12345 01/03/2007 17:29:34 EDT: Problem updated.
12345 01/03/2007 12:00:24 EDT: Problem updated.
12345 01/03/2007 11:56:53 EDT: Problem updated.
12345 01/03/2007 10:37:38 EDT: Problem opened.

Thanks in advance,
PG

Maybe I'm having a bad day, but I'm confused. Is this all *one* field
in *one* record, or is each line a different record? Is 12345 a
separate field from the problem status?

[salad]

Roy wrote:

Hi All,

I have a table in A2K application.I get a memo field via download from
a .csv file.The contents are as below:

field name is TicketStatus,

For example,a single ticket,TicketID 12345 has a track history
contained in TicketStatus field.It starts right from problem opened
until problem closed with date/time.
Each entry is seperated by a tab delimiter (chr (9)),when it is
imported from the .csv file.

02/01/2007 14:23:35 EDT: Problem Closed.
01/04/2007 09:05:31 EDT: PD Report Published
01/03/2007 17:29:34 EDT: Problem updated.
01/03/2007 12:00:24 EDT: Problem updated.
01/03/2007 11:56:53 EDT: Problem updated.
01/03/2007 10:37:38 EDT: Problem opened.

My problem is how to split each entry so as to show it as

12345 02/01/2007 14:23:35 EDT: Problem Closed.
12345 01/04/2007 09:05:31 EDT: PD Report Published
12345 01/03/2007 17:29:34 EDT: Problem updated.
12345 01/03/2007 12:00:24 EDT: Problem updated.
12345 01/03/2007 11:56:53 EDT: Problem updated.
12345 01/03/2007 10:37:38 EDT: Problem opened.

Thanks in advance,
PG

You can look at Open,Close, Input in help to read/import the data line
by line.

Is the CSV for one record only? If so, you could create a temp table.
Clear out all records and import from the file (see TransferText in
Help) then run an Update on the table and insert the key field then
update the memo field.

It's very possible we don't understand your problem. There's a few
details you left out.

[storrboy]

On Mar 2, 8:57 am, salad <[e-mail]:

Roy wrote:

Hi All,

I have a table in A2K application.I get a memo field via download from
a .csv file.The contents are as below:

field name is TicketStatus,

For example,a single ticket,TicketID 12345 has a track history
contained in TicketStatus field.It starts right from problem opened
until problem closed with date/time.
Each entry is seperated by a tab delimiter (chr (9)),when it is
imported from the .csv file.

02/01/2007 14:23:35 EDT: Problem Closed.
01/04/2007 09:05:31 EDT: PD Report Published
01/03/2007 17:29:34 EDT: Problem updated.
01/03/2007 12:00:24 EDT: Problem updated.
01/03/2007 11:56:53 EDT: Problem updated.
01/03/2007 10:37:38 EDT: Problem opened.

My problem is how to split each entry so as to show it as

12345 02/01/2007 14:23:35 EDT: Problem Closed.
12345 01/04/2007 09:05:31 EDT: PD Report Published
12345 01/03/2007 17:29:34 EDT: Problem updated.
12345 01/03/2007 12:00:24 EDT: Problem updated.
12345 01/03/2007 11:56:53 EDT: Problem updated.
12345 01/03/2007 10:37:38 EDT: Problem opened.

Thanks in advance,
PG

You can look at Open,Close, Input in help to read/import the data line
by line.

Is the CSV for one record only? If so, you could create a temp table.
Clear out all records and import from the file (see TransferText in
Help) then run an Update on the table and insert the key field then
update the memo field.

It's very possible we don't understand your problem. There's a few
details you left out.

If this is from a CSV file and is all one field, unless there is
something wierd about it you should be able to create an import spec
to break this up into individual records in the table, or a different
one if need be. Not sure how you are asociating the TicketID now so I
don't know how you'd apply it if the import worked.