subject:"String manipulation"

cfscript
stTmp =
REFind([*]{3}[[:space:]]+([^*]+)[[:space:]]+[*]{3},str,1,true);
info = Mid(str,stTmp.pos[2],stTmp.len(2);
/cfscript
cfoutputspan class=time#info#/span/cfoutput 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: vrijdag 14 mei 2004 17:07
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 Pascal or anybody who can help!
 
 I'm in a similar problem again and need your help. I'm 
 currently using the code provided by Pascal. The solution to 
 which is mentioned above.
 
 I am pulling the data from the 'comments' column in a 
 database table. The data in the comments column looks like this. 
 
 *** User1 10/28/2003 2:53:52 *** 
 
 THIS IS A TEST
 
 *** User 2 04/06/200313:41:47 *** 
 
 blah, blah
 
 I want to read everything that's between the *** ie *** User 
 1 10/28/2003 2:53:52 *** and display it like this:
 span class=timeUser 1 | 14/4/2004 15:58:15/span THIS IS A TEST
 
 Can somebody please show me how to do this using regular expressions?
 Many thanks
 cf coder
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

Hey Pascal, hope you're doing well buddy! I'm getting an error.

The selected method len was not found.
Either there are no methods with the specified method name and argument types, or the method len is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity.

Any idea why?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

I figured that out.. thanks

cfscript 
stTmp = REFind([*]{3}[[:space:]]+([^*]+)[[:space:]]+[*]{3},str,1,true); 
info = Mid(str,stTmp.pos[2],stTmp.len[2]); 
/cfscript 
span class=timestamp#info#/span

the above code works however I was wondering if you could do me another favour. At the minute you are searching for the ***. Would it be possible to come up with a pattern that finds the three stars, username, date and time?

ex: *** User1 10/28/2003 2:53:52 *** 

Its just so its fool proof. My concern is if the column contains three stars somewhere else in the comments then this code would fail. Are you with me?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

sorry for being such a pest... I forgot to add in my earlier post that the timestamp for all existing comments is in the format:

 *** 10/28/2003 2:53:52 User1 *** 

and the timestamp for new comments is:

 *** User1 10/28/2003 2:53:52 *** 

Can you also show me how to display all existing timestamps in the above format

Many many thanks in advance.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

cfscript
stTmp =
REFind([*]{3}([^*]+)([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space:]]+([0-9]{
1,2}:[0-9]{1,2}:[0-9]{1,2})([^*]+)[*]{3},str,1,true);
user1 = Mid(str,stTmp.pos[2],stTmp.len[2]);
date = Mid(str,stTmp.pos[3],stTmp.len[3]);
time = Mid(str,stTmp.pos[4],stTmp.len[4]);
user2 = Mid(str,stTmp.pos[5],stTmp.len[5]);
if(len(trim(user1))) user = trim(user1);
else if(len(trim(user2))) user = trim(user2);
else user = ;
/cfscript
span class=timestamp#user# #date# #time#/span

It's not full proof, but it should work. 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 13:11
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 sorry for being such a pest... I forgot to add in my earlier 
 post that the timestamp for all existing comments is in the format:
 
*** 10/28/2003 2:53:52 User1 *** 
 
 and the timestamp for new comments is:
 
*** User1 10/28/2003 2:53:52 *** 
 
 Can you also show me how to display all existing timestamps 
 in the above format
 
 Many many thanks in advance.
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

thanks Pascal! It doesn't quite work how I would like it to.

EX: *** 08/12/200320:33:31EDWARI31 ***

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]

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/200309:52:10USER1 ***
closing if fixed - awaitng response from User2

 *** 04/12/200318:55:18USER2 ***
Have been there, however user was on air shortly after, will try again in a bit.

 *** 04/12/200318:13:22USER3 ***
Roger that

 *** 04/12/200318:05:01USER4 ***
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/200320:33:31EDWARI31 ***

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]

RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4

cfscript
start = 1;
aLog = ArrayNew(1);
while(true){
	stTmp =
	
REFind([*]{3}([^*]*[[:space:]])([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space
:]]+([0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2})([[:space:]][^*]*)[*]{3},str,star
t,true);
	if(stTmp.pos[1]){
		stLog = StructNew();
		stLog = StructNew();
		user1 = Mid(str,stTmp.pos[2],stTmp.len[2]);
		stLog.date = Mid(str,stTmp.pos[3],stTmp.len[3]);
		stLog.time = Mid(str,stTmp.pos[4],stTmp.len[4]);
		user2 = Mid(str,stTmp.pos[5],stTmp.len[5]);
		if(len(trim(user1))) stLog.user = trim(user1); 
		else if(len(trim(user2))) stLog.user = trim(user2); 
		else stLog.user = ; 
		stLog.text = ;
		if(ArrayLen(aLog)){
			aLog[ArrayLen(aLog)].text =
Mid(str,start,stTmp.pos[1]-start);
		}
		ArrayAppend(aLog,stLog);
		start = stTmp.pos[1]+stTmp.len[1];
	}
	else{
		if(ArrayLen(aLog)){
			aLog[ArrayLen(aLog)].text =
Trim(Mid(str,start,Len(str)-start));
		}
		break;
	}
}
/cfscript
cfoutput
cfloop from=1 to=#ArrayLen(aLog)# index=i
div class=timestamp#aLog[i].user# #aLog[i].date#
#aLog[i].time#/div
pre#aLog[i].text#/pre
/cfloop
/cfoutput

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 14:32
 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/200309:52:10USER1 ***
 closing if fixed - awaitng response from User2
 
