You could use the open source Nuget package CSVHelper to get the data from the file.
class Program
{
static void Main(string[] args)
{
var config = new CsvConfiguration(CultureInfo.InvariantCulture)
{
HasHeaderRecord = false,
};
List<SongData> records = null;
using (var reader = new StreamReader("Csv File.csv"))
{
using (var csv = new CsvReader(reader, config))
{
records = csv.GetRecords<SongData>().ToList();
}
}
foreach(var song in records)
{
Console.WriteLine($"{song.Artist} - {song.SongName}");
}
}
}
public class SongData
{
[Index(1)]
public string Artist { get; set; }
[Index(12)]
public string SongName { get; set; }
}
Then you could write the data to a new file. There are examples on writing a new file in the CSVHelper link above.