Regular expression matching and replacing

Help
1

Need separate answers for the following:

  1. How do I read a string and return a boolean whether it matches a regular expression or not?
    This should be in a single line for use in the If Activity.

  2. How do I replace the part of the string which contains the regular expression?

Thanks

2

@DEATHFISH,

In If activity, readString.contains(“search Text”)
Then do next step
Else stop

Use Str.Replace(“old value”, “new value”)

3

Hi, “search text” and “old value” needs to fulfil conditions of the regular expression…

It needs to be flexible to accommodate variations so I need to use a regular expression instead of a fixed string

e.g. 109-Company A, 110-CompanyB, 111-5Company C

Currently using regular expressions [0-9]±[^ ]+ and [0-9]±[0-9]*

4

@DEATHFISH,

Try below one:

Dim myString As String = "The cat in the hat dog"
Dim regex = New Regex("\bcat\b.*\bdog")
Dim match = regex.Match(myString)
If match.Success Then
   Console.WriteLine(match.Value)
End If
5

@DEATHFISH,

To replace, try following one

Eg:

ResultString = Regex.Replace(yourString, "(-*\d+;*)+", "newValue")

Here, use your regular expression

6

@lakshman

Does this method replace the matching part of the string or the whole string?

7

@DEATHFISH,

It will replace matching part only.

8

For your First Answer, You can also use the activity “Is Match”

it will return bool.

image
image911×400 13.6 KB

9

For the Secount Part.

You can use If condition and can replace if it matches.