RegEx finds inverse result in KM

Questions & Suggestions
1

I have a long list of ASINs formatted like this:

asin="0385353308"
asin="038549081X"
asin="0385543786"
asin="0593149092"

I use the RegEx expression (?<=").+?(?=") which on regex101.com finds:

0385353308 038549081X 0385543786 0593149092

But in KM it finds:

asin=""
asin=""
asin=""
asin=""

Any thoughts as to why?

2

Since you did not post your macro, I have to guess.
But I'm guessing that you are using a KM Search and Replace with that Regex.
It is matching the characters between the quotes, and replacing them with nothing.

This works for me:

image
(?m)^.+?"(\w+)"

Example output:

image

3

Right on all counts! Your solution worked great. Thank you for the help.

1 Like