I have a column of data that I need to parse through to create separate
journal entries.  The data is currently in the below form


=============STAMP: 2004/06/23 14:54:45 MATTHEW
I just called and Confirmed Jane Smiling with Teresa on the 4th.

=============STAMP: 2004/06/22 15:33:37 MATTHEW
Teresa had already filled the need that Denise just called in.

=============STAMP: 2004/06/22 15:09:47 MATTHEW
Denise Hooper called in an ICU need for tonight.
Since there is uniformity for each note, I would think that there is
some way to parse through this and create 3 separate records.  For
example,


NoteDate                    Note
----------------           ---------
2004/06/23 14:54:45         I just called and Confirmed Jane Smiling
with Teresa on the 4th.
2004/06/22 15:33:37         Teresa had already filled the need that
Denise just called in.
2004/06/22 15:09:47         Denise Hooper called in an ICU need for
tonight.


Does anyone have some idea on how I can do this?  I'm stumped.


Thank you,
Kyle
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to