Replace won't work

[jorgeng]

I am trying to replace text in string but it doesn't work.

What's wrong?

The only replace which works is '00$' to blank.

$s_string = '09:15 ORDER "sl) Omx Sarlacc - Köp Trade - Grön - Krypterat OMXS300E" kurs 1063.5000$'

$text = StringReplace($s_string, '""', "")

$text = StringReplace($s_string, "sl)", "")

$text = StringReplace($s_string, "Krypterat", "")

$text = StringReplace($s_string, "ORDER", "")

$text = StringReplace($s_string, '00$', "")

MsgBox(4096,"Box",$text)

[Fire]

You want get result like this?

09:15 Omx Sarlacc - Kop Trade - Gron - OMXS300E kurs 1063.50

$s_string = "09:15 ORDER ""sl)"" Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E kurs 1063.5000$"

$text = StringReplace($s_string, '""""', "")

$text = StringReplace($text, """sl)""", "")

$text = StringReplace($text, "Krypterat", "")

$text = StringReplace($text, "ORDER", "")

$text = StringReplace($text, '00$', "")

MsgBox(4096,"Box",$text)

[jorgeng]

You want get result like this?

09:15 Omx Sarlacc - Kop Trade - Gron - OMXS300E kurs 1063.50

$s_string = "09:15 ORDER ""sl)"" Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E kurs 1063.5000$"

$text = StringReplace($s_string, '""""', "")

$text = StringReplace($text, """sl)""", "")

$text = StringReplace($text, "Krypterat", "")

$text = StringReplace($text, "ORDER", "")

$text = StringReplace($text, '00$', "")

MsgBox(4096,"Box",$text)

Thanks.

I tried but it doesn't makes what i want.

The string:

$s_string = '09:15 ORDER "sl) Omx Sarlacc - Köp Trade - Grön - Krypterat OMXS300E" kurs 1063.5000$'

is automatically generated from a ta-program and i can't change the double dots from input-file.

The result when i run your code with input from the ta-program is:

09:15 "sl) Omx Sarlacc - Köp Trade - Grön - Krypterat OMXS300E" kurs 1063.50

Be aware of the double dots.

Any idea?

[GEOSoft]

2 ways. First off your code is wrong

$s_string = "09:15 ORDER ""sl)"" Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E kurs 1063.5000$"

$text = StringReplace($s_string, '"', "")

$text = StringReplace($text, "sl)", "")

$text = StringReplace($text, "Krypterat", "")

$text = StringReplace($text, "ORDER", "")

$text = StringReplace($text, "00$", "")

MsgBox(4096,"Box",$text)

Beter yet

$s_string = "09:15 ORDER ""sl)"" Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E kurs 1063.5000$"
$sText = StringRegExpReplace($s_String, "(?i)sl\)|\x22|krypterat|\bORDER\b|00\$", "")
MsgBox(4096,"Box",$text)

That will return

09:15 Omx Sarlacc - Köp Trade - Grön - OMXS300E kurs 1063.50

from your example

[Fire]

Ok

$s_string = '09:15 ORDER "sl) Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E" kurs 1063.5000$'

;$s_string = "09:15 ORDER ""sl)"" Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E kurs 1063.5000$"

$text = StringReplace($s_string, """", "")

$text = StringReplace($text, "sl)", "")

$text = StringReplace($text, "Krypterat", "")

$text = StringReplace($text, "ORDER", "")

$text = StringReplace($text, "00$", "")

MsgBox(4096,"Box",$text)
;FileWrite(@ScriptDir&"\datad4.txt",$text) ;uncomment it for get result in datad4.txt file.

It returns me:

09:15 Omx Sarlacc - Kop Trade - Gron - OMXS300E kurs 1063.50

[jorgeng]

2 ways. First off your code is wrong

$s_string = "09:15 ORDER ""sl)"" Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E kurs 1063.5000$"

$text = StringReplace($s_string, '"', "")

$text = StringReplace($text, "sl)", "")

$text = StringReplace($text, "Krypterat", "")

$text = StringReplace($text, "ORDER", "")

$text = StringReplace($text, "00$", "")

MsgBox(4096,"Box",$text)

Beter yet

$s_string = "09:15 ORDER ""sl)"" Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E kurs 1063.5000$"
$sText = StringRegExpReplace($s_String, "(?i)sl\)|\x22|krypterat|\bORDER\b|00\$", "")
MsgBox(4096,"Box",$text)

That will return

09:15 Omx Sarlacc - Köp Trade - Grön - OMXS300E kurs 1063.50

from your example

Thanks, that code was heavy, didn't get it to work.

Edited April 27, 2010 by jorgeng

[jorgeng]

Ok

$s_string = '09:15 ORDER "sl) Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E" kurs 1063.5000$'

;$s_string = "09:15 ORDER ""sl)"" Omx Sarlacc - Kop Trade - Gron - Krypterat OMXS300E kurs 1063.5000$"

$text = StringReplace($s_string, """", "")

$text = StringReplace($text, "sl)", "")

$text = StringReplace($text, "Krypterat", "")

$text = StringReplace($text, "ORDER", "")

$text = StringReplace($text, "00$", "")

MsgBox(4096,"Box",$text)
;FileWrite(@ScriptDir&"\datad4.txt",$text) ;uncomment it for get result in datad4.txt file.

It returns me:

09:15 Omx Sarlacc - Kop Trade - Gron - OMXS300E kurs 1063.50

Thanks, now it works.