Taking a certain value from a different line in a text file

Question

Hello I have a text file that has this structure: 123456789|2|3|4|2016-09-24-02:56:00|b|123|c|G|24 Sep 2016 02:55:35|x 1|2|3 4|5|6 END-OF-LINE 123456789|7|3|4|2016-09-24-02:56:00|b|123|c|G|24 Sep 2016 02:42:35|y 7|8|9 1|4|5 END-OF-LINE Records I want to take the value of the date which is in index 10 (24 Sep 2016 02:42:35) and put it in a variable named y and then use it depending on the file structure Sometimes the file only consists of this 123456789|2|3|4|2016-09-24-02:56:00|b|123|c|G|24 Sep 2016 02:55:35|x 1|2|3 4|5|6 END-OF-LINE I made a snippet for this using the help of your Answers but now the value that is written in the variable y is always the same how can i change it depending on the line i am reading from. In other words. If i am reading from this line: 123456789|2|3|4|2016-09-24-02:56:00|b|123|c|G|24 Sep 2016 02:55:35|x Variable Y should equals 24 Sep 2016 02:55:35 else If i am reading from this 123456789|7|3|4|2016-09-24-02:56:00|b|123|c|G|24 Sep 2016 02:42:35|y Variable Y should equals 24 Sep 2016 02:42:35 Here is the snippet. Thanks in Advance There is something wrong in the code that it is getting always the last value of y. Is the value y correctly taken from the file? var templines1 = File.ReadAllLines(fileName).ToList(); var fields3 = templines1[0].Split( '|' ); while (currentLine1 { // Peek ahead for the END-OF-LINE to get the name of the file. int terminatorLine1 = templines1.IndexOf( END-OF-LINE  currentLine1); if (terminatorLine1 break ; // If not found or no penultimate line int penultimateLine1 = currentLine1; //Console.WriteLine(fields3[0]); if (fields3[0].Length == 9) { //Console.WriteLine(True); var fields1 = templines1[penultimateLine1].Split( '|' ); // get the comma separated fields y = fields1[10]; allY.Add(y); // var list = new List (Enumerable.Range(0 50)); } currentLine1 = terminatorLine1 + 1; }

Madhanmohan Devarajan · Answer

Please try like this. If you want to read each list dates item then you have to use foreach like show below. Also you need to decide on what to do with the final y value because everytime the y value changes as item in the dates list is looped thru. Matchzi=Regex.Match(); List dates=File .ReadAllLines(fileName) .Where(v=>{zi=Regex.Match(v@(? .Select(v=>zi.Value) .ToList() ; //ConvertingdatetothenewFormat - y is each item in the list foreach (var y in dates) { //Takingdateandperformingoperationonit string[]month={JanFebMarAprMayJunJulAugSepOctNovDec}; y=y.Replace(-).Replace(:.); //Console.WriteLine(SomeGlobalVariables.yy); for(intm=0;m { if(y.Contains(month[m])) { intmonthInDigit_int=DateTime.ParseExact(month[m]MMMCultureInfo.CurrentCulture).Month; stringmonthInDigit=monthInDigit_int.ToString(); y=y.Replace(month[m]monthInDigit.PadLeft(2'0')); } } y=y.Remove(101).Insert(10.); y=SwapCharacters(y03); y=SwapCharacters(y14); //mention here what you are going to do with y } //Inthesamemethod: stringname=string.Format(@C:\Users\HRG786\Desktop\{0}+.+rslt+.+yfields2[1]);//makeanameoutofthesecondfield.

Hesham Hassanein · Answer

I tried this already but how can i call y in the second function that has string name?

Madhanmohan Devarajan · Answer

Hesham From your code i have understood that DoOperation will not return the new y value since the function is void. In order to get the return value the function declaration should be changed as shown below. Step: 1 dates.ForEach(DoOperation(dt)) ; // call the new function like this Step: 2 //Takingdateandperformingoperationonit function DoOperation( string y){ Step: 3 also while ending the function you need to return the y value like shown below. y=SwapCharacters(y03) y=SwapCharacters(y14); return y; } H ope it will solve your issue.

Hesham Hassanein · Answer

I made this snippet that takes the date from the columns and do operations on it. But how can i use each value of the date after i formatted it and put it in string name What should i do with y that has the formatted date in order to have a name which contains each formatted date each time. y is not recognized in string name because it is declared in the method DoOperation Matchzi=Regex.Match(    ); List string >dates=File .ReadAllLines(fileName) .Where(v=>{zi=Regex.Match(v@ (? ); return zi.Success;}) .Select(v=>zi.Value) .ToList() ; dates.ForEach(DoOperation); //ConvertingdatetothenewFormat //Inthesamemethod: string name= string .Format(@ C:\Users\HRG786\Desktop\{0} + . + rslt + . +yfields2[1]); //makeanameoutofthesecondfield. //Takingdateandperformingoperationonit static void DoOperation( string y){ string []month={ Jan  Feb  Mar  Apr  May  Jun  Jul  Aug  Sep  Oct  Nov  Dec }; y=y.Replace(   - ).Replace( :  . ); //Console.WriteLine(SomeGlobalVariables.yy); for ( int m=0;m { if (y.Contains(month[m])) { int monthInDigit_int=DateTime.ParseExact(month[m] MMM CultureInfo.CurrentCulture).Month; string monthInDigit=monthInDigit_int.ToString(); y=y.Replace(month[m]monthInDigit.PadLeft(2 '0' )); } } y=y.Remove(101).Insert(10 . ); y=SwapCharacters(y03); y=SwapCharacters(y14); }

Madhanmohan Devarajan · Answer

Hesham Are you saying that variable y is always taking value y after the | from the below line? 123456789|7|3|4|2016-09-24-02:56:00|b|123|c|G|24 Sep 2016 02:42:35|y If yes then you should try this //Console.WriteLine(True); var fields1 = templines1[penultimateLine1].Split( '|' ); // get the comma separated fields y = fields1[9]; // instead of fields1[10]