Hello, I have sql query from our db (sql creator) containing records as e.g.
Id; Source, CreationDate
1; WTT Australian Notice 123, 20190312
2; German Notice 12GG3 and VTS, 20190412
3; VMS and Canadian Notice 53T, 20190312
4; Canadian 78UU, 20190312
I want to use a regex stringseracher for the source attribute and assign a value based on the search result.
I have an excel table that contains the regex I want to search for in the db records and the value I want to assign e.g.
Regex; Country
Australian (Notices|Notice); AUSTRALIA
Brazilian (Notices|Notice); BRAZIL
Canadian|Canada (Notices|Notice); CANADA
How can I use this table as my regex string?
My output should look like
Id; Source, CreationDate; Country
1; WTT Australian Notice 123, 20190312; AUSTRALIA
2; German Notice 12GG3 and VTS, 20190412; null
3; VMS and Canadian Notice 53T, 20190312; CANADA
4; Canadian 78UU, 20190312; null
Thanks for your help!