Typescript - Read CSV column by column

Question

I am trying to read csv in typescript column by column.

The csv is like below:

Prefix,Suffix
Mr,Jr
Mrs,Sr

Based on few SO questions and typescript documentation, I am able to read from file like:

public readConfig() {
    const results: any[] = [];

    fs.createReadStream('D:/NameConfig.csv')
        .pipe(csv())
        .on('data', (data: any) => results.push(data))
        .on('end', () => {
            return results;
        });
}

But, this reads the entire csv. I am unable to save the individual columns like Prefix and Suffix as individual array. How can I achieve the same?

Mike · Accepted Answer · 2022-03-01 15:14:35Z

1

I have consumed the columns like below and have that added in a list and retrieved later.

public readConfig() {
    fs.createReadStream('D:/NameConfig.csv')
        .pipe(csv())
        .on('data', (data: any) => {
            prefixList.push(data["PREFIX"]);
            suffixList.push(data["SUFFIX"]);
        });
}

answered Mar 1, 2022 at 15:14

Mike

8113 gold badges22 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Typescript - Read CSV column by column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related