1. Splitting the numbers !

Hi,

is there any function to split the numbers say 10 digits to 3 and 7 digits ?.

I have two Phone fields in my application to which i have to get the data from excel sheet. But in the excel sheet i have only one column of data which contains 10 digit number. now what i have to do is tht i have to split this 10 digit number in to 3 and 7 digits.

how should i proceed. if u have faced any problems b4 how did u solve it....pls kindly help me i'm running out of time...

2. Re: Splitting the numbers !

</font><blockquote><font size="1" face="Verdana, Arial, Helvetica">code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">myNumber = 1234567890;
number1 = substr(myNumber, 1, 3); # first 3 digits
number2 = substr(myNumber, 4); # digits from 4 to ...</pre><hr /></blockquote><font size="2" face="Verdana, Arial, Helvetica">Regards,
Juergen

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.