| || |
Splitting the numbers !
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...
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,