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?
paulcristo:
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?
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:
(?m)^.+?"(\w+)"
Example output:
Right on all counts! Your solution worked great. Thank you for the help.
1 Like