trimming a string

[coolidge]

I'm generating strings dynamically in my application, and they look something
lie this:

0 0 0 435921014 0 0 0 0

What I want to do is trim off all the characters before the first '4' and
after the second '4'. Would anyone be able to assist me with the syntax for
that? Thank you...

[allen@oysterweb.com]

<cfset Test = "0 0 0 435921014 0 0 0 0">
<cfset GoodString = #Mid(Test, #findnocase("4",Test)#+1,
#findnocase("4",Test,#findnocase("4",Test)#+1)# -
#findnocase("4",Test)#-1)#>

That should do it.

[TurboMini]

Use the mid() function:

mid(string, start, count)

Will you always have zeros at the beginning and end, or will they be varying
digits with consistent spacing in between? That will determine how to trim the
string.

[Dan Bracuk]

First, replace all the instances of "0 " (zero space) with ""
Then replace all the instances of " 0" (space zero) with "".



Originally posted by: coolidge
I'm generating strings dynamically in my application, and they look something
lie this:

0 0 0 435921014 0 0 0 0

What I want to do is trim off all the characters before the first '4' and
after the second '4'. Would anyone be able to assist me with the syntax for
that? Thank you...

[mxstu]

As TurboMini mentioned, if the value will always be in the 4th position and
each set of numbers will always be separated by a space, simply use the
listGetAt() function with a space (chr(32) as the delimiter.

<cfset yourValue = "0 0 0 435921014 0 0 0 0">
<cfoutput>#ListGetAt(yourValue, 4, chr(32))#</cfoutput>

[Stressed_Simon]

I would personally use regEx as it is cleaner:-

<cfscript>
original = "0 0 0 435921014 0 0 0 0";

result = reReplace(original, "(0\s0\s0\s)|(\s0\s0\s0\s0)", "", "all");
writeoutput("#wang#<br />#result#");
</cfscript>

[mxstu]

Just to be safe, you might want to structure the regular expresssion to search
for multiple spaces between the zeros. Something like:

<!--- more than one space in between first and second zero --->
<cfset original = "0 0 0 435921014 0 0 0 0">
<cfoutput>
new #reReplace(original, "(0\s+0\s+0\s+)|(\s+0\s+0\s+0\s+0)", "", "all")#<br>
old #reReplace(original, "(0\s0\s0\s)|(\s0\s0\s0\s0)", "", "all")#<br>