*** 04/12/200318:55:18USER2 ***
 Have been there, however user was on air shortly after, will 
 try again in a bit.
 
*** 04/12/200318:13:22USER3 ***
 Roger that
 
*** 04/12/200318:05:01USER4 ***
 closed
 
 Can you please add code in your script to handle this and 
 display all timestamps correctly
 
 Many thanks again
 cfcoder

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

Pascal,

I may have missed the answer to this question, but is the content that we are looking at a query record set (multiple records), or is it from like a flat file, where the content is just appended?

It seems like all of these solutions are overly complex.It seems like such a simple problem to resolve.

Thanks,
Robert

-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 10:15 A
To: CF-Talk
Subject: RE: help with string manipulation (Find,Replace)

cfscript
start = 1;
aLog = ArrayNew(1);
while(true){
	stTmp =
	
REFind([*]{3}([^*]*[[:space:]])([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space
:]]+([0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2})([[:space:]][^*]*)[*]{3},str,star
t,true);
	if(stTmp.pos[1]){
		stLog = StructNew();
		stLog = StructNew();
		user1 = Mid(str,stTmp.pos[2],stTmp.len[2]);
		stLog.date = Mid(str,stTmp.pos[3],stTmp.len[3]);
		stLog.time = Mid(str,stTmp.pos[4],stTmp.len[4]);
		user2 = Mid(str,stTmp.pos[5],stTmp.len[5]);
		if(len(trim(user1))) stLog.user = trim(user1); 
		else if(len(trim(user2))) stLog.user = trim(user2); 
		else stLog.user = ; 
		stLog.text = ;
		if(ArrayLen(aLog)){
			aLog[ArrayLen(aLog)].text =
Mid(str,start,stTmp.pos[1]-start);
		}
		ArrayAppend(aLog,stLog);
		start = stTmp.pos[1]+stTmp.len[1];
	}
	else{
		if(ArrayLen(aLog)){
			aLog[ArrayLen(aLog)].text =
Trim(Mid(str,start,Len(str)-start));
		}
		break;
	}
}
/cfscript
cfoutput
cfloop from=1 to=#ArrayLen(aLog)# index=i
div class=timestamp#aLog[i].user# #aLog[i].date#
#aLog[i].time#/div
pre#aLog[i].text#/pre
/cfloop
/cfoutput

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 14:32
 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/200309:52:10USER1 ***
 closing if fixed - awaitng response from User2
 
*** 04/12/200318:55:18USER2 ***
 Have been there, however user was on air shortly after, will 
 try again in a bit.
 
*** 04/12/200318:13:22USER3 ***
 Roger that
 
*** 04/12/200318:05:01USER4 ***
 closed
 
 Can you please add code in your script to handle this and 
 display all timestamps correctly
 
 Many thanks again
 cfcoder

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

2004-05-17 Thread Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4

It's like a flat file. (a huge comment field in the DB).
Storing the comments in a related table would have made his life easier,
but I don't think he can change the way the data is stored.

 -Original Message-
 From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4 
 [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 16:37
 To: CF-Talk
 Subject: RE: help with string manipulation (Find,Replace)

 Pascal,

 I may have missed the answer to this question, but is the 
 content that we are looking at a query record set (multiple 
 records), or is it from like a flat file, where the content 
 is just appended?

 It seems like all of these solutions are overly complex.It 
 seems like such a simple problem to resolve.

 Thanks,
 Robert
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

My bad, I responded to Pascal earlier... Sorry about that.

CFCODER:

You have shown your data two ways, and this impacts any solution that is presented:

Latest: 
*** 05/12/200309:52:10USER1 ***
closing if fixed - awaitng response from User2

 *** 04/12/200318:55:18USER2 ***
Have been there, however user was on air shortly after, will try again in a bit.

 *** 04/12/200318:13:22USER3 ***
Roger that

 *** 04/12/200318:05:01USER4 ***
closed

Originally:

*** User1 10/28/2003 2:53:52 *** 

 
THIS IS A TEST

 
*** User 2 04/06/200313: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/200309:52:10USER1 ***
closing if fixed - awaitng response from User2

 *** 04/12/200318:55:18USER2 ***
Have been there, however user was on air shortly after, will try again in a bit.

 *** 04/12/200318:13:22USER3 ***
Roger that

 *** 04/12/200318:05:01USER4 ***
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/200320:33:31EDWARI31 ***

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]

