Skip to main content
adamaas
adamaas
Known Participant
January 19, 2012
Answered

Separation of telephone numbers by a dot

  • January 19, 2012
  • 1 reply
  • 1211 views

Hello,

Am still newbie in coldfusion.

I have a telephone number of 12 digits, for e.g, +331234567890.

Now I have to replace the country code by 0,i.e, +33 to 0. I have already done that.

My problem is how to separate these 10 remaining numbers and put a dot in between each 2 numbers like 12.34.56.78.90 and at the end join the country code like 0.12.34.56.78.90

I was thinking of doing a Len() of the numbers and then separate them by a dot but unfortunately I don't know how to do it.

Can anybody help me please ?

Thanks in advance.

    This topic has been closed for replies.
    Correct answer BKBK

    <cfset dotted_reverse_telno = "">

    <cfset telno = "01234567890">

    <!---Reverse the tel number --->

    <cfset reverse_telno = reverse(telno)>

    <!---Run through the digits in the reversed number, adding a dot after every 2 digits --->

    <cfloop from="1" to="#len(reverse_telno)#" index="n">

        <cfif n mod 2 EQ 0>

            <cfset dotted_reverse_telno = dotted_reverse_telno & mid(reverse_telno, n, 1) & "." >

        <cfelse>

            <cfset dotted_reverse_telno = dotted_reverse_telno & mid(reverse_telno, n, 1)>

        </cfif>

    </cfloop>

    <!---Reverse the result --->

    <cfset dotted_telno = reverse(dotted_reverse_telno)>

    <cfoutput>#dotted_telno#</cfoutput>

    1 reply

    BKBK
    Community Expert
    BKBKCommunity ExpertCorrect answer
    Community Expert
    January 19, 2012

    <cfset dotted_reverse_telno = "">

    <cfset telno = "01234567890">

    <!---Reverse the tel number --->

    <cfset reverse_telno = reverse(telno)>

    <!---Run through the digits in the reversed number, adding a dot after every 2 digits --->

    <cfloop from="1" to="#len(reverse_telno)#" index="n">

        <cfif n mod 2 EQ 0>

            <cfset dotted_reverse_telno = dotted_reverse_telno & mid(reverse_telno, n, 1) & "." >

        <cfelse>

            <cfset dotted_reverse_telno = dotted_reverse_telno & mid(reverse_telno, n, 1)>

        </cfif>

    </cfloop>

    <!---Reverse the result --->

    <cfset dotted_telno = reverse(dotted_reverse_telno)>

    <cfoutput>#dotted_telno#</cfoutput>

      Owainnorth
      Owainnorth
      Inspiring
      January 19, 2012

      Regex FTW.

      <cfset newstr = reReplace(reverse("012456994088"), '([0-9]{2})', '\1.', 'all') />

      <cfoutput>#reverse(newstr)#</cfoutput>

      Not perfect as it has a dot at the start if it's an even number and not if it's odd, but that's easily fixed.

        adamaas
        adamaasAuthor
        Known Participant
        January 19, 2012

        Thanks dude.

        I did not know that we could make use of regex in coldfusion. Cool..

        Yeps this could be easily fixed with the dot at start. Thanks a lot again for the quick reply.

        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices