(Node.js) CSV Delete Column

Demonstrates the DeleteColumn method.

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOSX, and ARM

var os = require('os');
if (os.platform() == 'win32') {  
    if (os.arch() == 'ia32') {
        var chilkat = require('@chilkat/ck-node21-win-ia32');
    } else {
        var chilkat = require('@chilkat/ck-node21-win64'); 
    }
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node21-arm');
    } else if (os.arch() == 'x86') {
        var chilkat = require('@chilkat/ck-node21-linux32');
    } else {
        var chilkat = require('@chilkat/ck-node21-linux64');
    }
} else if (os.platform() == 'darwin') {
    if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node21-mac-m1');
    } else {
        var chilkat = require('@chilkat/ck-node21-macosx');
    }
}

function chilkatExample() {

    // We have the following CSV...

    // permalink,company,numEmps,category,city,state,fundedDate,raisedAmt,raisedCurrency,round
    // lifelock,LifeLock,,web,Tempe,AZ,1-May-07,6850000,USD,b
    // mycityfaces,MyCityFaces,7,web,Scottsdale,AZ,1-Jan-08,50000,USD,seed
    // flypaper,Flypaper,,web,Phoenix,AZ,1-Feb-08,3000000,USD,a
    // infusionsoft,Infusionsoft,105,software,Gilbert,AZ,1-Oct-07,9000000,USD,a
    // gauto,gAuto,4,web,Scottsdale,AZ,1-Jan-08,250000,USD,seed
    // chosenlist-com,ChosenList.com,5,web,Scottsdale,AZ,1-Oct-06,140000,USD,seed
    // digg,Digg,60,web,San Francisco,CA,1-Oct-05,2800000,USD,a
    // facebook,Facebook,450,web,Palo Alto,CA,1-Sep-04,500000,USD,angel
    // facebook,Facebook,450,web,Palo Alto,CA,1-May-05,12700000,USD,a
    // photobucket,Photobucket,60,web,Palo Alto,CA,1-May-06,10500000,USD,b
    // omnidrive,Omnidrive,,web,Palo Alto,CA,1-Dec-06,800000,USD,angel
    // geni,Geni,18,web,West Hollywood,CA,1-Jan-07,1500000,USD,a
    // twitter,Twitter,17,web,San Francisco,CA,1-Jul-07,5400000,USD,b
    // stumbleupon,StumbleUpon,,web,San Francisco,CA,1-Dec-05,1500000,USD,seed
    // gizmoz,Gizmoz,,web,Menlo Park,CA,1-May-07,6300000,USD,a
    // mahalo,Mahalo,40,web,Santa Monica,CA,1-Jan-06,5000000,USD,a

    var success;
    var bCrlf = true;
    var sb = new chilkat.StringBuilder();
    sb.AppendLine("permalink,company,numEmps,category,city,state,fundedDate,raisedAmt,raisedCurrency,round",bCrlf);
    sb.AppendLine("lifelock,LifeLock,,web,Tempe,AZ,1-May-07,6850000,USD,b",bCrlf);
    sb.AppendLine("mycityfaces,MyCityFaces,7,web,Scottsdale,AZ,1-Jan-08,50000,USD,seed",bCrlf);
    sb.AppendLine("flypaper,Flypaper,,web,Phoenix,AZ,1-Feb-08,3000000,USD,a",bCrlf);
    sb.AppendLine("infusionsoft,Infusionsoft,105,software,Gilbert,AZ,1-Oct-07,9000000,USD,a",bCrlf);
    sb.AppendLine("gauto,gAuto,4,web,Scottsdale,AZ,1-Jan-08,250000,USD,seed",bCrlf);
    sb.AppendLine("chosenlist-com,ChosenList.com,5,web,Scottsdale,AZ,1-Oct-06,140000,USD,seed",bCrlf);
    sb.AppendLine("digg,Digg,60,web,San Francisco,CA,1-Oct-05,2800000,USD,a",bCrlf);
    sb.AppendLine("facebook,Facebook,450,web,Palo Alto,CA,1-Sep-04,500000,USD,angel",bCrlf);
    sb.AppendLine("facebook,Facebook,450,web,Palo Alto,CA,1-May-05,12700000,USD,a",bCrlf);
    sb.AppendLine("photobucket,Photobucket,60,web,Palo Alto,CA,1-May-06,10500000,USD,b",bCrlf);
    sb.AppendLine("omnidrive,Omnidrive,,web,Palo Alto,CA,1-Dec-06,800000,USD,angel",bCrlf);
    sb.AppendLine("geni,Geni,18,web,West Hollywood,CA,1-Jan-07,1500000,USD,a",bCrlf);
    sb.AppendLine("twitter,Twitter,17,web,San Francisco,CA,1-Jul-07,5400000,USD,b",bCrlf);
    sb.AppendLine("stumbleupon,StumbleUpon,,web,San Francisco,CA,1-Dec-05,1500000,USD,seed",bCrlf);
    sb.AppendLine("gizmoz,Gizmoz,,web,Menlo Park,CA,1-May-07,6300000,USD,a",bCrlf);
    sb.AppendLine("mahalo,Mahalo,40,web,Santa Monica,CA,1-Jan-06,5000000,USD,a",bCrlf);

    var csv = new chilkat.Csv();

    // Indicate that the 1st line contains column names.
    csv.HasColumnNames = true;
    success = csv.LoadFromString(sb.GetAsString());

    // Delete the "city" column, which is at index 4.  (the 1st column is at index 0)
    success = csv.DeleteColumn(4);

    console.log(csv.SaveToString());

    // Output is:

    // permalink,company,numEmps,category,state,fundedDate,raisedAmt,raisedCurrency,round
    // lifelock,LifeLock,,web,AZ,1-May-07,6850000,USD,b
    // mycityfaces,MyCityFaces,7,web,AZ,1-Jan-08,50000,USD,seed
    // flypaper,Flypaper,,web,AZ,1-Feb-08,3000000,USD,a
    // infusionsoft,Infusionsoft,105,software,AZ,1-Oct-07,9000000,USD,a
    // gauto,gAuto,4,web,AZ,1-Jan-08,250000,USD,seed
    // chosenlist-com,ChosenList.com,5,web,AZ,1-Oct-06,140000,USD,seed
    // digg,Digg,60,web,CA,1-Oct-05,2800000,USD,a
    // facebook,Facebook,450,web,CA,1-Sep-04,500000,USD,angel
    // facebook,Facebook,450,web,CA,1-May-05,12700000,USD,a
    // photobucket,Photobucket,60,web,CA,1-May-06,10500000,USD,b
    // omnidrive,Omnidrive,,web,CA,1-Dec-06,800000,USD,angel
    // geni,Geni,18,web,CA,1-Jan-07,1500000,USD,a
    // twitter,Twitter,17,web,CA,1-Jul-07,5400000,USD,b
    // stumbleupon,StumbleUpon,,web,CA,1-Dec-05,1500000,USD,seed
    // gizmoz,Gizmoz,,web,CA,1-May-07,6300000,USD,a
    // mahalo,Mahalo,40,web,CA,1-Jan-06,5000000,USD,a

}

chilkatExample();