I have a xml file which I want to convert to a csv, but do not work regular expressions.
> inputs.conf
> [monitor:\\SPLUNK0\C$\test\1]
> index = kasper
> _whitelist = .*\.xml
>
> props.conf [source::...kasper*.xml]
> TRUNCATE = 0
> SEDCMD-1 = s/(?m)(^.*?</Worksheet>)//g ###clean the garbage
> SEDCMD-2 = s/(?m)(<W\w*\s\w*\SN\w*[="]+M\w*.*>$)//g ####clean the garbage
> SEDCMD-3 = s/(?m)(</R\w*>)/\n/g ###transfer the event to a new line
> SEDCMD-4 = s/(?m)(</D\w*>)/;/g ### set separators
> SEDCMD-5 = s/(?m)(<[^>]*>)//g ### delete tags
> sourcetype = csv_kasper
> transforms.conf
> [csv_kasper]
> DELIMS=";"
> FIELDS="Status","V-host","Group","Computer","LastData","description","IP","Alive","Domain","NetBIOS","DomainName","DNS"
splunkd.log
12-06-2012 18:55:47.043 +0300 ERROR regexExtractionProcessor - Error while parsing sed name="SEDCMD-1", string="s/(?m)(^.*?</Worksheet>)//g", errMsg="Failed to initialize sed. Invalid option string: /g"
12-06-2012 18:55:47.043 +0300 ERROR regexExtractionProcessor - Error while parsing sed name="SEDCMD-3", string="s/(?m)(</R\w*>)/\n/g", errMsg="Failed to initialize sed. Invalid option string: \n/g"
12-06-2012 18:55:47.043 +0300 ERROR regexExtractionProcessor - Error while parsing sed name="SEDCMD-4", string="s/(?m)(</D\w*>)/;/g", errMsg="Failed to initialize sed. Invalid option string: ;/g
... View more