Numerical range format

Matias Perez

January 27, 2020 18:07

I need to extract a range of numbers from a field.

field: "score:0" (the number varies from 1 to 100)

Thanks.

0

Comments

1 comment

Kevin Keech

February 28, 2020 18:35
You can first parse the value
```
| parse "\"score:*\"" as score
```
If you want to then display where that score value is within a range you can add a where condition after the parsing.
```
| parse "\"score:*\"" as score
| where (score >= 1 and score <= 100)
```
0

Comment actions Permalink

Please sign in to leave a comment.