csv

All posts tagged csv by Linux Bash
  • Posted on
    Featured Image
    The blog post explains how to convert `git log` output into a structured CSV file using `awk` and regular expressions. It covers the initial setup of Git and `awk` on Linux, customizing `git log` output, and detailed `awk` scripting examples for formatting and refining the data, ensuring its integrity in CSV format. The tutorial demonstrates both basic and advanced uses of `awk` for effective data parsing suitable for further analysis or manipulation.
  • Posted on
    Featured Image
    The article explains how to convert `sar` output into a CSV format on Linux systems to facilitate better trend analysis. The `sar` command is part of the sysstat package and captures key system performance metrics. By using CSV format, the data becomes easily manageable with tools like Excel or Python, enhancing data manipulation and visualization capabilities. The conversion process is detailed with a bash script example for effective transformation, making trend analysis more accessible for performance tuning and making informed decisions.
  • Posted on
    Featured Image
    The article explains how to use `awk` to parse CSV files with fields containing embedded commas, enclosed in quotes, in Linux systems. It discusses using the `FPAT` variable in `awk` to define what constitutes a field, thus avoiding the misinterpretation of commas as field separators. Examples are provided to demonstrate parsing files where quoted fields include commas, making `awk` essential for handling complex CSVs in various environments.