How to change Headline in Linq

Björn Kreye

var lines = File.ReadLines(readFolderFile, Encoding.Default)
.Select((line, index) => new { Line = line.Trim(';'), LineNumber = index + 1 })
.Where(x => !String.IsNullOrWhiteSpace(x.Line))
.Select(x => $"{x.LineNumber};{x.Line};");

Hi Guys the code above I use to read files and then put them as strings into a IEnumerable.

I just have the problem that all first rows should be HeadLines but in my LineNumber column im getting 1 as the name is there a way to change that and write "RowNumber" instead?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews8y ago
Accepted answer
Below code will make 1st row as harcoded "RowNumber". See the condition put and also to convert LineNumber as string type

var lines = File.ReadLines(@"e:\jaish\Notes.txt", Encoding.Default).Select((line, index) => new { Line = line.Trim(';'), LineNumber = index.ToString().Equals("0", StringComparison.CurrentCultureIgnoreCase) ? "RowNumber" : (index + 1).ToString() }).Where(x => !String.IsNullOrWhiteSpace(x.Line)).Select(x => $"{x.LineNumber};{x.Line};");
+2
Björn Kreye8y ago
Hi Jaish right now ienumerable looks like this: 1;Name;Zip... 2;Name;Zip... But I would like it to be: RowNumber;Name;Zip... 2;Name;Zip...
0
Jaish Mathews8y ago
I didn't get. If you put sample file content and then expected output would be great.
0