CSV Normalizer

Standard

CSV Normalizer normalizes the CSV logs separated by delimiters: comma, space, tab, semicolon, hash, and pipe.

Release Details

Version: 5.1.1

Release date: 2021-04-20

Supported On: LogPoint v6.7.0 and later

SHA 256: 1c956834c88477c200d701d5fd605c5ecf43557da34a4063dd335bd68c9d3791

Download

Package Details

Compiled Normalizer
- CSVNormalizer

Bug Fix

An issue in the compiled normalizer CSVNormalizer where the value of the field ending with _ts was not automatically captured in the date and time format has now been resolved.

Installation

Follow these steps to install the CSVNormalizer v5.1.1 application:

Download the CSVNormalizer_5.1.1.pak file from the Download section above.
Install the application by importing the pak file to LogPoint under Settings >> System >> Applications.

Past Releases

Change in CSVNormalizer v5.0.0 ▾

Version: 5.0.0

For LogPoint v6.0.0 to v6.6.6 ▾

Version: 3.0.0

Release date: 2018-09-13

Supported On: LogPoint v6.0.0 to v6.6.6

SHA 256: 50c12e240c8a34f224e883cbe7857d4afcef975cf6813d9fddff7315f0436eb3

Download

Log Formats

Expected Log Format

Comma-separated

Log Sample

54,"Web, Ads/Analytics",http,OBSERVED,TCP_NC_MISS,752,logpoint\\LogPoint%20Tech%20Team

Expected Log Format

Space-separated

Log Sample

54 "Web Ads/Analytics" http OBSERVED TCP_NC_MISS 752 "logpoint\\LogPoint%20Tech%20 Team"

Expected Log Format

Hash-separated

Log Sample

54#"Web# Ads/Analytics"#http#OBSERVED#TCP_NC_MISS#752#logpoint\\LogPoint%20Tech%20Team

Expected Log Format

Semicolon-separated

Log Sample

54;"Web; Ads/Analytics";http;OBSERVED;TCP_NC_MISS;752;logpoint\\LogPoint%20Tech%20Team

Expected Log Format

Pipe-separated

Log Sample

54|"Web| Ads/Analytics"|http|OBSERVED|TCP_NC_MISS|752|logpoint\\LogPoint%20Tech%20Team

Expected Log Format

Tab-separated

Log Sample

54 "Web Ads/Analytics" http OBSERVED TCP_NC_MISS 752 logpoint\\LogPoint%20Tech%20Team

Log Sample

54,"Web, Ads/Analytics",http,OBSERVED,TCP_NC_MISS,752,logpoint\\LogPoint%20Tech%20Team

Expected Log Format (1)

Space-separated

Log Sample

54 "Web Ads/Analytics" http OBSERVED TCP_NC_MISS 752 "logpoint\\LogPoint%20Tech%20 Team"

Expected Log Format (2)

Hash-separated

Log Sample

54#"Web# Ads/Analytics"#http#OBSERVED#TCP_NC_MISS#752#logpoint\\LogPoint%20Tech%20Team

Expected Log Format (3)

Semicolon-separated

Log Sample

54;"Web; Ads/Analytics";http;OBSERVED;TCP_NC_MISS;752;logpoint\\LogPoint%20Tech%20Team

Expected Log Format (4)

Pipe-separated

Log Sample

54|"Web| Ads/Analytics"|http|OBSERVED|TCP_NC_MISS|752|logpoint\\LogPoint%20Tech%20Team

Expected Log Format (5)

Tab-separated

Log Sample

54 "Web Ads/Analytics" http OBSERVED TCP_NC_MISS 752 logpoint\\LogPoint%20Tech%20Team

Support

If you have any questions or require assistance, create a support ticket.

CSV Normalizer

Release Details

Package Details

Bug Fix

Installation

Past Releases

Log Formats

Log Sample

Expected Log Format

Expected Log Format

Expected Log Format

Expected Log Format

Expected Log Format

Log Sample

Expected Log Format (1)

Expected Log Format (2)

Expected Log Format (3)

Expected Log Format (4)

Expected Log Format (5)

Support

Comments

Related articles