How to remove thousend separator from string

[IlchenkoEvgeny]

Hello

Have a float "2 234,34"

Need convert to standart float with 2 digits after dot.

fist trouble: i cant remove space.

Already try this

StringReplace($str, ' ', '') 

and second is "," but need dot

Help pls!

[guinness]

Is this a float represented as a string or a float? What is the output please?

Look at Round or Int in the help file.

[BrewManNH]

How about this?

#include <constants.au3>
$String = "2 234,34"
$NewString = StringReplace(StringStripWS($String, 8), ",", ".")
MsgBox($MB_SYSTEMMODAL, "New String", $NewString)

[IlchenkoEvgeny]

Is this a float represented as a string or a float? What is the output please?

Look at Round or Int in the help file.

 

function NUMBER or INT return "2" from this "2 234,34"

[IlchenkoEvgeny]

 

How about this?

#include <constants.au3>
$String = "2 234,34"
$NewString = StringReplace(StringStripWS($String, 8), ",", ".")
MsgBox($MB_SYSTEMMODAL, "New String", $NewString)

result "2" (((((

[BrewManNH]

No, the result of that function is 2234.34.

[IlchenkoEvgeny]

No, the result of that function is 2234.34.

Thousand separator <> white space 

and your function doesnt work

Edited July 18, 2013 by IlchenkoEvgeny

[guinness]

Ah, now I understand what the OP wants. BrewManNH's code works.

[guinness]

Thousend separator <> white space 

and your function doesnt work

Provide what output you want then please.

For example:

Input: 1234,56

Output: 1234.56

[IlchenkoEvgeny]

Provide what output you want then please.

For example:

Input: 1234,56

Output: 1234.56

i have string where float have a seporator:

2[separator]234,56

i want remove separator.

But separator not white space. I dont know what is it (((

[IlchenkoEvgeny]

Have any idea ?

[IlchenkoEvgeny]

Maybe try Regular Expressions and get digit by digit with ? 

Can you help with expression?

[BrewManNH]

First thing you need to do is find out what character is used as the separator character. 

[IlchenkoEvgeny]

First thing you need to do is find out what character is used as the separator character. 

 

Ok. Maybe convert this string to ASCII code?

[IlchenkoEvgeny]

ASCII code of this symbol '160'

[IlchenkoEvgeny]

StringReplace($str, Chr(160), '')

Work for me.

Thanks to all )))

[BrewManNH]

Or

#include <constants.au3>
$String = "2" & chr(160) & "234,34"
$NewString = StringRegExpReplace($String, "(\d+)\D(\d+),(\d+)", "$1$2.$3")
MsgBox($MB_SYSTEMMODAL, "New String", $NewString)