Replace "." with "," - replaces all numbers in to ,

[ArtoAllan]

Hey guys.

I am building a manual scraper for some e-commerce numbers -> google sheet.

however since, I am a "noob" and just like to work with things, I am building this the most simple way I possible can. So everything is taken by heading to the website where it should grab the numbers, and copy it in to clipboard and then set variables according so.

Later, it will be opening google sheets and entering the data in the correct spots.

 

However, I am trying to replace . in to , with StringRegExpReplace, and it just doesnt do the trick. I am missing something.

I can easily have it exchange anything else, but as soon as I want it to exchange only the . it replaces all the numbers.

$Test = StringRegExpReplace("715.99", '.', ',')

As for example I want this to replace the text to 715,99 (seems stupid, but yea.. google sheets doesnt work with .)

 

But the value I am getting is just alot of commas.

 

What am I doing wrong? I tried putting the . in a variable to see if that helped, but it didnt change a thing.
I need help here!

[FrancescoDiMuro]

2 hours ago, ArtoAllan said:

What am I doing wrong?

The period in Regular Expressions is the meta character for "every character", so, unless you escape it with \, the function is doing its work
You don't really need StringRegExpReplace() to do such a simple task; just use StringReplace(), or, if you want to use SRER because you are a cat (you'll probably know in a few posts), then you should do something like this:

#include <StringConstants.au3>


Test()

Func Test()

    Local $strTest = "715.99"

    ConsoleWrite(StringRegExpReplace($strTest, '\.', ',') & @CRLF)
    ConsoleWrite(StringReplace($strTest, '.', ',') & @CRLF)

EndFunc

 

Edited June 4, 2021 by FrancescoDiMuro
StringReplace($strPostContent, "comma", "period")

[ArtoAllan]

2 minutes ago, FrancescoDiMuro said:

The comma in Regular Expressions is the meta character for "every character", so, unless you escape it with \, the function is doing its work
You don't really need StringRegExpReplace() to do such a simple task; just use StringReplace(), or, if you want to use SRER because you are a cat (you'll probably know in a few posts), then you should do something like this:

#include <StringConstants.au3>


Test()

Func Test()

    Local $strTest = "715.99"

    ConsoleWrite(StringRegExpReplace($strTest, '\.', ',') & @CRLF)
    ConsoleWrite(StringReplace($strTest, '.', ',') & @CRLF)

EndFunc

 

 

My man! Exactly what I was looking for!

$Test = StringRegExpReplace("715.99", '\.', ',')          ; <--- simplified

 

That does the trick, thank you soo much for a fast answer buddy! Appreciate it

[FrancescoDiMuro]

@ArtoAllan
Happy to have helped bud, always a pleasure

[TheXman]

1 hour ago, FrancescoDiMuro said:

The comma in Regular Expressions is the meta character for "every character"

Tiny correction:  I think you meant the period (.) in Regular Expressions is the meta character for "any character". 

[FrancescoDiMuro]

@TheXman
Thanks for the correction!
What can I say... You have an eagle eye!

[JockoDundee]

2 hours ago, FrancescoDiMuro said:

because you are a cat (you'll probably know in a few posts)...

Actually, I think your non-SRE solution is cat proof.  Well done!

[mikell]

17 hours ago, JockoDundee said:

Actually, I think your non-SRE solution is cat proof.  Well done!

I agree