(PowerBuilder) 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.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Csv
integer li_Success
integer li_Col
integer li_WeightColumn

loo_Csv = create oleobject
// Use "Chilkat_9_5_0.Csv" for versions of Chilkat < 10.0.0
li_rc = loo_Csv.ConnectToNewObject("Chilkat.Csv")
if li_rc < 0 then
    destroy loo_Csv
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// Load the following CSV:

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

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

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

Write-Debug loo_Csv.SaveToString()

// The CSV now looks like this:

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

// Set the cells in column 0.

li_Col = 0
loo_Csv.SetColumnName(li_Col,"id")
loo_Csv.SetCell(0,li_Col,"100")
loo_Csv.SetCell(1,li_Col,"101")

Write-Debug loo_Csv.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.
li_WeightColumn = loo_Csv.GetIndex("Weight")
Write-Debug "Weight Column Index = " + string(li_WeightColumn)
loo_Csv.InsertColumn(li_WeightColumn)

Write-Debug loo_Csv.SaveToString()

// We now have:

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

// Set the cells in the new column:

loo_Csv.SetColumnName(li_WeightColumn,"Height")
loo_Csv.SetCell(0,li_WeightColumn,"6' 2~"")
loo_Csv.SetCell(1,li_WeightColumn,"5' 7~"")

Write-Debug loo_Csv.SaveToString()

// We now have:

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


destroy loo_Csv