Re: help with string manipulation (Find,Replace)

You are a GENIUS man! That code rocks, I wouldn't know how to do this without your help. You are a star. Just one small problem, the comments column sometimes doesn't store the timestamp. I went through your code. The while condition in the above mentioned situation would be false so the code in the else part would be executed. 

if(ArrayLen(aLog)){ 
aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start)); 
}

The above condition would be false. I added a 'else' condition and want to assign 'str' to aLog[ArrayLen(aLog)].text.

something like this:

if(ArrayLen(aLog)){ 
aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start)); 
}
else
{
'What should I be doing here?'
}
break;

Many thanks again!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

If your format isn't always the same (*** user timestamp *** OR ***
timestamp user ***) you can't use my code. You need to do it in a
different way. I can help if you want, but if you keep changing the
specs it's not very easy. Also, remind me what version you are on. I'm
writing CF5 regexp for the moment, but this is easier in CFMX.

Pascal 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 16:55
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 You are a GENIUS man! That code rocks, I wouldn't know how to 
 do this without your help. You are a star. Just one small 
 problem, the comments column sometimes doesn't store the 
 timestamp. I went through your code. The while condition in 
 the above mentioned situation would be false so the code in 
 the else part would be executed. 
 
 if(ArrayLen(aLog)){
 aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start));
 }
 
 The above condition would be false. I added a 'else' 
 condition and want to assign 'str' to aLog[ArrayLen(aLog)].text.
 
 something like this:
 
 if(ArrayLen(aLog)){
 aLog[ArrayLen(aLog)].text = Trim(Mid(str,start,Len(str2)-start));
 }
 else
 {
'What should I be doing here?'
 }
 break;
 
 Many thanks again!
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

Hi Robert,

apologies for causing any confusion. I was asked to present the data stored in the database table column in a certain way. Historically data stored in this column is as under:

timestamp
comments

EX:

*** 05/12/2003 09:52:10 USER1 ***
closing if fixed - awaitng response from User2

I was asked to get rid of the stars and reorder the timestamp to something like this:

USER1 05/12/2003 09:52:10
(Username, Date, Time)

All comments (timestamps) added henceforth will be added in this fashion.
I hope this gives you a better understanding. The solution Pascal provided does just that and it does the job for me.

Best Regards,
cfcoder

My bad, I responded to Pascal earlier... Sorry about that.

CFCODER:

You have shown your data two ways, and this impacts any solution that
is presented:

Latest:
*** 05/12/200309:52:10USER1 ***
closing if fixed - awaitng response from User2

*** 04/12/200318:55:18USER2 ***
Have been there, however user was on air shortly after, will try again
in a bit.

*** 04/12/200318:13:22USER3 ***
Roger that

*** 04/12/200318:05:01USER4 ***
closed

Originally:

*** User1 10/28/2003 2:53:52 ***

THIS IS A TEST

*** User 2 04/06/200313: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/200309:52:10USER1 ***
closing if fixed - awaitng response from User2

*** 04/12/200318:55:18USER2 ***
Have been there, however user was on air shortly after, will try again
in a bit.

*** 04/12/200318:13:22USER3 ***
Roger that

*** 04/12/200318:05:01USER4 ***
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/200320:33:31EDWARI31 ***

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]

Re: help with string manipulation (Find,Replace)

sorry Pascal, my bad. The format is not always the same, there may be few comments in the database without the timestamp. All comments added when I build the functionality will not have the *** user timestamp ***. I have CFMX installed on the server.

Best regards,
cfcoder

If your format isn't always the same (*** user timestamp *** OR ***
timestamp user ***) you can't use my code. You need to do it in a
different way. I can help if you want, but if you keep changing the
specs it's not very easy. Also, remind me what version you are on. I'm
writing CF5 regexp for the moment, but this is easier in CFMX.

Pascal 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

I'm off to home right now, but I'll send you the code in the morning
(for me GMT+2) 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 17 mei 2004 17:15
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)

 sorry Pascal, my bad. The format is not always the same, 
 there may be few comments in the database without the 
 timestamp. All comments added when I build the functionality 
 will not have the *** user timestamp ***. I have CFMX 
 installed on the server.

 Best regards,
 cfcoder

 If your format isn't always the same (*** user timestamp *** OR *** 
 timestamp user ***) you can't use my code. You need to do it in a 
 different way. I can help if you want, but if you keep changing the 
 specs it's not very easy. Also, remind me what version you 
 are on. I'm 
 writing CF5 regexp for the moment, but this is easier in CFMX.

 Pascal

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

