Hi there,
I have a string of letters in a title for different email headings, such as:
"Hurry now and get 30% off the Winter Sale!"
"Swimwear now reduced to £20, buy now!"
I'm trying to pull out the values for the percentage discount and currency discount into a column. I could split on the % or £ but I wanted to try using a RegEx expression to parse the 3 characters to the left (percentage discount) or right (currency discount) of the special characters (% £ $ €).
Does anyone know what this expression might be or how I could go about making these two extra columns that show the value of the discount?
Thank you!
Solved! Go to Solution.
Thanks for the reply! Could you possibly go through the RegEx syntax in your expression? I'm still trying to get to grips with the syntax.
Thank you!
F
Great, thank you! And thank you for the extra Regex link.
F