Zig

CSV Insert Column

See more CSV Examples

Insert a new column into an existing CSV.

Note: This example requires Chilkat v9.5.0.89 or greater because the InsertColumn method was added in v9.5.0.89.

Zig

const std = @import("std");
const chilkat = @import("chilkat");

pub fn main(init: std.process.Init) !void {
    const alloc = init.arena.allocator();

    const csv = try chilkat.Csv.init();
    defer csv.deinit();

    // Load the following CSV:

    //  Name;City;Weight
    //  John;Chicago;180
    //  Lisa;Denver;120

    // Indicate that the 1st line contains column names.
    csv.setHasColumnNames(true);
    try csv.loadFile("qa_data/csv/insertColumnTest.csv");

    // We can insert a column before the 1st column.
    csv.insertColumn(0) catch {};

    std.debug.print("{s}\n", .{try csv.saveToString(alloc)});

    // The CSV now looks like this:

    //  ;Name;City;Weight
    //  ;John;Chicago;180
    //  ;Lisa;Denver;120

    // Set the cells in column 0.

    const col = 0;
    csv.setColumnName(col, "id") catch {};
    csv.setCell(0, col, "100") catch {};
    csv.setCell(1, col, "101") catch {};

    std.debug.print("{s}\n", .{try csv.saveToString(alloc)});

    // We now have:

    //  id;Name;City;Weight
    //  100;John;Chicago;180
    //  101;Lisa;Denver;120

    // Insert a new column between City and Weight
    // In other words, add a new column before the Weight column.
    const weight_column = csv.getIndex("Weight");
    std.debug.print("Weight Column Index = {d}\n", .{weight_column});
    csv.insertColumn(weight_column) catch {};

    std.debug.print("{s}\n", .{try csv.saveToString(alloc)});

    // We now have:

    //  id;Name;City;;Weight
    //  100;John;Chicago;;180
    //  101;Lisa;Denver;;120

    // Set the cells in the new column:

    csv.setColumnName(weight_column, "Height") catch {};
    csv.setCell(0, weight_column, "6' 2\"") catch {};
    csv.setCell(1, weight_column, "5' 7\"") catch {};

    std.debug.print("{s}\n", .{try csv.saveToString(alloc)});

    // We now have:

    //  id;Name;City;Height;Weight
    //  100;John;Chicago;"6' 2""";180
    //  101;Lisa;Denver;"5' 7""";120
}