Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
OMC HOW-TO: Easily Create a CSV Log Parser — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OMC HOW-TO: Easily Create a CSV Log Parser

Question
12
Views
0
Comments
edited Dec 31, 2018 12:40PM in Management

Summary

A simple way to create a log analytics log parser for CSV or other delimited files

Content

When creating a regex parse expression for a CSV delineated file, one approach that works fairly well is to use a series of regex captures like this:

([^,]*),

 

What this means is capture anything that is not a comma up until there is a comma following. You can then chain as many of these together as you need to capture the given log. In the example above, it shows 5 columns, so you would have a regex expression like this:

{TIMEDATE},([^,]*),([^,]*),([^,]*),([^,]*)

Note that you leave the comma off at the end.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!