Thanks a lot for your reply. Indeed your answer is correct and works for the particular scenario that I have described. However I should have mentioned that I would like to support different types of expressions.
For example "FR-*" and "**-MARSEILLE".
I could have :
ORDERID Amount Location 1 50 FR-PARIS 2 20 FR-NICE 3 12 IT-ROME 4 56 IT-MILAN 5 34 XX-MARSEILLE
Group Expression FRANCE FR-* ITALY IT-* MRS **-MARSEILLE
I would like to obtain this table at the end:
ORDERID Amount Location Group 1 50 FR-PARIS FRANCE 2 20 FR-NICE FRANCE 3 12 IT-ROME ITALY 4 56 IT-MILAN ITALY 5 34 XX-MARSEILLE MRS
Take a look at this as well.
let us know ho you do
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.