[Solved] Delete content between string and white space in multiple files

[sundar]

Here is the sample of the content of a file(s):-

string1 strin2 other-string some-other-string foo=bar string(n)

I used _FileListToArrayEx to list all the files with specific extension. Now i am removing specific strings which are not required. I used _ReplaceStringInFile to delete specific string. Hoever i am struck while deleting the string "foo=bar" where "foo=" is common in some of the files and bar can be anything else. So my requirement is to either delete entire foo=bar or delete anything after foo= till white space is reached or insert some-static-string after foo=

Any help is appriciated.

Edited February 22, 2013 by sundar

[Melba23]

sundar,

You need to use a Regex to do this:

$sString = "string1 strin2 other-string some-other-string foo=bar1 string(n)" & @CRLF & _
           "string1 strin2 other-string some-other-string foo=bar2 string(n)" & @CRLF & _
           "string1 strin2 other-string some-other-string foo=bar3 string(n)" & @CRLF & _
           "string1 strin2 other-string some-other-string foo=bar4 string(n)"

$sStripped = StringRegExpReplace($sString, "(?U)(foo=.*\s)", "")

MsgBox(0, "Result", $sStripped)

And this is how it works

(?U)        - Do not be greedy - take the smallest match
(foo=.*\s)    - Look for "foo=" and everything up to the next space
            (that is why we need to tell the SRER not to be greedy or it will use the last space it finds)

""        - Replace what was found with nothing

All clear?

M23

[PhoenixXL]

Another example

$sString = "string1 strin2 other-string some-other-string foo=bar1 string(n)" & @CRLF & _
           "string1 strin2 other-string some-other-string foo=bar2 string(n)" & @CRLF & _
           "string1 strin2 other-string some-other-string foo=bar3 string(n)" & @CRLF & _
           "string1 strin2 other-string some-other-string foo=bar4 string(n)"

$sStripped = StringRegExpReplace($sString, "(?U)(foo=.*(?=\s+))", "") ;This would not replace the space

MsgBox(0, "Result", $sStripped)

$sStripped = StringRegExpReplace($sString, "(?U)(foo=)(.*(?=\s+))", "\1STATIC") ;This would replace with the word "STATIC"

MsgBox(0, "Result", $sStripped)

Regards

[sundar]

Both scripts are working. Thank you melba and PhoenixXL.