Converting Data

[Vision]

hi,

i got 100 values from 3 digits to 2 digits.

i have to add a "." or a "," one digit before the last digit

exsample:

some values

124-105-90-78.....

to: 12,4-10,5-9,0-7,8..... or 12.4-10.5-9.0-7.8.....

how i can do this?

[BrewManNH]

Divide each number by 10?

[Juvigy]

Divide each number by 10?

Simple.Works.Great.

My first thought was StringRegExp()

[Melba23]

Vision,

Here is one way:

#include <Array.au3>

$sIn = "124-105-90-78"

$aSplit = StringSplit($sIN, "-")

$sOut = ""

For $i = 1 To $aSplit[0]

    $sOut &= StringMid($aSplit[$i], 1, StringLen($aSplit[$i]) - 1) & "." & StringMid($aSplit[$i], StringLen($aSplit[$i]), 1)

    If $i < $aSplit[0] Then $sOut &= "-"

Next

ConsoleWrite($sOut & @CRLF)

No doubt someone will be along with a sexy SRE solution in a minute.

M23

[Vision]

oh wow im stupid ^^

im thinking to complicated

divide by ten... yes easy as it could be...

but thanks melba23 ! for the script

Edited November 16, 2010 by Vision

[James]

It's only a half hearted regular expression (being at work I don't have time to write the rest), but here it is:

$strRegx = "([0-9]\d{0,3})"
$sIn = "124-105-90-78"
$sOut = ""

$aRegex = StringRegExp($sIn, $strRegx, 3)

For $i = 0 To UBound($aRegex) - 1
    $sOut &= StringMid($aRegex[$i], 1, StringLen($aRegex[$i]) - 1) & "." & StringMid($aRegex[$i], StringLen($aRegex[$i]), 1)

    If $i < UBound($aRegex) -1 Then $sOut &= "-"
Next

ConsoleWrite($sOut & @CRLF)

Same methods as Melba but getting rid of that icky StringSplit

James

[Ascend4nt]

This seems to work... in a small amount of code:

$sData='124-105-90-78-45-234'
$sResult=StringRegExpReplace($sData,'(\d+)(\d)','$1.$2')
ConsoleWrite($sResult&@CRLF)

[jchd]

Let me try (unchecked but should work):

$output = StringRegExpReplace($input, '(\d+)(\d)', '$1.$2') ; for decimal mark = dot

$output = StringRegExpReplace($input, '(\d+)(\d)', '$1,$2') ; for decimal mark = comma

Edit: Ascendant got faster at typing!

Edited November 16, 2010 by jchd

[Vision]

thank you all for the help