_ArrayAddComma()

[buzz44]

I needed to have numbers I was using to have comma's in them, so I created this UDF and decided to share it .

expandcollapse popup

;=================================================
; Function Name:    _ArrayAddComma()
; Description:      Add comma's to an array of numbers (can have alphabetic characters.
; Return Value(s):  A new array with the values delimited by comma's.
;=================================================

#include <Array.au3>

Dim $avArray[9]

$avArray[0] = "975738222836526532626264"
$avArray[1] = "2546578657872"
$avArray[2] = "65856783"
$avArray[3] = "64657865785678387"
$avArray[4] = "6356"
$avArray[5] = "105678567856029"
$avArray[6] = "7656786578341"
$avArray[7] = "573"
$avArray[8] = "This is a testing sentence."

_ArrayDisplay($avArray, "Without Comma's")
$avNew = _ArrayAddComma($avArray)
_ArrayDisplay($avNew, "With Comma's")

Func _ArrayAddComma($avArray)
   For $I = 0 To UBound($avArray) - 1
      If StringIsDigit($avArray[$I]) And StringLen($avArray[$I]) > 3 Then
         $sComma = StringLeft($avArray[$I], StringLen($avArray[$I]) - 3) & "," & StringRight($avArray[$I], 3)
         Do
            If Not StringInStr(StringLeft($sComma, 4), ",") Then
               $sComma = StringLeft($sComma, StringInStr($sComma, ",") - 4) & "," & StringRight($sComma, StringLen($sComma) - StringInStr($sComma, ",") + 4)
            EndIf
         Until StringInStr(StringLeft($sComma, 4), ",")
         _ArrayDelete($avArray, $I)
         _ArrayInsert($avArray, $I, $sComma)
      EndIf
   Next
   Return $avArray
EndFunc

Edited May 16, 2011 by buzz44

[Insolence]

Seems useful to me

Should also accept non-arrays though.

[buzz44]

Yes I came to that conclusion as soon as I tried to use it lol. Seeing as I got a reply so quick and you mentioned it, I'll to it now lol .

[Insolence]

Glad I could be of, uh, assistance?

[buzz44]

Thank you. @Error is now set to 1 when the interger/array contains no numbers.

expandcollapse popup

;=================================================
; Function Name: _ArrayAddComma()
; Description: Add comma's to an array/integer of numbers.
; Return Value(s): On Success: A new array/integer with the value(s) delimited by comma's.
; Return Value(s): On Failure:
;                 @Error:    = 0 = No error.
;                               1 = $nValue isn't a number or the array contains no numbers.
;=================================================

;Example 1 - Array

#include <Array.au3>

Dim $avArray[9]

$avArray[0] = "975738222836526532626264"
$avArray[1] = "2546578657872"
$avArray[2] = "65856783"
$avArray[3] = "64657865785678387"
$avArray[4] = "6356"
$avArray[5] = "105678567856029"
$avArray[6] = "7656786578341"
$avArray[7] = "573"
$avArray[8] = "This is a testing sentence."

_ArrayDisplay($avArray, "Without Comma's")
$avNew = _ArrayAddComma($avArray)
_ArrayDisplay($avNew, "With Comma's")

;Example 2 - Integer

$nNum = "981298409731156"
$Commad = _ArrayAddComma($nNum)
MsgBox(4096, "Result", $nNum & " to..." & @CRLF & $Commad)

Func _ArrayAddComma($nValue)
   Local $sComma, $nValue, $sError = 0
   If IsArray($nValue) Then
      For $I = 0 To UBound($nValue) - 1
         If StringIsAlpha ($nValue) Then
            $sError = $sError + 1
            If $sError = UBound($nValue) Then
               SetError(1)
               Return (0)
            EndIf
         EndIf
      Next
      For $I = 0 To UBound($nValue) - 1
         If StringIsDigit($nValue[$I]) And StringLen($nValue[$I]) > 3 Then
            $sComma = StringLeft($nValue[$I], StringLen($nValue[$I]) - 3) & "," & _
            StringRight($nValue[$I], 3)
            Do
               If Not StringInStr(StringLeft($sComma, 4), ",") Then
                  $sComma = StringLeft($sComma, StringInStr($sComma, ",") - 4) & "," & _
                  StringRight($sComma, StringLen($sComma) - StringInStr($sComma, ",") + 4)
               EndIf
            Until StringInStr(StringLeft($sComma, 4), ",")
            $nValue[$I] = $sComma)
         EndIf
      Next
      Return $nValue
   Else
      If Not StringIsDigit($nValue) Then
         SetError(1)
         Return (0)
      Else
         If StringLen($nValue) > 3 Then
            $sComma = StringLeft($nValue, StringLen($nValue) - 3) & "," & StringRight($nValue,3)
            Do
               If Not StringInStr(StringLeft($sComma, 4), ",") Then
                  $sComma = StringLeft($sComma, StringInStr($sComma, ",") - 4) & "," & _
                  StringRight($sComma, StringLen($sComma) - StringInStr($sComma, ",") + 4)
               EndIf
            Until StringInStr(StringLeft($sComma, 4), ",")
            Return $sComma
         EndIf
      EndIf
   EndIf
