Copy link to clipboard
Copied
Need help with a GREP expression to select all the characters inbetween a word, and a number. Here is the sample string I'm trying to select (and delete) from a catalog, in every place it appears:
RETAIL $109.00 | WHSL $54.50
The dollar values change throughout the catalog, but this string alwasy begins with "RETAIL" and ends with "0"
Thanks!
^RETAIL.+0$
Copy link to clipboard
Copied
^RETAIL.+0$
Copy link to clipboard
Copied
AMAZING!
Thank you for that expression. Worked perfectly!!!
Copy link to clipboard
Copied
It's not clear what you're looking to do here - what are you trying to delete?
A positive lookbehind will find the word RETAIL
(?<=RETAIL).+?\d+\.\d{2}
Should find all the text from RETAIL up to 0 at the end of the first price.
Is that what you want?