I have field which is having sequence number .I want to check if it is valid and make a new field that will give if sequence number field is valid/invalid . Format is like "EH12839911" 10 digits first two letters alphabet while next 8 are digits.
hey @chitreshkumar
try this run anywhere search
| makeresults | eval sequence="EH12839911" | append [| makeresults | eval sequence="EH12831421"] | append [| makeresults | eval sequence="3512839911"] |eval status=if(match(sequence,"^[A-Za-z]{2}[0-9]{8}"),"Valid","Invalid")
Ideally in your environment you should write
<your_base_search> | eval status=if(match(sequence,"^[A-Za-z]{2}[0-9]{8}"),"Valid","Invalid")
Let me know if this works!
hey @chitreshkumar
try this run anywhere search
| makeresults | eval sequence="EH12839911" | append [| makeresults | eval sequence="EH12831421"] | append [| makeresults | eval sequence="3512839911"] |eval status=if(match(sequence,"^[A-Za-z]{2}[0-9]{8}"),"Valid","Invalid")
Ideally in your environment you should write
<your_base_search> | eval status=if(match(sequence,"^[A-Za-z]{2}[0-9]{8}"),"Valid","Invalid")
Let me know if this works!