Page 1 of 1

Extract string from a column?

Posted: 24 May 2016, 14:16
by 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,

Re: Extract string from a column?

Posted: 28 May 2016, 08:21
by 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