Thanks Pascal. Sorry again for any inconvenience caused.

Best regards
cfcoder

I'm off to home right now, but I'll send you the code in the morning
(for me GMT+2) 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

2004-05-14 Thread cf coder

Pascal or anybody who can help!

I'm in a similar problem again and need your help. I'm currently using the code provided by Pascal. The solution to which is mentioned above.

I am pulling the data from the 'comments' column in a database table. The data in the comments column looks like this. 

*** User1 10/28/2003 2:53:52 *** 

THIS IS A TEST

*** User 2 04/06/200313:41:47 *** 

blah, blah

I want to read everything that's between the *** ie *** User 1 10/28/2003 2:53:52 ***
and display it like this:
span class=timeUser 1 | 14/4/2004 15:58:15/span
THIS IS A TEST

Can somebody please show me how to do this using regular expressions?
Many thanks
cf coder
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

2004-04-01 Thread cf coder

Sweet! You are a genius! I can never get my head round regular expressions.
I don't have a clue what this is actually doing

regexp = ^\s*([*]{3}.+?[*]{3}.+?)\s*(?:[*]{3}.*)?$;
str2 = REReplace(str,regexp,\1);

Can you kindly explain it to me because I have to explain it to my colleague and not look like a fool. Thanks Pascal

cfsavecontent variable=str
*** 13/01/200309:47:06TUser1 ***
callno:1126
Some comment1 

*** 13/01/200308:30:27TUser2 ***
Some Comment2 

/cfsavecontent
cfscript
regexp = ^\s*([*]{3}.+?[*]{3}.+?)\s*(?:[*]{3}.*)?$;
str2 = REReplace(str,regexp,\1);
/cfscript
cfoutputpre#str2#/pre/cfoutput

This returns the first comment with the datetime  user info. If you
want it without that info the regexp should be

^\s*[*]{3}.+?[*]{3}(.+?)\s*(?:[*]{3}.*)?$

Watch out for wrapping. There are no spaces in the regexp.

Pascal 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

2004-04-01 Thread Pascal Peters

^		start of string
\s*		any number of whitespace (spaces, tabs, newlines,...)
(		start group (for back reference)
[*]{3}	three stars
.+?		one or more characters (non greedy match: untill first
match of what comes next)
[*]{3}	three stars 
.+?		one or more characters (non greedy match: untill first
match of what comes next)
)		end group
\s*		any number of whitespace (spaces, tabs, newlines,...)
(?:[*]{3}.*)? optional group not included in backreference: three stars
followed by any number of characters
$		end of string

\1	backreference to match for first group ([*]{3}.+?[*]{3}.+?)

Pascal

PS If you don't understand the difference between greedy and non greedy
matches, try doing the same on a string with 2 or more comments using .+
instead of .+?

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: donderdag 1 april 2004 11:56
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 Sweet! You are a genius! I can never get my head round 
 regular expressions.
 I don't have a clue what this is actually doing
 
 regexp = ^\s*([*]{3}.+?[*]{3}.+?)\s*(?:[*]{3}.*)?$;
 str2 = REReplace(str,regexp,\1);
 
 Can you kindly explain it to me because I have to explain it 
 to my colleague and not look like a fool. Thanks Pascal
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

2004-04-01 Thread cf coder

thanks Pascal that explaination makes perfect sense and I understand it. Thanks again for all your help.

Best Regards,
cfcoder
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

2004-03-31 Thread cf coder

Hi Pascal, I'm really sorry for not getting back to you yesterday. I've been asked to work on something else.

I'm trying to display the comment properly and need your help. I want to display the top most comment from the comments table. Here is an example. In the example below there are 2 comments 

*** 13/01/200309:47:06TUser1 ***
callno:1126
Some comment1

*** 13/01/200308:30:27TUser2 ***
Some Comment2

I want to display the top most comment. In this case

*** 13/01/200309:47:06TUser1 ***
callno:1126
Some comment1

All comments have the ***, date time and user information
*** 13/01/200309:47:06TUser1 ***

I would really apprecaite your help.
Best Regards,
cfcoder
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

2004-03-31 Thread Pascal Peters

cfsavecontent variable=str
*** 13/01/200309:47:06TUser1 ***
callno:1126
Some comment1 

*** 13/01/200308:30:27TUser2 ***
Some Comment2 

/cfsavecontent
cfscript
regexp = ^\s*([*]{3}.+?[*]{3}.+?)\s*(?:[*]{3}.*)?$;
str2 = REReplace(str,regexp,\1);
/cfscript
cfoutputpre#str2#/pre/cfoutput

