private static MovieAndActors MapCsvLines(string line)
{
MovieAndActors movieNActors = new MovieAndActors();
string[] columns = line.Split(",\"");
string[] columns2;
if (columns.Length.Equals(3))
{
columns2 = columns[2].Split(",");
movieNActors.Id = int.Parse(columns[0]);
movieNActors.MovieNames = columns2[1];
movieNActors.Actors = ExtractMovieActors(columns[2]);
}
else
{
columns2 = columns[0].Split(",");
movieNActors.Id = int.Parse(columns2[0]);
movieNActors.MovieNames = columns2[1];
movieNActors.Actors = ExtractMovieActors(columns[1]);
}
return(movieNActors);
}
private static MovieAndActors[] Transform(string[] csvLines)
{
MovieAndActors[] movieNActors = new MovieAndActors[csvLines.Length];
// iterate through string array
for (int index = 0; index < csvLines.Length; index++)
{
// skip the first line as it's a header
if (index > 0)
{
string line = csvLines[index];
// map the string array to a struct
movieNActors[index] = MapCsvLines(line);
}
}
return(movieNActors);
}
