Hi,
In one of my numeric field sometimes I am getting value as " * ". I want to replace it with either NA or NULL if its " * ".
I am looking to add this regex in data model.
hey @goyals05
you can try this run anywhere search
| makeresults
| eval raw="* 20 30 04 3 2 5 *"
| makemv raw
| mvexpand raw
| rex field=raw mode=sed "s/\*/NA/g"
OR
| makeresults
| eval raw="* 20 30 04 3 2 5 *"
| makemv raw
| mvexpand raw
| eval raw1=case(raw="*","NA",1=1,raw)
Also in your environment, you should write in eval expression of data model
case(raw="*","NA",1=1,raw)
you can try anyone of these. which one you like bro? 🙂
let me know if this helps!
hey @goyals05
you can try this run anywhere search
| makeresults
| eval raw="* 20 30 04 3 2 5 *"
| makemv raw
| mvexpand raw
| rex field=raw mode=sed "s/\*/NA/g"
OR
| makeresults
| eval raw="* 20 30 04 3 2 5 *"
| makemv raw
| mvexpand raw
| eval raw1=case(raw="*","NA",1=1,raw)
Also in your environment, you should write in eval expression of data model
case(raw="*","NA",1=1,raw)
you can try anyone of these. which one you like bro? 🙂
let me know if this helps!
Not sure if 1st one can be used in data model. But 2nd option worked for me. Cheers!!