EndFunc

Edited December 29, 2011 by buzz44

[buzz44]

If any one is interested I have now changed the name of it because it no longer only deals with arrays but also non-array's.

expandcollapse popup

;=================================================
; Function Name: _AddComma()
; Description: Add comma's to an array/integer of numbers.
; Return Value(s): On Success: A new array/integer with the value(s) delimited by comma's.
; Return Value(s): On Failure:
;                 @Error:    = 0 = No error.
;                               1 = $nValue isn't a number or the array contains no numbers.
;=================================================

;Example 1 - Array

#include <Array.au3>

Dim $avArray[9]

$avArray[0] = "975738222836526532626264"
$avArray[1] = "2546578657872"
$avArray[2] = "65856783"
$avArray[3] = "64657865785678387"
$avArray[4] = "6356"
$avArray[5] = "105678567856029"
$avArray[6] = "7656786578341"
$avArray[7] = "573"
$avArray[8] = "This is a testing sentence."

_ArrayDisplay($avArray, "Without Comma's")
$avNew = _AddComma($avArray)
_ArrayDisplay($avNew, "With Comma's")

;Example 2 - Integer

$nNum = "981298409731156"
$Commad = _AddComma($nNum)
MsgBox(4096, "Result", $nNum & " to..." & @CRLF & $Commad)

Func _AddComma($nValue)
   Local $sComma, $nValue, $sError = 0
   If IsArray($nValue) Then
      For $I = 0 To UBound($nValue) - 1
         If StringIsAlpha ($nValue) Then
            $sError = $sError + 1
            If $sError = UBound($nValue) Then
               SetError(1)
               Return (0)
            EndIf
         EndIf
      Next
      For $I = 0 To UBound($nValue) - 1
         If StringIsDigit($nValue[$I]) And StringLen($nValue[$I]) > 3 Then
            $sComma = StringLeft($nValue[$I], StringLen($nValue[$I]) - 3) & "," & _
            StringRight($nValue[$I], 3)
            Do
               If Not StringInStr(StringLeft($sComma, 4), ",") Then
                  $sComma = StringLeft($sComma, StringInStr($sComma, ",") - 4) & "," & _
                  StringRight($sComma, StringLen($sComma) - StringInStr($sComma, ",") + 4)
               EndIf
            Until StringInStr(StringLeft($sComma, 4), ",")
            $nValue[$I] = $sComma)
         EndIf
      Next
      Return $nValue
   Else
      If Not StringIsDigit($nValue) Then
         SetError(1)
         Return (0)
      Else
         If StringLen($nValue) > 3 Then
            $sComma = StringLeft($nValue, StringLen($nValue) - 3) & "," & StringRight($nValue,3)
            Do
               If Not StringInStr(StringLeft($sComma, 4), ",") Then
                  $sComma = StringLeft($sComma, StringInStr($sComma, ",") - 4) & "," & _
                  StringRight($sComma, StringLen($sComma) - StringInStr($sComma, ",") + 4)
               EndIf
            Until StringInStr(StringLeft($sComma, 4), ",")
            Return $sComma
         EndIf
      EndIf
   EndIf
EndFunc

Edited December 29, 2011 by buzz44

[blindwig]

I wrote one of these a while back too. I never thought to use StringInStr and StringLeft to check if you have enough commas - that's a cool trick!

Here is my routine:

CODE

Func NumberCommas($Number)

;Given a number such as 12345678 will return 12,345,678

