Regex need help (tough one) Topic is solved

[keylo]

Hi Guys,
Is there a way I can do basic operation using regexreplace?
in the following csv lines I want to add "4" to the second field

Code: Select all

csv=
(
1, 45 , 765756
1, 56 , 654654
1, 900 , 545809
)

the output should be

Code: Select all

1, 49 , 765756
1, 60, 654654
1, 904, 545809

I'm trying to avoid loops in my script, is there a way this could be done using regexreplace with only 1 line of code ?

[braunbaer]

Code: Select all

Global Outputstring
csv=
(
1, 45 , 765756
1, 56 , 654654
1, 900 , 545809
)
Outputstring:=""
RegExReplace(csv, "(\d+\D+)(\d+)(\D*\d*\D*)(?CCallNewStr)")
msgbox %Outputstring%
return

CallNewStr(Match)
{
    Outputstring .= Match1 (Match2+4) Match3
}

[Mod edit: [code][/code] tags added.]

[keylo]

Thanks @braunbaer but it doesn't work, the output is blank

[braunbaer]

Are you sure you did not make a mistake while copying? Did you include the function CallNewStr(Match) at the end of the script?
I tested the script, it produces exactly the output you want.

[boiler]

Must have copied only the visible part of the script in the code box without scrolling/expanding/selecting all. It would be blank without the function and not produce an error.

[keylo]

@braunbaer ,Thanks so much , it works fine . sorry, I didn't copy the function.