Re: Number2Text
| From: | heiler duarte | Date: | Tue, 16 Mar 2004 20:40:58 +0000 |
| Subject: | Re: Number2Text | ||
| Groups: | php.general.es | ||
| Request: | Send a blank email to general-es+get-46704@lists.php.net to get a copy of this message | ||
esta es una funcion que me pasó un amigo la puedes revisar ..... depronto te sirva
Function ConvertCurrencyToEnglish(ByVal MyNumber)
Dim Temp
Dim Dollars, Cents
Dim DecimalPlace, Count
Dim PLACE(5)
PLACE(2) = " Mil"
PLACE(3) = " Millon"
PLACE(4) = " Billon"
PLACE(5) = " Trillon" ' ConvertMyNumber to a string,
trimming extra spaces.
If IsNull(MyNumber) Then
MyNumber = 0
End If
MyNumber = Trim(Str(MyNumber)) ' Find decimal Place.
DecimalPlace = InStr(MyNumber, ".") ' If we find decimal
place...
If DecimalPlace > 0 Then ' Convert cents
Temp = Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)
Cents = ConvertTens(Temp) ' Strip off cents from remainder to
convert.
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If
Count = 1
Do While MyNumber <> "" ' Convert last 3 digits of
MyNumber to English dollars.
Temp = ConvertHundreds(Right(MyNumber, 3))
If Temp <> "" Then
If Count > 2 And MyNumber > 1 Then
Dollars = Temp & PLACE(Count) & "es " & Dollars
Else
Dollars = Temp & PLACE(Count) & " " & Dollars
End If
If Len(MyNumber) > 3 Then ' Remove last 3 converted digits
from MyNumber.
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
MyNumber = ""
End If
Count = Count + 1
ElseIf Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Count = Count + 1
Else
MyNumber = ""
End If
Loop
' Clean up dollars.
Select Case Dollars
Case "": Dollars = "00/100 pesos"
Case "Un ": Dollars = "Un Pesos"
Case Else
Dollars = Dollars & " Pesos"
End Select
' Clean up cents.
Select Case Cents
Case "": Cents = " Con 00/100 Centavos"
Case "Un": Cents = " Con Un Centavo"
Case Else
Cents = " Con " & Cents & " Centavos"
End Select
ConvertCurrencyToEnglish = Dollars & Cents
MsgBox ConvertCurrencyToEnglish
End Function
Private Function ConvertDigit(ByVal MyDigit, Caso As Integer, Caso1
As Integer)
Select Case Caso
Case 1:
Select Case Val(MyDigit)
Case 1: ConvertDigit = "Un"
Case 2: ConvertDigit = "Dos"
Case 3: ConvertDigit = "Tres"
Case 4: ConvertDigit = "Cuatro"
Case 5: ConvertDigit = "Cinco"
Case 6: ConvertDigit = "Seis"
Case 7: ConvertDigit = "Siete"
Case 8: ConvertDigit = "Ocho"
Case 9: ConvertDigit = "Nueve"
Case Else: ConvertDigit = ""
End Select
Case 2:
Select Case Val(MyDigit)
Case 1:
If Caso1 = 0 Then
ConvertDigit = "Cien "
Else
ConvertDigit = "Ciento "
End If
Case 2: ConvertDigit = "Doscientos "
Case 3: ConvertDigit = "Trescientos "
Case 4: ConvertDigit = "Cuatrocientos "
Case 5: ConvertDigit = "Quinientos "
Case 6: ConvertDigit = "Seiscientos "
Case 7: ConvertDigit = "Setecientos "
Case 8: ConvertDigit = "Ochocientos "
Case 9: ConvertDigit = "Novecientos "
Case Else: ConvertDigit = ""
End Select
End Select
End Function
Private Function ConvertHundreds(ByVal MyNumber)
Dim Result As String ' Exit if there is nothing to convert.
If Val(MyNumber) = 0 Then Exit Function ' Append leading zeros to
number.
MyNumber = Right("000" & MyNumber, 3) ' Do we have a
hundreds place digit to convert?
If Left(MyNumber, 1) <> "0" Then
Result = ConvertDigit(Left(MyNumber, 1), 2, Val(Right(MyNumber, 2)))
& ""
End If ' Do we have a tens place digit to convert?
If Mid(MyNumber, 2, 1) <> "0" Then
Result = Result & ConvertTens(Mid(MyNumber, 2))
Else ' If not, then convert the ones place digit.
Result = Result & ConvertDigit(Mid(MyNumber, 3), 1, 0)
End If
ConvertHundreds = Trim(Result)
End Function
Private Function ConvertTens(ByVal MyTens)
Dim Result As String
If Val(Left(MyTens, 1)) = 1 Then
Select Case Val(MyTens)
Case 10: Result = "Diez"
Case 11: Result = "Once"
Case 12: Result = "Doce"
Case 13: Result = "Trece"
Case 14: Result = "Catorce"
Case 15: Result = "Quince"
Case 16: Result = "Dieciseis"
Case 17: Result = "Diecisiete"
Case 18: Result = "Dieciocho"
Case 19: Result = "Diecinueve"
Case Else
End Select
Else
Select Case Val(Left(MyTens, 1))
Case 2: Result = "Veinte y "
Case 3: Result = "Treinta y "
Case 4: Result = "Cuarenta y "
Case 5: Result = "Cincuenta y "
Case 6: Result = "Sesenta y "
Case 7: Result = "Setenta y "
Case 8: Result = "Ochenta y "
Case 9: Result = "Noventa y "
Case Else
End Select
If ConvertDigit(Right(MyTens, 1), 1, 0) = "" Then
Result = Mid(Result, 1, Len(Result) - 2)
End If
Result = Result & ConvertDigit(Right(MyTens, 1), 1, 0)
End If
ConvertTens = Result
End Function
--
______________________________________________________
Obtenga su E-mail gratis en http://e-mail.colombia.com
Llegó la Fórmula 1 a Colombia.com http://www.colombia.com/formula1/
Visita http://www.colombia.com
El portal que une a los colombianos en el mundo
Powered by Outblaze