To have numbers only in a phone number column.

saraswati · Post by **saraswati** » Mon Oct 24, 2011 12:35 pm

Please let me know how we have only numbers for a phonenumber column.

For Example: (304)-645-7865

I just to get the number as 3046457865 .To be more simple, I want only numbers from 0-9 in the phone number column. Eliminate ( ), [], Ext,- etc...

chulett · Post by **chulett** » Mon Oct 24, 2011 1:09 pm

On the Server side you have the DIGITS transform but on the PX side I'd just fall back on Convert, I do believe:

Code: Select all

Convert("()[]-. ","",YourField)

Something much like that.

saraswati · Post by **saraswati** » Mon Oct 24, 2011 1:16 pm

I don't what all non-numeric characters might come so it will be better if we can have some transformation so that it contains only numbers from 0-9.

arunkumarmm · Post by **arunkumarmm** » Mon Oct 24, 2011 1:17 pm

I'm not sure if there's a function in parallel but if you can use a BASIC_Transformer, you can use Oconv('String',"MCN") to just get the numbers alone from your string.

chulett · Post by **chulett** » Mon Oct 24, 2011 1:25 pm

That would be the DIGITS transform I noted.

chulett · Post by **chulett** » Mon Oct 24, 2011 1:27 pm

saraswati wrote:I don't what all non-numeric characters might come so it will be better if we can have some transformation so that it contains only numbers from 0-9.

OK. If you are expecting complete crap in your phone numbers then the old "double convert" trick may be in order:

Code: Select all

Convert(Convert("0123456789","",YourField),"",YourField)

saraswati · Post by **saraswati** » Mon Oct 24, 2011 1:31 pm

You mean to say by using

Convert(Convert("0123456789","",YourField),"",YourField)

if the input value is (879)-986-5623 [5421] then I will get the output as

87998656235421.

RIGHT?????

max.madsen · Post by **max.madsen** » Mon Oct 24, 2011 2:47 pm

Right..
The solution its very interesting..

saraswati · Post by **saraswati** » Mon Oct 24, 2011 3:02 pm

Thanks a lot....it worked fine.

chulett · Post by **chulett** » Mon Oct 24, 2011 8:27 pm

max.madsen wrote:The solution its very interesting..

Yes, it is. I was quite impressed the first time I saw this posted as it wasn't something that had occured to me to do. Basically, the first convert removes all of the characters you want to keep from your string, generating a custom list of all of the unwanted characters in that particular value and that output is used in the next convert to remove them.

stuartjvnorton · Post by **stuartjvnorton** » Mon Oct 24, 2011 10:38 pm

saraswati wrote:Convert(Convert("0123456789","",YourField),"",YourField)

Nicely done.

chulett · Post by **chulett** » Tue Oct 25, 2011 6:42 am

You're welcome.