%msg% property how to convert spaces to commas

Support, Questions and Discussions on WinSyslog

Moderator: alorbach

Google Ads


%msg% property how to convert spaces to commas

Postby drgarner » Tue Jan 07, 2014 3:52 pm

I have read the docs but cannot find an answer. In the %msg% property for formatting output how do I specify that all spaces (0x20) should be converted to a comma (0x2C). My firewall outputs fields that are space delimited per message and I would like to replace the spaces with commas and name the file extension .csv so I can launch the resulting file directly in Excel. Thanks.
drgarner
New
 
Posts: 1
Joined: Tue Jan 07, 2014 3:40 pm

Re: %msg% property how to convert spaces to commas

Postby alorbach » Wed Jan 08, 2014 4:05 pm

Hi,

this might be difficult because we do not have a find & replace function within the property replacer.
Could you post some sample lines from your Firewall? Perhaps we can workout some rules for the Post-Process Event Action. Once we have split the input syslog messages into properties using Post-Process Event, we can output a valid CSV Format.

best regards,
Andre Lorbach
alorbach
Site Admin
 
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

Google Ads



Return to WinSyslog

Who is online

Users browsing this forum: No registered users and 0 guests

cron