Dim $Result='', $Pos

If StringIsDigit($Number) Then

$Pos = StringLen($Number)-2

While $Pos > -2

If $Pos < 1 Then

$Result = StringMid($Number, 1, $Pos + 2) & ',' & $Result

Else

$Result = StringMid($Number, $Pos, 3) & ',' & $Result

EndIf

$Pos = $Pos - 3

WEnd

$Result=StringLeft($Result, StringLen($Result) - 1)

EndIf

Return $Result

EndFunc

I basically go through the number as a string, breaking it off 3 characters at a time, and concatenating commas in.

[buzz44]

Cool, when I was creating it I was faced with many options of how to do it, and there are many ways I found it. I just used the first one that same to my head, but I also wanted it to add comma's to arrays aswell.

[buzz44]

Updated, now works for floating point numbers.

expandcollapse popup

;=================================================
; Function Name: _AddComma()
; Description: Add comma's to an array/integer of numbers.
; Return Value(s): On Success: A new array/integer with the value(s) delimited by comma's.
; Return Value(s): On Failure:
; @Error: = 0 = No error.
; 1 = $nValue isn't a number or the array contains no numbers.
;=================================================

;Example 1 - Array

#include <Array.au3>

Dim $avArray[9]

$avArray[0] = "975738222836526532626264"
$avArray[1] = "2546578657872"
$avArray[2] = "65856783"
$avArray[3] = "64657865785678387"
$avArray[4] = "6356"
$avArray[5] = "105678567856029"
$avArray[6] = "7656786578341"
$avArray[7] = "573"
$avArray[8] = "This is a testing sentence."

_ArrayDisplay($avArray, "Without Comma's")
$avNew = _AddComma($avArray)
_ArrayDisplay($avNew, "With Comma's")

;Example 2 - Integer

$nNum = "981298409731156.37268587"
$Commad = _AddComma($nNum)
MsgBox(4096, "Result", $nNum & " to..." & @CRLF & $Commad)

Func _AddComma($nValue)
   Local $sComma, $sError = 0
   If IsArray($nValue) Then
      For $I = 0 To UBound($nValue) - 1
         If StringIsAlpha($nValue) Then
            $sError = $sError + 1
            If $sError = UBound($nValue) Then
               SetError(1)
               Return (0)
            EndIf
         EndIf
      Next
      For $I = 0 To UBound($nValue) - 1
         If StringIsDigit($nValue[$I]) And StringLen($nValue[$I]) > 3 Then
            $sComma = StringLeft($nValue[$I], StringLen($nValue[$I]) - 3) & "," & _
                  StringRight($nValue[$I], 3)
            Do
               If Not StringInStr(StringLeft($sComma, 4), ",") Then
                  $sComma = StringLeft($sComma, StringInStr($sComma, ",") - 4) & "," & _
                        StringRight($sComma, StringLen($sComma) - StringInStr($sComma, ",") + 4)
               EndIf
            Until StringInStr(StringLeft($sComma, 4), ",")
            $nValue[$I] = $sComma
         EndIf
      Next
      Return $nValue
   Else
      If Not StringIsDigit($nValue) And Not StringIsFloat($nValue) Then
         SetError(1)
         Return (0)
      Else
         If StringIsFloat($nValue) Then
            Local $Split = StringSplit($nValue, ".")
            $nValue = $Split[1]
         EndIf
         If StringLen($nValue) > 3 Then
            $sComma = StringLeft($nValue, StringLen($nValue) - 3) & "," & StringRight($nValue,3)
            Do
               If Not StringInStr(StringLeft($sComma, 4), ",") Then
                  $sComma = StringLeft($sComma, StringInStr($sComma, ",") - 4) & "," & _
                        StringRight($sComma, StringLen($sComma) - StringInStr($sComma, ",") + 4)
               EndIf
            Until StringInStr(StringLeft($sComma, 4), ",")
            If IsDeclared("Split") Then
               $sComma = $sComma & "." & $Split[2]
            EndIf         
            Return $sComma
         EndIf
      EndIf
   EndIf
EndFunc

Edited December 29, 2011 by buzz44

[gumby]

Thanx thanx thanx... its works sooo well...

cheers

[Omar]

I know this may be too old to update:

For some reason floats with less then 3 digits before the decimals don't get reassambled.