CFCODER:
You have shown your data two ways, and this impacts any solution that is presented:
Latest:
*** 05/12/2003 09:52:10 USER1 ***
closing if fixed - awaitng response from User2
*** 04/12/2003 18:55:18 USER2 ***
Have been there, however user was on air shortly after, will try again in a bit.
*** 04/12/2003 18:13:22 USER3 ***
Roger that
*** 04/12/2003 18:05:01 USER4 ***
closed
Originally:
*** User1 10/28/2003 2:53:52 ***
THIS IS A TEST
*** User 2 04/06/2003 13:41:47 ***
blah, blah
So which is it?
Also, I may have missed this answer, but it seems to me that the solution is to drop the separate data elements into their own fields in the database IN THE FIRST PLACE. That way they can be queried out, or barring that solution, change the code that writes each entry to include delimiters
e.g.
*** User 2|04/06/2003|13:41:47***blah, blah
And use CR/LF between fields to separate records...
I'm sorry if this doesn't help, but the fact is you are dealing with output that sorely needs to be reformatted to make it easier to process. You shouldn't need anything major to pull it apart.
Thanks,
Robert
P.S. What are the rules for the data that you are pulling apart now?
e.g.
3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 3 asterisks, comment, cr/lf, cr/lf
3 asterisks, space date, 2 spaces, time, 2 spaces, username, 2 spaces, 3 asterisks, comment, cr/lf, cr/lf
etc...
-----Original Message-----
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 8:32 A
To: CF-Talk
Subject: Re: help with string manipulation (Find,Replace)
Pascal, sorry again for being such a PEST. I really do apprecaite your help.
There can be more than one occurance of the timestamp in the comment column. Ex:
*** 05/12/2003 09:52:10 USER1 ***
closing if fixed - awaitng response from User2
*** 04/12/2003 18:55:18 USER2 ***
Have been there, however user was on air shortly after, will try again in a bit.
*** 04/12/2003 18:13:22 USER3 ***
Roger that
*** 04/12/2003 18:05:01 USER4 ***
closed
Can you please add code in your script to handle this and display all timestamps correctly
Many thanks again
cfcoder
>thanks Pascal! It doesn't quite work how I would like it to.
>
>EX: *** 08/12/2003 20:33:31 EDWARI31 ***
>
>You code displays the above timestamp like this:
>
>0 8/12/2003 20:33:31
>
>Where as I would like it to be displayed like this:
>
>EDWARI31 08/12/2003 20:33:31
>
>I dumped stTmp <cfdump var="#stTmp#">. This is what it returns
>
>struct
>LEN
>array
>1 38
>2 2
>3 9
>4 8
>5 11
>
>POS
>array
>1 1
>2 4
>3 6
>4 17
>5 25
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
