Extract string from a column?

Kinjal
Posts: 1
Joined: 24 May 2016, 14:14

Extract string from a column?

Postby Kinjal » 24 May 2016, 14:16

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
Posts: 1
Joined: 28 May 2016, 08:16

Re: Extract string from a column?

Postby Neeraj Kumar123 » 28 May 2016, 08:21

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

Return to “General Opensphere Topics”

Who is online

Users browsing this forum: No registered users and 1 guest