This returns the first comment with the datetime  user info. If you
want it without that info the regexp should be

^\s*[*]{3}.+?[*]{3}(.+?)\s*(?:[*]{3}.*)?$

Watch out for wrapping. There are no spaces in the regexp.

Pascal 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: woensdag 31 maart 2004 16:55
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 Hi Pascal, I'm really sorry for not getting back to you 
 yesterday. I've been asked to work on something else.
 
 I'm trying to display the comment properly and need your 
 help. I want to display the top most comment from the 
 comments table. Here is an example. In the example below 
 there are 2 comments 
 
 *** 13/01/200309:47:06TUser1 ***
 callno:1126
 Some comment1
 
 *** 13/01/200308:30:27TUser2 ***
 Some Comment2
 
 I want to display the top most comment. In this case
 
 *** 13/01/200309:47:06TUser1 ***
 callno:1126
 Some comment1
 
 All comments have the ***, date time and user information
 *** 13/01/200309:47:06TUser1 ***
 
 I would really apprecaite your help.
 Best Regards,
 cfcoder
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

2004-03-30 Thread cf coder

Thank you pascal, the code works just the way I want it to. here it is:

cfif Find('#Chr(13)#',qResults.Slug)
cfset tmp=REReplaceNoCase(qResults.Slug,'^[^a-z0-9_]*([a-z0-9_])','\1') 
cfif Find('***',tmp) and trim(Left(tmp,Find('***',tmp)-1)) neq 
 cfset str = REReplace(qResults.Slug,^\s*([*]{3}.*?[*]{3})?\s*,)
 cfset str = REReplace(str,^(.*?)\s*[*]{3}.*$,\1)
 #str#
cfelseif trim(Left(tmp,Find('#Chr(13)#',tmp))) neq 
 #trim(Left(tmp,Find('#Chr(13)#',tmp)))#
cfelse
#tmp#
/cfif
/cfif

I need your help with something else. This is not related to my original query, but related. When the comment field data is displayed in a text area, it looses the new line character. Don't know why. Here is an example.

MOVE FOLDER *** 04/06/200313:41:47 *** blah, blah *** 04/06/20032:33:5

When I want display it like this:

MOVE FOLDER

*** 04/06/200313:41:47 ***

blah, blah

*** 04/06/200312:33:5

Can you show me how to do this please.
Best Regards,
cfcoder

On CFMX only

// replaces whitespace and date/time before first comment
str = REReplace(str,^\s*([*]{3}.*?[*]{3})?\s*,);
// Replaces everything starting from next ***
str = REReplace(str,^(.*?)\s*[*]{3}.*$,\1);

NOT tested, I don't have CFMX running at the moment

Pascal


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

2004-03-30 Thread Tangorre, Michael

#ParagraphFormat(variable)#

Mike

 I need your help with something else. This is not related to 
 my original query, but related. When the comment field data 
 is displayed in a text area, it looses the new line 
 character. Don't know why. Here is an example.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

2004-03-30 Thread Pascal Peters

Actually, those 2 lines were meant to replace the cfif's too. You can
replace the whole block by my code (but test it anyway!!).

For your other problem, I see two possibilities:
1. You are using HTMLEditFormat() to display in the textarea. It
replaces CR/LF. Just create a UDF that replaces ,,, and use that
instead (be sure to replace  first).
2. There is no LF (chr(10)) in your code and that is why it doesn't
show.

THT
Pascal

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: dinsdag 30 maart 2004 12:48
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 Thank you pascal, the code works just the way I want it to. 
 here it is:
 
 cfif Find('#Chr(13)#',qResults.Slug)
cfset 
 tmp=REReplaceNoCase(qResults.Slug,'^[^a-z0-9_]*([a-z0-9_])','\1')
cfif Find('***',tmp) and trim(Left(tmp,Find('***',tmp)-1)) neq 
cfset str = 
 REReplace(qResults.Slug,^\s*([*]{3}.*?[*]{3})?\s*,)
cfset str = REReplace(str,^(.*?)\s*[*]{3}.*$,\1)
#str#
cfelseif trim(Left(tmp,Find('#Chr(13)#',tmp))) neq 
#trim(Left(tmp,Find('#Chr(13)#',tmp)))#
cfelse
 #tmp#
/cfif
 /cfif
 
 
 I need your help with something else. This is not related to 
 my original query, but related. When the comment field data 
 is displayed in a text area, it looses the new line 
 character. Don't know why. Here is an example.
 
 MOVE FOLDER *** 04/06/200313:41:47 *** blah, blah *** 
 04/06/20032:33:5
 
 When I want display it like this:
 
 MOVE FOLDER
 
 *** 04/06/200313:41:47 ***
 
 blah, blah
 
 *** 04/06/200312:33:5
 
 Can you show me how to do this please.
 Best Regards,
 cfcoder
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

