Hi
I have created a Field Called "DESTINATION" in this field i have the values like this..
Banglore
Bombay
Karantaka
Kerala
....
...
etc.
Now i wanted this list of fields to be broken down in to two sets
1.One Set that contains all the names that start with "K" and 2.other set that contains all the names that start with "B" .
i have tried using like this..
myseach | rex field=DESTINATION "^K(?
but didnt work ?
Please help..
Various ways to do it. I would probably use like() function from eval. You could put it in within a stats command:
myseach | stats values(eval(if(like(DESTINATION,"K%"), DESTINATION,NULL))) as begins_with_K, values(eval(if(like(DESTINATION,"B%"), DESTINATION,NULL))) as begins_with_B
You have empty matching groups. You probably want something like .*
in them in order to actually match anything.
can we Create fields by Searching the strings.ie i have a fields which has certain values like "rammohan,tejaram,sriram,rakesh,...etc"..
Now can i create a Field Such that it extracts only the names from the above field who has the value "ram"
i.e Field2 should contain rammohan,tejaram,sriram only..