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,
Extract string from a column?
-
- Posts: 1
- Joined: 28 May 2016, 08:16
Re: Extract string from a column?
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
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