[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