hi. i am creating a new csv file pro grammatically in C# where i am going to take values from a csv file that is already present with me.
consisder this csv file,
firstname,lastname,middle,company,email
xxxxxx,xxxxxxx,xxxxx,xxxxxxx,xxxxx
yyyyyy,yyyyyy,yyyyyy,yyyyyy,yyyyyy
zzzzzz,zzzzzz,zzzzzz,zzzzzz,zzzzzz
I need to read certain values from each row of this file and then do some coding for each value and create a whole new csv file with these new values.
like when i read the company column of row 1, then i need to code some function where i will need to specify where this company is located.
how can i read each value and and create a new csv with my functions for the new columns in the csv?
i tried csv parser but not much help.
Any suggestions?