By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

How to split the Memo field

P: n/a
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

Mar 2 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mar 1, 10:13 pm, "Roy" <praish1...@yahoo.comwrote:
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?
Mar 2 '07 #2

P: n/a
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.
Mar 2 '07 #3

P: n/a
On Mar 2, 8:57 am, salad <o...@vinegar.comwrote:
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.

Mar 3 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.