split multi line field

[aasabatini]

Hi Folks,

I need to split  a multiline field

-2.9416067
53.0374031
0.0

the first line is latitude e the second line is longitude,   is possible extract these two fields from this multi-line field?

[ashvinpandey · Accepted solution]

@aasabatini Try adding the below query:

| eval latitude=mvindex(Company_Name,0), longitude=mvindex(Company_Name,1)
| table Company_Name latitude longitude

Also, If this reply helps you, an upvote would be appreciated.

[aasabatini]

Thanks @ashvinpandey