Jump to content
TrashBoat

Reverse _NumberNumToName

Recommended Posts

TrashBoat

This udf right here converts 700 into Seven Hundred, is there a way to reverse it so it would do from text into numbers?

Share this post


Link to post
Share on other sites
Deye

you need to download the above and keep it in same directory together with the UDF found in the link you posted

make sure you have included both udfs with your script testing  form i.e (#include <BigNum.au3> ) same for the other ..

Usage example: MsgBox(262144, "Test", _NumberNumToName(770))

Share this post


Link to post
Share on other sites
TrashBoat
Posted (edited)

thats not what i asked for ...

i know what that udf does but i need it do it backwards from  SEVEN HUNDRED SEVENTY to 770

Edited by Melba23
Quote deleted

Share this post


Link to post
Share on other sites
Deye
Posted (edited)

just to get you going, here is some quick sketch i came up with
note that its not clean nor fully tested ..

Edit: cleaned up a little more, let me know if some number fails to translate

MsgBox(0, "", NameToNumber("two hundred thousand thirty six"))

Func NameToNumber($Number)
    Local $iString, $Num = StringSplit($Number, " ", 1), $aArray[4][10] = _
            [ _
            ['ten', 'eleven', 'twelve', 'thirteen', 'fourteen', 'fifteen', 'sixteen', 'seventeen', 'eighteen', 'nineteen'], _
            ['', '', 'hundred', 'thousand', '', '', '', '', '', ''], _
            ['', '', 'twenty', 'thirty', 'forty', 'fifty', 'sixty', 'seventy', 'eighty', 'ninety'], _
            ['', 'One', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine'] _
            ]
    For $i = $Num[0] To 1 Step -1
        For $a = 0 To 3
            For $b = 0 To 9
                If $Num[$i] = $aArray[$a][$b] Then
                    Switch $a
                        Case 3
                            $iString = $b & $iString
                        Case 2
                            If StringLen($iString) = 1 Then
                                $iString = $b & $iString
                            Else
                                $iString = $b & 0 & $iString
                            EndIf
                        Case 1
                            If $b - StringLen($iString) < 0 Then
                                For $k = 1 To $b
                                    $iString = 0 & $iString
                                Next
                            Else
                                For $k = 1 To $b - StringLen($iString)
                                    $iString = 0 & $iString
                                Next
                            EndIf
                        Case 0
                            If $b = 0 Then
                                $iString = 10 & $iString
                            Else
                                $iString = 1 & $b & $iString
                            EndIf
                    EndSwitch
                    ExitLoop 2
                EndIf
            Next
        Next
    Next
    Return $iString
EndFunc   ;==>NameToNumber

 

Edited by Deye

Share this post


Link to post
Share on other sites
TrashBoat
Posted (edited)

Thanks for the reply ill try it!

Edited by Melba23
Quote deleted

Share this post


Link to post
Share on other sites
Melba23

TrashBoat,

When you reply, please use the "Reply to this topic" button at the top of the thread or the "Reply to this topic" editor at the bottom rather than the "Quote" button - responders know what they wrote and it just pads the thread unnecessarily. Thanks for your cooperation.

M23

 


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites
Deye

Updated the above code, let me know if some number still fails to translate ..

Share this post


Link to post
Share on other sites
TrashBoat
Posted (edited)

@Deye It loops through every each member in the array to check if it matches right? so if i would add a case 4 for thousands how would that work?

MsgBox(0, '', NameToNumber("one thousand seven hundred ninety three"))

Func NameToNumber($Number)
    Local $aArray[5][10] = _
            [ _
            ['ten', 'eleven', 'twelve', 'thirteen', 'fourteen', 'fifteen', 'sixteen', 'seventeen', 'eighteen', 'nineteen'], _
            ['', 'hundred', 'two hundred', 'three hundred', 'four hundred', 'five hundred', 'six hundred', 'seven hundred', 'eight hundred', 'nine hundred'], _
            ['', '', 'twenty', 'thirty', 'forty', 'fifty', 'sixty', 'seventy', 'eighty', 'ninety'], _
            ['', 'one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine'], _
            ['one thousand', 'two thousand', 'three thousand', 'four thousand', 'five thousand', 'six thousand', 'seven thousand', 'eight thousand', 'nine thousand','ten thousand'] _
            ]

    $Num = StringSplit($Number, " ", 1)

    Local $iString

    For $i = $Num[0] To 1 Step -1
        For $a = 0 To 4
            For $b = 0 To 9
                If $Num[$i] = $aArray[$a][$b] Then
                    Switch $a
                        Case 4
                            If StringLen($iString) >= 2 Then
                            ElseIf StringLen($iString) >= 1 Then
                                $iString = 0 & 0 & $iString
                            Else
                                $iString = 0 & 0 & 0 & $iString
                            EndIf
                        Case 3
                            $iString = "," & $b & $iString
                        Case 2
                            If StringInStr($iString, ",") Then
                                If StringLen($iString) >= 1 Then
                                    $iString = $b & $iString
                                EndIf
                            Else
                                $iString = $b & 0 & 0 & $iString
                            EndIf
                        Case 1
                            If StringLen($iString) >= 2 Then
                            ElseIf StringLen($iString) >= 1 Then
                                $iString = 0 & $iString
                            Else
                                $iString = 0 & 0 & $iString
                            EndIf
                        Case 0
                            If StringInStr($iString, ",") Then
                                If $b = 0 Then
                                    $iString = 10 & $iString
                                Else
                                    $iString = 1 & $b & $iString
                                EndIf
                            Else
                                If $b = 0 Then
                                    $iString = 10 & $iString
                                Else
                                    $iString = 1 & $b & $iString
                                EndIf
                            EndIf
                    EndSwitch
                    ExitLoop 2
                EndIf
            Next
        Next
    Next
    Return StringReplace($iString, ",", "")
;~ Return $iString
EndFunc   ;==>NameToNumber

Edit: I added the thousands part to the array and took your case 1 because that's where it loops through hundreds so it should be the same with thousands and i added a extra zero in case 4 it seems to work so far

Edited by TrashBoat

Share this post


Link to post
Share on other sites
Deye

Please try the above edited code, changed for adding in the thousands .. if it all worked well then we got it .. :D

Share this post


Link to post
Share on other sites
Melba23
Posted (edited)

Hi,

A fun little challenge for a windy afternoon. Here is my suggestion:

#include <StringConstants.au3>

Local $aMajorDivisions[3] = ["billion", "million", "thousand"]

Local $aDecades[10] = ["", "", "twenty", "thirty", "forty", "fifty", "sixty", "seventy", "eighty", "ninety"]
Local $aTens[10] = ["ten", "eleven", "twelve", "thirteen", "fourteen", "fifteen", "sixteen", "seventeen", "eighteen", "nineteen"]
Local $aUnits[10] = ["", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine"]

; ###########################

; Example

Local $aInitialAmounts[] = ["One hundred and three billion five hundred and eleven million two hundred and thirteen thousand seven hundred and fifty five", _
                            "One hundred and three billion two hundred and thirteen thousand seven hundred and fifty five", _
                            "One hundred and three billion eleven million nineteen thousand and one", _
                            "Five hundred and thirteen thousand seven hundred and fifty five", _
                            "Five hundred and thirteen thousand"]

For $n = 0 To UBound($aInitialAmounts) - 1
    $sRet = _NumberStringToDigits($aInitialAmounts[$n])
    ConsoleWrite($aInitialAmounts[$n] & @CRLF & $sRet & @CRLF)
Next

; ###########################

Func _NumberStringToDigits($sInitialAmount)

    ; Remove any English "and"s
    $sWorkingAmount = StringReplace($sInitialAmount, " and ", " ")
    ; Initialise return
    $sFigures = ""

    For $i = 0 To 2
        ; Look for major division (billion, million, thousand)
        $iPos = StringInStr($sWorkingAmount, $aMajorDivisions[$i])
        If $iPos Then
            ; Get value of major division
            $sValue = StringMid($sWorkingAmount, 1, $iPos - 1)
            ; And parse it
            $sFigures &= _ParseHundred($sValue) & ","
            ; Strip to next division
            $sWorkingAmount = StringTrimLeft($sWorkingAmount, $iPos + StringLen($aMajorDivisions[$i]))
        Else
            ; No major division
            If $sFigures Then
                $sFigures &= "000,"
            EndIf
        EndIf
    Next
    ; Parse any remaining hundred value
    If $sWorkingAmount Then
        $sFigures &= _ParseHundred($sWorkingAmount)
    Else
        $sFigures &= "000"
    EndIf

    ; Strip any leading zeroes
    While StringLeft($sFigures, 1) = 0
        $sFigures = StringTrimLeft($sFigures, 1)
    WEnd

    Return $sFigures

EndFunc   ;==>_NumberStringToDigits

Func _ParseHundred($sMajorValue)

    ; Initialise return
    $sIntFigures = ""
    ; Initialise unit value
    $sUnits = ""

    ; Look for "hundred"
    $aSplit = StringSplit($sMajorValue, "hundred", $STR_ENTIRESPLIT)
    If @error Then
        ; Add "0" if no hundred
        $sIntFigures &= "0"
        ; Set unit value
        $sUnits = $sMajorValue
    Else
        ; Parse hundred value
        For $j = 1 To 9
            If StringInStr($aSplit[1], $aUnits[$j]) Then
                ; Add hundred value
                $sIntFigures &= $j
                ; Set unit value
                $sUnits = $aSplit[2]
                ExitLoop
            EndIf
        Next
    EndIf

    ; Parse unit value
    ; Look for 10-19
    For $j = 0 To 9
        If StringInStr($sUnits, $aTens[$j]) Then
            ; Add value
            $sIntFigures &= "1" & $j
            ExitLoop
        EndIf
    Next
    ; If not found then look for decades
    If $j > 9 Then
        For $j = 2 To 9
            If StringInStr($sUnits, $aDecades[$j]) Then
                ; Add value
                $sIntFigures &= $j
                ExitLoop
            EndIf
        Next
        If $j > 9 Then
            ; Add "0"  if no ten value
            $sIntFigures &= "0"
        EndIf
        ; Finally look for units
        For $j = 1 To 9
            If StringInStr($sUnits, $aUnits[$j]) Then
                ; Add value
                $sIntFigures &= $j
                ExitLoop
            EndIf
        Next
        ; Add "0" if no unit value
        If $j > 9 Then
            $sIntFigures &= "0"
        EndIf
    EndIf

    Return $sIntFigures

EndFunc   ;==>_ParseHundred

And the results:

One hundred and three billion five hundred and eleven million two hundred and thirteen thousand seven hundred and fifty five
103,511,213,755
One hundred and three billion two hundred and thirteen thousand seven hundred and fifty five
103,000,213,755
One hundred and three billion eleven million nineteen thousand and one
103,011,019,001
Five hundred and thirteen thousand seven hundred and fifty five
513,755
Five hundred and thirteen thousand
513,000

M23

Edited by Melba23
Fixed leading zero problem - see below
  • Haha 1

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites
TrashBoat

I barely understand what happening in @Deye code, @Melba23

Share this post


Link to post
Share on other sites
Melba23

TrashBoat,

I have commented my code fairly liberally - just ask if you need any further explanation.

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites
jchd
Posted (edited)

My take at both conversions. I rewrote _IntegerToText as the function mentionned above is buggy.

Local $r, $n

For $i = 1 To 10
    $r = Random(0, 100000000000, 1)
    $n = Random(1, 2000, 1)
    ConsoleWrite("Range is " & $r & " .. " & $r + $n & @LF)
    For $j = 1 To $n
        _Check($r + $j)
    Next
Next

Func _Check($n)
    Local $s = _IntegerToText($n)
    Local $r = _TextToInteger($s)
    ConsoleWrite($r = $n ? "" : $n & " ERROR" & @LF)
EndFunc

Func _CheckDetail($n)
    ConsoleWrite($n & @LF)
    Local $s = _IntegerToText($n)
    ConsoleWrite($s & @LF)
    Local $r = _TextToInteger($s)
    ConsoleWrite($r & @LF)
    ConsoleWrite("-------------- " & ($r = $n ? "OK" : "ERROR") & @LF)
EndFunc

Func _IntegerToText($iNum)
    Local $aGroup3, $iGroup3, $iHundreds, $iTens, $iUnits, $iMultiple, $sText

    If IsString($iNum) Then $iNum = StringStripWS($iNum, 8)
    $iNum = Int($iNum)
    If $iNum = 0 Then
        Return 'zero'
    EndIf

    $iNum = StringRegExpReplace($iNum, '(\A\d{1,3}(?=(\d{3})+\z)|\d{3}(?=\d))', '\1 ')
    $aGroup3 = StringSplit($iNum, ' ', 2)

    Local Static $aWords = [ _
        ['', ' one', ' two', ' three', ' four', ' five', ' six', ' seven', ' eight', ' nine', ' ten', ' eleven', ' twelve', ' thirteen', ' fourteen', ' fifteen', ' sixteen', ' seventeen', ' eighteen', ' nineteen'], _
        ['', '', ' twenty', ' thirty', ' forty', ' fifty', ' sixty', ' seventy', ' eighty', ' ninety'], _
        ['', ' thousand', ' million', ' billion', ' trillion', ' quadrillion', ' quintillion'] _
    ]

    $sText = ''
    $iMultiple = UBound($aGroup3) - 1

    For $i = 0 To UBound($aGroup3) - 1
        $iGroup3 = Int($aGroup3[$i])
        If $iGroup3 = 0 Then
            $iMultiple -= 1
            ContinueLoop
        EndIf

        $iHundreds = Int($iGroup3 / 100)
        $iTens = Int(Mod($iGroup3, 100) / 10)
        $iUnits = Mod($iGroup3, 10)
        $iTwenty = $iTens * 10 + $iUnits


        Switch $iHundreds
            Case 2 To 9
                $sText &= $aWords[0][$iHundreds]
                ContinueCase
            Case 1
                $sText &= " hundred"
        EndSwitch
        If $iTwenty < 20 Then
            $sText &= $aWords[0][$iTwenty]
        Else
            $sText &= $aWords[1][$iTens] & $aWords[0][$iUnits]
        EndIf

        $sText &= $aWords[2][$iMultiple] & ($iMultiple < 2 ? "" : ($iGroup3 > 1 ? "s" : ""))
        $iMultiple -= 1
    Next

    Return StringStripWS($sText, 3)
EndFunc

Func _TextToInteger($sText)

    If IsString($sText) Then $sText = StringStripWS($sText, 8)

    Local Static $s0_9 = "zero|one|two|three|four|five|six|seven|eight|nine"
    Local Static $s10_19 = "ten|eleven|twelve|thirteen|fourteen|fifteen|sixteen|seventeen|eighteen|nineteen"
    Local Static $s20_27 = "twenty|thirty|forty|fifty|sixty|seventy|eighty|ninety"
    Local Static $s28_33 = "thousand|million|billion|trillion|quadrillion|quintillion"
    Local $aExpr = StringRegExp($sText, _
        "(?ix) (?(DEFINE) (?<Range0_9> " & $s0_9 & ") (?<Range10_19> " & $s10_19 & ") (?<Range20_27> " & $s20_27 & ") (?<Range28_33> " & $s28_33 & ") )" & _
        "(?:((?&Range0_9)?) (hundred))?   (?| ((?&Range20_27)) ((?&Range0_9)?) | ()? ((?&Range10_19)) | ()? ((?&Range0_9)) )?   ((?&Range28_33)?)", 3)
    Local Static $a0_19 = StringSplit($s0_9 & "|" & $s10_19, "|", 2)
    Local Static $a20_27 = StringSplit($s20_27, "|", 2)
    Local Static $a28_33 = StringSplit($s28_33, "|", 2)
    Local $iNumber, $iGroupNb, $idx, $iNbGroups = UBound($aExpr) / 9
    For $i = 0 To $iNbGroups - 1
        $iGroupNb = 0
        If $aExpr[9 * $i + 5] Then $iGroupNb = 100
        If $aExpr[9 * $i + 4] Then $iGroupNb *= _ArraySearch($a0_19, $aExpr[9 * $i + 4])
        $idx = _ArraySearch($a20_27, $aExpr[9 * $i + 6])
        If Not @error Then $iGroupNb += 10 * ($idx + 2)
        $idx = _ArraySearch($a0_19, $aExpr[9 * $i + 7])
        If Not @error Then $iGroupNb += $idx
        $idx = _ArraySearch($a28_33, $aExpr[9 * $i + 8])
        If Not @error Then $iGroupNb *= Int(1000 ^ ($idx + 1))
        $iNumber += $iGroupNb
    Next

    Return $iNumber
EndFunc

EDIT: forgot to mention that it's rather easy to add some decoration, like the word "and" or comma as separator of groups of 3 digits, all in both functions.

Edited by jchd

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Share this post


Link to post
Share on other sites
TrashBoat

@Deye it seems to have failed on "fourthousandsevenhundredfourtysix" and gave 4706

Share this post


Link to post
Share on other sites
TrashBoat

Yeah my input had broken english, should've payed more attention

Share this post


Link to post
Share on other sites
Malkey
Posted (edited)

@TrashBoat
    "one million, two hundred and thirteen thousand, seven hundred and twenty-five" your script returns
    1213700

@Melba23
    "one million, two hundred and thirteen thousand, seven hundred and twenty-five" your script returns
    001,213,725

@jchd
    "one million, two hundred and thirteen thousand, seven hundred and twenty-five" your script returns
     1013925

And another one.

#include <Array.au3> ; For _ArrayDisplay(), if used.

ConsoleWrite(_Text2Num("twenty") & @CRLF)                                    ; Returns  20
ConsoleWrite(_Text2Num("hundred") & @CRLF)                                   ; Returns 100
ConsoleWrite(_Text2Num("two thousand and eighteen", 0) & @CRLF)              ; Returns 2018  (Comma separator set ot "0")
ConsoleWrite(_Text2Num("A thousand, five hundred and thirty-seven") & @CRLF) ; Returns 1,537
ConsoleWrite(_Text2Num("Twelve billion, eight hundred and forty-four million, three hundred and thirteen thousand, seven hundred and twenty-five") & @CRLF) ; Returns 12,844,313,725
ConsoleWrite(_Text2Num("Million hundred and thirteen thousand, seven hundred and twenty-five") & @CRLF) ; Returns 1,113,725
ConsoleWrite(_Text2Num("A billion hundred eighty-one million, four hundred nine thousand hundred seventy-nine") & @CRLF) ; Returns 1,181,409,179


Func _Text2Num($Txt, $AddThousandsSep = 1)
    Local $sRet = "("
    Local $sD = "zero=+0,one=+1,two=+2,twen=+2,three=+3,thir=+3,for=+4,four=+4,fif=+5,five=+5,six=+6,seven=+7,eigh=+8,eight=+8,nine=+9," & _
            "ten=+10,teen=+10,eleven=+11,twelve=+12,ty=*10,hundred=*100,thousand=)*1000+(,million=)*1000000+(,billion=)*1000000000+("
    Local $sREP = StringTrimRight(StringRegExpReplace($sD, "=\)?[+*]\d+(\+\()?,?", "|"), 1)
    $Txt = StringRegExpReplace($Txt, "(?i)(^|a\h*|,\h*|ion\h*|and\h*)(?=hundred|thousand|million|billion)", "\1 one ") ; Add "one" infront of a hundred, etc., when absent.
    ;ConsoleWrite($Txt & @CRLF) ; View modified $Txt string.

    Local $aArr = StringRegExp($Txt, "(?i)" & $sREP, 3)
    For $i = 0 To UBound($aArr) - 1
        $sRet &= StringRegExpReplace($sD, "(?i)^.*" & $aArr[$i] & "=(\)?[+*]\d+(\+\()?).*$", "$1")
    Next
    ;ConsoleWrite($sRet & ")" & @CRLF) ; See string pre-executed.
    ;_ArrayDisplay($aArr)              ; See array from which the pre-executed string is formed.
    $iRet = Execute($sRet & ")")
    If $AddThousandsSep Then
        Return StringRegExpReplace($iRet, '(\d+?)(?=(\d{3})+\b)', '$1,') ; Add comma separators.
    Else
        Return $iRet
    EndIf
EndFunc   ;==>_Text2Num

 

Edited by Malkey
_Text2Num() modified to allow "a hundred", or just "hundred" to be read as" one hundred".

Share this post


Link to post
Share on other sites
jchd
44 minutes ago, Malkey said:

@jchd
    "one million, two hundred and thirteen thousand, seven hundred and twenty-five" your script returns
     1013925

Maybe, but :
ConsoleWrite(_TextToInteger("one million two hundred thirteen thousand seven hundred twenty five") &@LF)
works fine. I said I didn't bother to handle "and", commas, dashes nor any other cosmetic variation. This isn't hard to add to my code.

BTW, nice code of yours.


This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Share this post


Link to post
Share on other sites
Melba23
Posted (edited)
1 hour ago, Malkey said:

@Melba23
    "one million, two hundred and thirteen thousand, seven hundred and twenty-five" your script returns
    001,213,725

Thanks for pointing that out - the algorithm does not do it any more as it now strips any leading zeroes.

M23

Edited by Melba23
Fixed quote

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites
Deye

Hi jchd,

_IntegerToText("18050152552")
"eighteen billions fifty millions hundred fifty two thousand five hundred fifty two"

 will it be easy to get it fixed to show:
"eighteen billion fifty million one hundred fifty two thousand five hundred fifty two"

Thanks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • nooneclose
      By nooneclose
      Good morning everyone, I thought I had already solved this issue but it turns out I did not. 
      My code finds unread emails with this specific subject line of "request" but when I change the subject to SKIPPED + "request" = ("SKIPPED request") the program still finds the email and tries to process it. I only want to process emails with the exact match subject of "request".
      Here is my code that "finds" the unread emails with the subject of "request" or so I thought. 
      Func ListUnreadEmails() ;******************************************************************************* ; Lists all unread E-mails from the folder Outlook-UDF-Test ;******************************************************************************* ; Stores all the unRead emails into an array Global $aItems = _OL_ItemFind($oOutlook, "*\Outlook-UDF-Test", $olMail, _ "[UnRead]=True", "Subject", "request", "EntryID,Subject", "", 1) ; Displays the array of unRead emails If IsArray($aItems) Then ;_ArrayDisplay($aItems, "OutlookEX UDF: _OL_ItemFind - Unread mails") Else MsgBox(48, "OutlookEX UDF: _OL_ItemFind Example Script", _ "Could not find an unread mail. @error = " & @error & ", @extended: " & @extended) EndIf ; Gets the number of unread emails Global $numberOfUnRead = UBound($aItems, $UBOUND_ROWS) - 1 ;MsgBox("", "Number of Unread emails", $numberOfUnRead) EndFunc It acts as if any part of the subject containing the word "request" and the email is unread that it will try to process it. (I think)
    • KhalidAnsari
      By KhalidAnsari
      Hi,
      I need to automate Java application using AutoIt, I have refer forum for the same, as per forum I am using Java Access Bridge to finding control name. But could not set value to control. Below is my sample code 
      Send("#r")
      sleep(1500)
      Send("D:\javaapplication\javaapplication\Hello.jar{Enter}")
      WinActivate("Penjumlahan")
      sleep(1500)
      ControlSetText("Penjumlahan", "", "Name:  A :", "demo")
      Java Application and Java Ferret screen

    • QaisBsharat
      By QaisBsharat
      Hello, 
      May i know how can i automation qt application?
      Using controlclick not mouse and positions
       
      Thanks
    • nooneclose
      By nooneclose
      Good afternoon, I am in need of some help. I am sure this is a stupid question requiring only one or two lines of code. However, I would greatly appreciate the help I cannot figure this out. I also tried searching for the answer on the internet but no one except me apparently seems to be having a hard time figuring this out and or is asking about it. 
      I simply want to change the "status" of an email from unread to read once I have processed it. My code is over 500 lines and I would like not to clutter this post with it. Assume I have all my includes and connections properly defined and stuff. 
      Here is the bit of code where I am trying to change the email that was used from unread to read:
      Func ChangeEmailStatus() ;******************************************************************************* ; changes the status of an email from unread to Read ;******************************************************************************* Local $iRows = UBound($aItems, $UBOUND_ROWS) MsgBox("", "Number of Unread emails (Before Change)", $iRows) _OL_ItemModify($oOutlook,$aItems[$i][0], Default, "Read=True") MsgBox("", "Array Display 1", $aItems[1][0]) MsgBox("", "Array Display 2", $aItems[2][0]) Local $iRows = UBound($aItems, $UBOUND_ROWS) MsgBox("", "Number of Unread emails (After Change)", $iRows) EndFunc  
    • SharpDressedMan
      By SharpDressedMan
      Hello,
      Is there any way to check for validity of a pointer to a DllStruct ?
      In the above code, a DllStruct is created from an invalid pointer. How to prevent from doing this ?
      local $tStruct = DllStructCreate("int i") DllStructSetData($tStruct, "i", 123) local $pStruct = DllStructGetPtr($tStruct) $tStruct = 0 ; destroy DllStruct ==> $pStruct becomes invalid ; how to check here for validity of $pStruct and prevent from doing the following ? $tStruct = DllStructCreate("int i", $pStruct) ; create DllStruct from invalid pointer... MsgBox(0, @ScriptName, @error) ; displays '0' : invalid pointer is not detected by DllStructCreate() MsgBox(0, @ScriptName, IsDllStruct($tStruct)) ; displays '1' : tStruct is assumed as a valid DllStruct object, which is not Thanks for help
×