[thelist] [ColdFusion] parsing text
Kyle Murphy
kyle.murphy at tempschedulingsystem.com
Thu Jul 1 14:22:08 CDT 2004
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
More information about the thelist
mailing list