Replace string

[jorgeng]

I have a string which looks like this:

15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.75

I want to subtract 0.50 to 1012.75 giving me 1012.25.

Is this possible to do in a calculation string?

Above is just an example, the numbers can be others and change often.

Edited June 28, 2010 by jorgeng

[JohnOne]

Here is one example.

$string='15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.75'
$a=StringRegExp($string,"kurs (\S*)",1)
$b = $a[0] - 0.5
ConsoleWrite($b & @LF)

[PsaltyDS]

Extract that part of the string with StringMid() or other string manipulation, or maybe StringRegExp(). Do the math, then put the result back in the string.

If you get stuck, post what you tried for more help.

[Paulie]

$string='15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.75'
$result = stringregexp($string, "\d*\.\d{2}",3)
If isarray($result) then
$result = $result[0]-.5
Msgbox(0,"",$result)
Endif

[GEOSoft]

And another simple way

$sStr = '15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.75'

$iNewValue = StringRegExpReplace($sStr, "^.+\h([\d.]+)$", "$1") -.5
If @Extended Then
    MsgBox(0, "Result", $iNewValue)
Else
    MsgBox(0, "Error", "Invalid string entered")
EndIf

Edit: Added code to check for a valid string.

Edited June 28, 2010 by GEOSoft

[jorgeng]

Thanks everybody.

They all works, but i want to have the result replaced in original string, how to do that?

Now the string looks like:

15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.75

and i want

15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.25

How to do that?

[JohnOne]

$string='15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.75'
$a=StringRegExp($string,"kurs (\S*)",1)
$b = $a[0] - 0.5
ConsoleWrite($b & @LF)
$c = StringReplace($string,$a[0],$b)
ConsoleWrite($c & @LF)

[jorgeng]

$string='15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.75'
$a=StringRegExp($string,"kurs (\S*)",1)
$b = $a[0] - 0.5
ConsoleWrite($b & @LF)
$c = StringReplace($string,$a[0],$b)
ConsoleWrite($c & @LF)

Thanks, works great.

[jorgeng]

One small problem, when price is 1012.50 and script will subtract 0.50 the

result becomes 1012

and i want 1012.00

How to fix this?

[GEOSoft]

$sStr = '15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.50'
$aStr = StringRegExp($sStr, "^(.+\h)([\d.]+)$", 1)
If IsArray($aStr) Then
    $aStr[1] = StringFormat( "%.2f", $aStr[1] -.5)
    $sStr = $aStr[0] & $aStr[1]
    MsgBox(0, "Result", $sStr)
Else
    MsgBox(0, "Error", "Invalid string entered")
EndIf

[JohnOne]

Or

$string='15:47 ORDER "sl) Omx Sarlacc - Sälj Trade - Rosa - Krypterat OMXS300G" kurs 1012.75'
$a=StringRegExp($string,"kurs (\S*)",1)
$b = $a[0] - .5
If Not StringInStr($b,".") Then $b &= ".00"
$c = StringReplace($string,$a[0],$b)
ConsoleWrite($c & @LF)

[jorgeng]

Thanks.

Works fine.