Exploring Regex in Construct 2

What is regex?

Regular expressions are a way to automate extracting certain parts of a string that share a common pattern.

For example, you need to get a list of street names out of a list of 1000 full addresses. It could take hours if you do this manually or you could use a simple regex pattern to effortlessly extract this data.

A practical example

We have three addresses below. There are a lot of different regex expressions that we could write to extract "apple", "banana" and "Water Melon". You'll need to analyse our dataset as well as test it carefully to create an expression that is reliable enough and yet simple.

    123 apple St.
    1A banana Ave
    43 Water Melon Park

    Expression: "[\d\w]+\s([\w\s]+)\s\w+\.?"
    Flag: i
    Output:
    [1] "apple"
    [2] "banana"
    [3] "Water Melon"