Unicode C

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.

Unicode C

#include <C_CkCsvW.h>

void ChilkatSample(void)
    {
    BOOL success;
    HCkCsvW csv;
    int col;
    int weightColumn;

    success = FALSE;

    csv = CkCsvW_Create();

    // Load the following CSV:

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

    // Indicate that the 1st line contains column names.
    CkCsvW_putHasColumnNames(csv,TRUE);
    success = CkCsvW_LoadFile(csv,L"qa_data/csv/insertColumnTest.csv");

    // We can insert a column before the 1st column.
    CkCsvW_InsertColumn(csv,0);

    wprintf(L"%s\n",CkCsvW_saveToString(csv));

    // The CSV now looks like this:

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

    // Set the cells in column 0.

    col = 0;
    CkCsvW_SetColumnName(csv,col,L"id");
    CkCsvW_SetCell(csv,0,col,L"100");
    CkCsvW_SetCell(csv,1,col,L"101");

    wprintf(L"%s\n",CkCsvW_saveToString(csv));

    // 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.
    weightColumn = CkCsvW_GetIndex(csv,L"Weight");
    wprintf(L"Weight Column Index = %d\n",weightColumn);
    CkCsvW_InsertColumn(csv,weightColumn);

    wprintf(L"%s\n",CkCsvW_saveToString(csv));

    // We now have:

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

    // Set the cells in the new column:

    CkCsvW_SetColumnName(csv,weightColumn,L"Height");
    CkCsvW_SetCell(csv,0,weightColumn,L"6' 2\"");
    CkCsvW_SetCell(csv,1,weightColumn,L"5' 7\"");

    wprintf(L"%s\n",CkCsvW_saveToString(csv));

    // We now have:

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


    CkCsvW_Dispose(csv);

    }