2004-03-30 Thread Pascal Peters

This is for display in HTML, not in a textarea. The p tags would show
and everything would be on one line 

 -Original Message-
 From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
 Sent: dinsdag 30 maart 2004 14:22
 To: CF-Talk
 Subject: RE: help with string manipulation (Find,Replace)

 #ParagraphFormat(variable)#

 Mike

  I need your help with something else. This is not related to my 
  original query, but related. When the comment field data is 
 displayed 
  in a text area, it looses the new line character. Don't 
 know why. Here 
  is an example.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

2004-03-30 Thread cf coder

can you show me how to do this?

This is for display in HTML, not in a textarea. The p tags would show
and everything would be on one line 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

2004-03-30 Thread Pascal Peters

To do what? Show me the code of your textarea and any code manipulating
the string you display in it and I will try to give you the solution

Pascal 

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: dinsdag 30 maart 2004 14:23
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)

 can you show me how to do this?

 This is for display in HTML, not in a textarea. The p tags 
 would show 
 and everything would be on one line

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

help with string manipulation (Find,Replace)

2004-03-29 Thread cf coder

I've tried hard to find a solution to my problem but
have had no luck.

I am pulling the data from the 'comments' column in a
database table. The data in the comments column looks
like this.

TEST - CLOSE CALL

*** 10/28/2003 2:53:52 ***

THIS IS A TEST- PLEASE CLOSE CALL

*** 04/06/200312:33:5
I want to only display the first comment, in this case
TEST - CLOSE CALL. I am able to do this.
Here is the code I've written to display the first
comment. 
#Left(qResults.Slug,Find('#Chr(13)#',qResults.Slug))#
The above code searches for a new line in the comment
column and displays everything before the new line.

The problem I'm having is looking for the first
comment (top-most comment) when the data stored in the
column begins with a new line




MOVE FOLDER

*** 04/06/200313:41:47 ***

blah, blah

*** 04/06/200312:33:5

As shown in the above example, there a number of new
line characters before the first comment (Move
Folder).

I don't know how to approach this problem, I want to
replace all new line characters before the first
occurance of a character between a-z. Can someone
please show me how to do this please

Cheers,
cfcoder

__
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

2004-03-29 Thread Yalta Classen

