cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Seperate content of the logs in different fields,

abhi_03
Newcomer

I am looking for parse command to seperate below content from the logs, those are comma seperated 

 

 

INSERT,STATISTIC,,"205456",679,"","SmSyServerPlugin","",59998,"DBP_Total_Request_Sent_Count","oioujio|ALL",0,0,0,0,0,"",1713015899987,0,"sgy",0,0,0,PC,0,0,0,0,0

 

 

2 REPLIES 2

AntonPineiro
DynaMight Guru
DynaMight Guru

Hi,

You have here a Dynatrace Pattern Language example.

If you are in Grail, I recommend you DPL Architect.

Best regards

❤️ Emacs ❤️ Vim ❤️ Bash ❤️ Perl

PacoPorro
Dynatrace Champion
Dynatrace Champion

Example:

data record(line = "INSERT,STATISTIC,,\"205456\",679,\"\",\"SmSyServerPlugin\",\"\",59998,\"DBP_Total_Request_Sent_Count\",\"oioujio|ALL\",0,0,0,0,0,\"\",1713015899987,0,\"sgy\",0,0,0,PC,0,0,0,0,0")
| fieldsAdd splitLine = splitString(line, ",")
| fieldsAdd field1 = splitLine[0], field2 = splitLine[1], field3 = splitLine[2]

Featured Posts