Regex issues

I have the following result stored in a variable in KM, I am trying to extract the answers but cannot seem too property

KM stored data

Your full legal name:*: Darren

Email address:*: aaaaaa@test.co.uk

Date of birth:*: 01/01/1981

Phone number*: 07911171111

Your current address*: 100 south park

A.1 what bank or building society are you complaining about? Company who sold the policy:*: Natwest

Here are the results I manage to pull pull out using the refex (.*)

*: Darren
*: aaaaaa@test.co.uk
*: 01/01/1981

Is there a way to grab everything after the *: ?

Many thanks.

image

1 Like

Many thanks, the \ was very helpful. However it does not work for the following :slight_smile:

A.1 what bank or building society are you complaining about? Company who sold the policy:: Barclays
A.2 Account number of your packaged bank account?
: 12345678

How can I extract the result for these?

Dots, question marks and asterisks are regex tokens. These special characters are often called "metacharacters". Most of them are errors when used alone. If you want to use any of these characters as a literal in a regex, you need to escape them with a backslash. If you want to match 1+1=2, the correct regex is 1\+1=2. Otherwise, the plus sign has a special meaning.

May I suggest two very useful sites?

The best site to learn regex: https://www.regular-expressions.info/

The best site to test and debug your expressions: https://regex101.com/

2 Likes