Xbase++

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.

Xbase++

LOCAL nSuccess
LOCAL oCsv
LOCAL nCol
LOCAL nWeightColumn

nSuccess := 0

oCsv := CreateObject("Chilkat.Csv")

//  Load the following CSV:

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

//  Indicate that the 1st line contains column names.
oCsv:HasColumnNames := 1
nSuccess := oCsv:LoadFile("qa_data/csv/insertColumnTest.csv")

//  We can insert a column before the 1st column.
oCsv:InsertColumn(0)

? oCsv:SaveToString()

//  The CSV now looks like this:

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

//  Set the cells in column 0.

nCol := 0
oCsv:SetColumnName(nCol, "id")
oCsv:SetCell(0, nCol, "100")
oCsv:SetCell(1, nCol, "101")

? oCsv:SaveToString()

//  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.
nWeightColumn := oCsv:GetIndex("Weight")
? "Weight Column Index = " + Str(nWeightColumn)
oCsv:InsertColumn(nWeightColumn)

? oCsv:SaveToString()

//  We now have:

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

//  Set the cells in the new column:

oCsv:SetColumnName(nWeightColumn, "Height")
oCsv:SetCell(0, nWeightColumn, '6' 2"')
oCsv:SetCell(1, nWeightColumn, '5' 7"')

? oCsv:SaveToString()

//  We now have:

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

oCsv:destroy()