OK, just do something like
cfset sTmp=REReplaceNoCase(qResults.Slug,'^[^a-z0-9_]*([a-z0-9_])','\1'
to get rid of all leading characters you do not want, and then use sTmp for you Find. 

Just a few remarks:
'^[^a-z0-9_]*([a-z0-9_])' means
First ^- Start at the start of the string only
[] one of those inside, with the second ^ - one of those NOT inside
* - repeated 0 to x times
() take everything inside and remember it - for a back reference \1 later
The () has to be used to make sure that all leading whitespace is removed (ad consequently, you need a back reference later)

 
You might want to experiment using a different collection of excluded/included chars. There is for example \s for whitespace, \S for non-whitespace, but my experiments with those CF-specific character class definitions were never too lucky, so I prefer enumerating the characters I want/don't want.

Yalta
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: help with string manipulation (Find,Replace)

2004-03-29 Thread cf coder

Many Thanks Yalta for your help. Your code is good but there it does handle the comments column properly if the comments column has the following data:

*** 09/05/200218:46:21 ***
Closing as no point to this log
Hot Swap
*** 17/04/200213:08:15***
OK can ayone tell me where the Request for the replacement PC is. 

I want to display the string Closing as no point to this log
Hot Swap whereas if I use your code, the string that's displayed is:
 09/05/2002 18:46:21 

This is my code:

cfif Find('#Chr(13)#',qResults.Slug)
cfset tmp=REReplaceNoCase(qResults.Slug,'^[^a-z0-9_]*([a-z0-9_])','\1') 
cfif Find('***',tmp) and trim(Left(tmp,Find('***',tmp)-1)) neq 
	#trim(Left(tmp,Find('***',tmp)-1))#
cfelseif trim(Left(tmp,Find('#Chr(13)#',tmp))) neq 
	#trim(Left(tmp,Find('#Chr(13)#',tmp)))#
cfelse
	#tmp#
/cfif
/cfif

 OK, just do something like
 cfset sTmp=REReplaceNoCase(qResults.Slug,'^[^a-z0-9_]*([a-z0-9_])',
 '\1'
 to get rid of all leading characters you do not want, and then use 
 sTmp for you Find. 
 
 Just a few remarks:
 '^[^a-z0-9_]*([a-z0-9_])' means
 First ^- Start at the start of the string only
 [] one of those inside, with the second ^ - one of those NOT inside
 * - repeated 0 to x times
 () take everything inside and remember it - for a back reference \1 
 later
 The () has to be used to make sure that all leading whitespace is 
 removed (ad consequently, you need a back reference later)

 
 
 You might want to experiment using a different collection of 
 excluded/included chars. There is for example \s for whitespace, \S 
 for non-whitespace, but my experiments with those CF-specific 
 character class definitions were never too lucky, so I prefer 
 enumerating the characters I want/don't want.
 
Yalta
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: help with string manipulation (Find,Replace)

2004-03-29 Thread Pascal Peters

On CFMX only

// replaces whitespace and date/time before first comment
str = REReplace(str,^\s*([*]{3}.*?[*]{3})?\s*,);
// Replaces everything starting from next ***
str = REReplace(str,^(.*?)\s*[*]{3}.*$,\1);

NOT tested, I don't have CFMX running at the moment

Pascal

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED] 
 Sent: maandag 29 maart 2004 13:57
 To: CF-Talk
 Subject: Re: help with string manipulation (Find,Replace)
 
 Many Thanks Yalta for your help. Your code is good but there 
 it does handle the comments column properly if the comments 
 column has the following data:
 
 
 
 *** 09/05/200218:46:21 ***
 Closing as no point to this log
 Hot Swap
 *** 17/04/200213:08:15***
 OK can ayone tell me where the Request for the replacement PC is. 
 
 
 I want to display the string Closing as no point to this log 
 Hot Swap whereas if I use your code, the string that's displayed is:
  09/05/2002 18:46:21 
 
 This is my code:
 
 cfif Find('#Chr(13)#',qResults.Slug)
 cfset 
 tmp=REReplaceNoCase(qResults.Slug,'^[^a-z0-9_]*([a-z0-9_])','\1')
 cfif Find('***',tmp) and trim(Left(tmp,Find('***',tmp)-1)) neq 
 	#trim(Left(tmp,Find('***',tmp)-1))#
 cfelseif trim(Left(tmp,Find('#Chr(13)#',tmp))) neq 
 	#trim(Left(tmp,Find('#Chr(13)#',tmp)))#
 cfelse
 	#tmp#
 /cfif
 /cfif
 
 
 
  OK, just do something like
  cfset sTmp=REReplaceNoCase(qResults.Slug,'^[^a-z0-9_]*([a-z0-9_])',
  '\1'
  to get rid of all leading characters you do not want, and then use 
  sTmp for you Find. 
  
  Just a few remarks:
  '^[^a-z0-9_]*([a-z0-9_])' means
  First ^- Start at the start of the string only
  [] one of those inside, with the second ^ - one of those NOT inside
  * - repeated 0 to x times
  () take everything inside and remember it - for a back reference \1 
  later
  The () has to be used to make sure that all leading whitespace is 
  removed (ad consequently, you need a back reference later)

  
  You might want to experiment using a different collection of 
  excluded/included chars. There is for example \s for whitespace, \S 
  for non-whitespace, but my experiments with those CF-specific 
  character class definitions were never too lucky, so I prefer 
  enumerating the characters I want/don't want.
  
 Yalta
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: More string manipulation questions

2002-12-11 Thread webguy

Why not just send the FOCode to the next page and lookup the other values?

Anyway your error 
I'm guessing that there empty line.

cftry
cfset strFOCode = #trim(listGetAt(strFO,1))#
cfset strFOEmail = #trim(listGetAt(strFO,2))#
cfset strFOName = #trim(listGetAt(strFO,3))#

cfcatch type=any
bad string :#fieldofficelist[idxLine]#  
/cfcatch
/cftry

WG

 The output I get does list properly all records but also gives me 
 the following error:
 errormessage
 Error Diagnostic Information
 
 An error occurred while evaluating the expression:
 
 strFOCode = #trim(listGetAt(strFO,1))#
 
 Error near line 36, column 7.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: More string manipulation questions

2002-12-11 Thread Mitko Gerensky-Greene

Here is the full error message (I am not sure why it got cut before):

Error Occurred While Processing Request
Error Diagnostic Information

An error occurred while evaluating the expression: 


 strFOCode = #trim(listGetAt(strFO,1))#



Error near line 36, column 7.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: More string manipulation questions

2002-12-11 Thread Mitko Gerensky-Greene

Thanks! This did catch that there was a blank line at the bottom of the text file!
Mitko
-- Original Message --
from: webguy [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Wed, 11 Dec 2002 18:29:28 -

Why not just send the FOCode to the next page and lookup the other values?

Anyway your error 
I'm guessing that there empty line.

cftry
   cfset strFOCode = #trim(listGetAt(strFO,1))#
   cfset strFOEmail = #trim(listGetAt(strFO,2))#
   cfset strFOName = #trim(listGetAt(strFO,3))#

   cfcatch type=any
   bad string :#fieldofficelist[idxLine]#  
   /cfcatch
/cftry

WG

 The output I get does list properly all records but also gives me 
 the following error:
 errormessage
 Error Diagnostic Information
 
 An error occurred while evaluating the expression:
 
 strFOCode = #trim(listGetAt(strFO,1))#
 
 Error near line 36, column 7.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

String Manipulation troubles


Why doesn't this cfif statement catch the ] character?

Or a better question is How do i branch on that character... chr(93) doesn't work 
either.

cfset temp = ]

cfoutputbrtemp = #temp#br/cfoutput

cfif temp IS ]
cfoutputbrtemp = #temp#br/cfoutput Yep It Works!
/cfif

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: String Manipulation troubles

2002-06-26 Thread Clint Tredway


First off,trim your var in the if statement and then change the IS to eq. I have 
had this problem before and by always trimming my vars and using eq instead of is, I 
have had far less problems like this.

HTH
Clint

-- Original Message --
from: Brian Scandale [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Wed, 26 Jun 2002 00:49:35 -0700

Why doesn't this cfif statement catch the ] character?

Or a better question is How do i branch on that character... chr(93) doesn't work 
either.

cfset temp = ]

cfoutputbrtemp = #temp#br/cfoutput

cfif temp IS ]
cfoutputbrtemp = #temp#br/cfoutput Yep It Works!
/cfif


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: String Manipulation troubles

