I'm trying to get a phone number including its international dialing code. '[@cbParamVirtual3]'+RIGHT('[@cbParamVirtual4]',9) ...the first parameter takes the dialing code, and the last one takes the 9 digits from the right. but the problem I have encountered is that not all countries have 9 digits after the 0. if the first zero isn't written we just take the number as is.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Kuroshi
I'm trying to get a phone number including its international dialing code. '[@cbParamVirtual3]'+RIGHT('[@cbParamVirtual4]',9) ...the first parameter takes the dialing code, and the last one takes the 9 digits from the right. but the problem I have encountered is that not all countries have 9 digits after the 0. if the first zero isn't written we just take the number as is.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.