I am working on dbconnect.(MYSQL Connection)
I have a table in which there is column as below:-
I need to extract the values contained in the above column and add it to 3 columns
Column1 : DummyValue
Column 3: dummyuser
NOTE- I have tried using REGEXP_SUBSTR but it was showing error:-REGEXP_SUBSTR is not recognised as built in function name
| eval _raw="DATA
DummyValue Host= dummyhost123 |User= dummyuser"
| multikv forceheader=1 | rex field=DATA "(?ms)(?<col1>\S+)\s\S+ (?<col2>\S+) \S+\s(?<col3>\S+)"
Thank you for the response.
I am looking for a way via sql query so that once we have the data in splunk it is in appropiate form.
IS there a way in which this can be extracted while creating inputs in db connect ??