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); }