IT Gurus - ClickFunnels, Saidia

I have a Clickfunnels account where I have a list of people with phone numbers that I want to send an
SMS promotional offer message to.
There may be some issues with phone number formatting so I am not able to do bulk SMS sending through Infusionsoft. I am wondering if there is a way to automate the formatting of the numbers to ensure the numbers are registered by the system or do I have to use a stand alone system like Twilio?

the hard way

        bool IsPhoneNumber(string number)
        {
            bool is_valid = false;
            if (number.Length == 10)
            {
                is_valid = System.Text.RegularExpressions.Regex.Match(number, @"^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$").Success;
            }
            else if (number.Length == 11)
            {
                is_valid = System.Text.RegularExpressions.Regex.Match(number, @"^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{5})$").Success;
            }
            return is_valid;
        }

@Chloe @Pinto Q kuja hapa

Thanks, so what about the easy way?

:slight_smile:

manually format the numbers in a text file, ensure all the numbers have a country code prefix and no spacing :smiley:

:D:D:D…kwenda huko…this is the hard way. Let me insert that code nione.

Thanks a million

:D:D:D:D

thats what i thought

remember the above snippet only deals with formatting the number without the country code (0701123123 or 701123123) , you still need a way to append the country code

        void BindCountries()
        {
            string sz_Codes = "Afghanistan,93|Albania,355|Algeria,213|American Samoa,1|Andorra,376|Angola,244|Anguilla,1|Antigua and Barbuda,1|Argentina,54|Armenia,374|Aruba,297|Ascension,247|Australia,61|Austria,43|Azerbaijan,994|Bahamas,1|Bahrain,973|Bangladesh,880|Barbados,1|Belarus,375|Belgium,32|Belize,501|Benin,229|Bermuda,1|Bhutan,975|Bolivia,591|Bosnia and Herzegovina,387|Botswana,267|Brazil,55|British Virgin Islands,1|Brunei,673|Bulgaria,359|Burkina Faso,226|Burundi,257|Cambodia,855|Cameroon,237|Canada,1|Cape Verde,238|Cayman Islands,1|Central African Republic,236|Chad,235|Chile,56|China,86|Colombia,57|Comoros,269|Congo,242|Cook Islands,682|Costa Rica,506|Croatia,385|Cuba,53|Curacao,599|Cyprus,357|Czech Republic,420|Democratic Republic of Congo,243|Denmark,45|Diego Garcia,246|Djibouti,253|Dominica,1|Dominican Republic,1|East Timor,670|Ecuador,593|Egypt,20|El Salvador,503|Equatorial Guinea,240|Eritrea,291|Estonia,372|Ethiopia,251|Falkland (Malvinas) Islands,500|Faroe Islands,298|Fiji,679|Finland,358|France,33|French Guiana,594|French Polynesia,689|Gabon,241|Gambia,220|Georgia,995|Germany,49|Ghana,233|Gibraltar,350|Greece,30|Greenland,299|Grenada,1|Guadeloupe,590|Guam,1|Guatemala,502|Guinea,224|Guinea-Bissau,245|Guyana,592|Haiti,509|Honduras,504|Hong Kong,852|Hungary,36|Iceland,354|India,91|Indonesia,62|Inmarsat Satellite,870|Iran,98|Iraq,964|Ireland,353|Iridium Satellite,8816|Israel,972|Italy,39|Ivory Coast,225|Jamaica,1|Japan,81|Jordan,962|Kazakhstan,7|Kenya,254|Kiribati,686|Kuwait,965|Kyrgyzstan,996|Laos,856|Latvia,371|Lebanon,961|Lesotho,266|Liberia,231|Libya,218|Liechtenstein,423|Lithuania,370|Luxembourg,352|Macau,853|Macedonia,389|Madagascar,261|Malawi,265|Malaysia,60|Maldives,960|Mali,223|Malta,356|Marshall Islands,692|Martinique,596|Mauritania,222|Mauritius,230|Mayotte,262|Mexico,52|Micronesia,691|Moldova,373|Monaco,377|Mongolia,976|Montenegro,382|Montserrat,1|Morocco,212|Mozambique,258|Myanmar,95|Namibia,264|Nauru,674|Nepal,977|Netherlands,31|Netherlands Antilles,599|New Caledonia,687|New Zealand,64|Nicaragua,505|Niger,227|Nigeria,234|Niue,683|Norfolk Island,6723|North Korea,850|Northern Marianas,1|Norway,47|Oman,968|Pakistan,92|Palau,680|Palestine,970|Panama,507|Papua New Guinea,675|Paraguay,595|Peru,51|Philippines,63|Poland,48|Portugal,351|Puerto Rico,1|Qatar,974|Reunion,262|Romania,40|Russian Federation,7|Rwanda,250|Saint Helena,290|Saint Kitts and Nevis,1|Saint Lucia,1|Saint Barthelemy,590|Saint Martin (French part),590|Saint Pierre and Miquelon,508|Saint Vincent and the Grenadines,1|Samoa,685|San Marino,378|Sao Tome and Principe,239|Saudi Arabia,966|Senegal,221|Serbia,381|Seychelles,248|Sierra Leone,232|Singapore,65|Sint Maarten,1|Slovakia,421|Slovenia,386|Solomon Islands,677|Somalia,252|South Africa,27|South Korea,82|South Sudan,211|Spain,34|Sri Lanka,94|Sudan,249|Suriname,597|Swaziland,268|Sweden,46|Switzerland,41|Syria,963|Taiwan,886|Tajikistan,992|Tanzania,255|Thailand,66|Thuraya Satellite,88216|Togo,228|Tokelau,690|Tonga,676|Trinidad and Tobago,1|Tunisia,216|Turkey,90|Turkmenistan,993|Turks and Caicos Islands,1|Tuvalu,688|Uganda,256|Ukraine,380|United Arab Emirates,971|United Kingdom,44|United States of America,1|U.S. Virgin Islands,1|Uruguay,598|Uzbekistan,998|Vanuatu,678|Venezuela,58|Vietnam,84|Wallis and Futuna,681|Yemen,967|Zambia,260|Zimbabwe,263";
            string[] countries = sz_Codes.Split(new char[] { '|' });
            foreach (String szCountry in countries)
            {
                string[] _parts = szCountry.Split(new char[] { ',' });
                Classes.CountryCode c_code = new Classes.CountryCode(_parts[0].Trim(), _parts[1].Trim());
                /*do something here, like binding a hashtable*/
            }
        }



        string get_code(string country)
        {
            string result = string.Empty;
            for (int i = 0; i < m_CountryCodes.Count; i++)
            {
                if (m_CountryCodes[i].country.CompareTo(country) == 0)
                {
                    result = m_CountryCodes[i].code;
                    break;
                }
            }
            return result;
        }
     
        void test(string szPhoneNumber, string szCountry)
        {
            if (IsPhoneNumber(szPhoneNumber))
            {
                string sz_full_number = string.Format("+{0}{1}", get_code(szCountry), szPhoneNumber.Substring(1));
            }
        }

How do we insert the code?

Abit confused, which code do I use because all the numbers have international codes?

in that case just adjust the regex only

Kanyaga clutch na mguu ya left halafu hio rungu hapo kando uipeleke hapo pameandikwa 4. Sienj kapsa!

Asante sana @amun

There is no place to insert the codes in infusionsoft so nimekwama tena. Hii clickfunnels nimecheswo

Kumbe IMers tuko wengi huku?

:smiley: Huyu @amun ni dereva wa Msendes Benj kweli?

a jack of all trades :D:D:D:D