Generischer Converter für CSV Dateien

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

/// <summary>
/// Converts a CSV-File to any desired Format. The File is read line by line 
/// and splitted with the separator
/// </summary>
/// <typeparam name="TTarget">The type of the target.</typeparam>
/// <param name="filename">The filename.</param>
/// <param name="separator">The separator.</param>
/// <param name="predicate">The predicate determining wether a can row should be parsed</param>
/// <param name="projection">The projection.</param>
/// <returns></returns>
public static IEnumerable<TTarget> ConvertCsvTo<TTarget> (
	string filename,
	char separator, 			
	Predicate<int> predicate, 
	Func<string[], TTarget> projection ) 
{
	int rowCount = 0;			
	return from row in File.ReadAllLines ( filename )
		where predicate ( rowCount++ )
		let columns = row.Split ( separator )
		select projection ( columns );			
}