2002-06-26 Thread Jerry Johnson


Just to make sure it was an email-only typo

You did not close the cfset tag with a 

Jerry Johnson

 [EMAIL PROTECTED] 06/26/02 11:09AM 
First off,trim your var in the if statement and then change the IS to eq. I have 
had this problem before and by always trimming my vars and using eq instead of is, I 
have had far less problems like this.

HTH
Clint

-- Original Message --
from: Brian Scandale [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED] 
date: Wed, 26 Jun 2002 00:49:35 -0700

Why doesn't this cfif statement catch the ] character?

Or a better question is How do i branch on that character... chr(93) doesn't work 
either.

cfset temp = ]

cfoutputbrtemp = #temp#br/cfoutput

cfif temp IS ]
cfoutputbrtemp = #temp#br/cfoutput Yep It Works!
/cfif



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: String Manipulation troubles

2002-06-26 Thread Adrian Lynch

It works for me 

Ade

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 26 June 2002 08:50
To: CF-Talk
Subject: String Manipulation troubles

Why doesn't this cfif statement catch the ] character?

Or a better question is How do i branch on that character... chr(93) doesn't
work either.

cfset temp = ]

cfoutputbrtemp = #temp#br/cfoutput

cfif temp IS ]
cfoutputbrtemp = #temp#br/cfoutput Yep It Works!
/cfif

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: String Manipulation troubles


Tried it Clint, see below... It does NOT test True for the Square Bracket.
Does this have something to do with Regular Expressions?
What's the proper way to test for the ] character?

cfset temp = ]
cfoutputbrtemp = #temp#br/cfoutput
cfif trim(temp) EQ ] 
cfoutputbrtemp = #temp#br/cfoutput Yep It Works! 
/cfif


At 08:09 AM 6/26/02, you wrote:
First off,trim your var in the if statement and then change the IS to eq. I have 
had this problem before and by always trimming my vars and using eq instead of is, I 
have had far less problems like this.

HTH
Clint

-- Original Message --
from: Brian Scandale [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Wed, 26 Jun 2002 00:49:35 -0700

Why doesn't this cfif statement catch the ] character?

Or a better question is How do i branch on that character... chr(93) doesn't work 
either.

cfset temp = ]

cfoutputbrtemp = #temp#br/cfoutput

cfif temp IS ]
cfoutputbrtemp = #temp#br/cfoutput Yep It Works!
/cfif



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: String Manipulation troubles


Right... an email typo indeed ;-(

At 09:01 AM 6/26/02, you wrote:
Just to make sure it was an email-only typo

You did not close the cfset tag with a 

Jerry Johnson

 [EMAIL PROTECTED] 06/26/02 11:09AM 
First off,trim your var in the if statement and then change the IS to eq. I have 
had this problem before and by always trimming my vars and using eq instead of is, I 
have had far less problems like this.

HTH
Clint

-- Original Message --
from: Brian Scandale [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED] 
date: Wed, 26 Jun 2002 00:49:35 -0700

Why doesn't this cfif statement catch the ] character?

Or a better question is How do i branch on that character... chr(93) doesn't work 
either.

cfset temp = ]

cfoutputbrtemp = #temp#br/cfoutput

cfif temp IS ]
cfoutputbrtemp = #temp#br/cfoutput Yep It Works!
/cfif




__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: String Manipulation troubles