Extract string from a column?

[Kinjal]

Hi,
I have record with three columns
ID TYPE Deal
01 A Member As Year-2015
02 B Member As Year-2014
03 A Member As Year-2014
I only want year part from field Deal How to write a query?
Thanks,

[Neeraj Kumar123]

Try the below option. It'll create a new field named year with the information you asked for:
1. your search here
2. rex field=DESC "(?<year>Year\-\d{4})"
Answer Source:If you wish to gain more knowledge about particular subject please visit:intellipaat