topic Re: How to split single field value into two different values? in Getting Data In

How to split single field value into two different values?

alex389 — Sun, 15 Jul 2018 08:08:59 GMT

Hello,

I'm trying to split a single value of a result which is 5231562. I want to be able to split this number into two different values.

i.e

Field0 5231562 becomes -
Field1 = 52
Field2 = 31562

Thank you

niketn — Sun, 15 Jul 2018 12:19:23 GMT

@alex389 if you always want field1 to be first two digits you can write the following rex:

<yourCurrentSearch>
| rex field=field0 "^(?<field1>\d{2})(?<field2>.*)"

Following is a run anywhere search based on sample data and details.

| makeresults
| eval field0="5231562"
| rex field=field0 "^(?<field1>\d{2})(?<field2>.*)"

renjith_nair — Sun, 15 Jul 2018 12:19:47 GMT

Hi @alex389,

If you just want to split , you could use substr. Lets know in case you need any logic for the first two digits

|stats count|fields - count|eval Field0=5231562|eval Field1=substr(Field0,0,2),Field2=substr(Field0,3)

woodcock — Sun, 15 Jul 2018 14:48:20 GMT

Like this:

... | rex field=Field0 "^(?<Field1>\d{2})(?<Field2>\d+)$"

alex389 — Mon, 16 Jul 2018 08:34:46 GMT

Thank you all

woodcock — Mon, 16 Jul 2018 14:19:23 GMT

Don't forget to UpVote, too!