No problem:
See http://www.contentbox.com/claude/customtags/REextract/test.cfm
And here is the code:
<!--- 1� extract each record into a query --->
<CF_REExtract INPUTMODE="embed"
OUTPUTMODE="query"
OUTPUT="getNews"
RE1="STAMP:[^#chr(13)##chr(10)#]+"
RE2="={13}|$">
=============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.
</CF_REExtract>
<!--- 2� for each record, extract the time stamp from string1 --->
<TABLE BORDER="1">
<TR><TD>Note Date</TD><TD>Note</TD></TR>
<CFOUTPUT QUERY="getNews"><TR>
<TD>#mid (string1, 8, 19)#</TD><TD>#string2#</TD></TR>
</CFOUTPUT>
</TABLE>
Note that if the text to parse is in a file, the call to the tag would just be:
<!--- 1� extract each record into a query --->
<CF_REExtract INPUTMODE="file"
INPUT="fileToParse"
OUTPUTMODE="query"
OUTPUT="getNews"
RE1="STAMP:[^#chr(13)##chr(10)#]+"
RE2="={13}|$" />
<!--- 2� for each record, extract the time stamp from string1 --->
<TABLE BORDER="1">
<TR><TD>Note Date</TD><TD>Note</TD></TR>
<CFOUTPUT QUERY="getNews"><TR>
<TD>#mid (string1, 8, 19)#</TD><TD>#string2#</TD></TR>
</CFOUTPUT>
</TABLE>
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
