Making 9999999999999999 look like 9999 9999 9999 9999 1

[hautnueil]

What CF function(s) would I need to make

9999999999999999 look like 9999 9999 9999 9999

I need to grab credit card data out of my Access DB and dump it in an Excel Sheet so that it is more readable.

I got around the exponential display, but I'm at a loss for inserting spaces every fourth digit. (early morning brain cramp)

Any help or clues anyone could give me is IMMENSELY appreciated.

I'm on a deadline - tick-tock-tick-tock... Good thing I can manage pressure...

 

[calista]

Not very elegant, but this will work. You can probably make a loop out of it.

<cfset MyNumber=&quot;1234123412341234&quot;>

<cfset MyNumber=Insert(&quot; &quot;,MyNumber,4)>
<cfset MyNumber=Insert(&quot; &quot;,MyNumber,9)>
<cfset MyNumber=Insert(&quot; &quot;,MyNumber,14)> Calista :-X
Jedi Knight,
Champion of the Force

 

[tleish]

A regular expression would work nicely

=== START CODE EXAMPLE ===
<cfset ccNum = 9999999999999999>

<cfoutput>
#ReReplace(variables.ccNum, &quot;(

[

0-9

]

{4})&quot;, &quot;\1 &quot;, &quot;ALL&quot;)#
</cfoutput>
=== END CODE EXAMPLE ===

This may leave one extra space on the end:
&quot;9999 9999 9999 9999 &quot;
If you want to remove the extra space simply add the Trim() function

=== START CODE EXAMPLE ===
<cfoutput>
#Trim(ReReplace(variables.ccNum, &quot;(

[

0-9

]

{4})&quot;, &quot;\1 &quot;, &quot;ALL&quot;))#
</cfoutput>
=== END CODE EXAMPLE === - tleish

 

[hautnueil]

Thanks Calista and -tleish...

Both solutions work like a charm.

 

[calista]

Thanks, tleish! I knew there was a better way. You forced me to do some research to understand your response, and that's a good thing. Calista :-X
Jedi Knight,
Champion of the Force

 

[hautnueil]

Pretty cool -tleish!

Is the &quot;\1&quot; a backreference like the &quot;$1&quot; in Perl?

And, if I may add, this forum is grrrrrrreaaaaaat!