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

Hesham Hassanein

10y908Visual Basic .NET

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 < templines1.Count)
{
// Peek ahead for the END-OF-LINE to get the name of the file.
int terminatorLine1 = templines1.IndexOf("END-OF-LINE", currentLine1);
if (terminatorLine1 <= 0) 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;
}

5 Replies

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

Madhanmohan Devarajan10y ago
Accepted 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("","");
Listdates=File
.ReadAllLines(fileName)
.Where(v=>{zi=Regex.Match(v,@"(?<=\|)\d{2}\s+\w{3}\s+\d{4}\s+\d{2}:\d{2}:\d{2}(?=\|)");returnzi.Success;})
.Select(v=>zi.Value)
.ToList()
;
//ConvertingdatetothenewFormat - y is each item in the list
foreach (var y in dates)
{
//Takingdateandperformingoperationonit
string[]month={"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"};
y=y.Replace("","-").Replace(":",".");
//Console.WriteLine(SomeGlobalVariables.yy);
for(intm=0;m<=month.Length-1;m++)
{
if(y.Contains(month[m]))
{
intmonthInDigit_int=DateTime.ParseExact(month[m],"MMM",CultureInfo.CurrentCulture).Month;
stringmonthInDigit=monthInDigit_int.ToString();
y=y.Replace(month[m],monthInDigit.PadLeft(2,'0'));
}
}
y=y.Remove(10,1).Insert(10,".");
y=SwapCharacters(y,0,3);
y=SwapCharacters(y,1,4);
//mention here what you are going to do with y
}
//Inthesamemethod:
stringname=string.Format(@"C:\Users\HRG786\Desktop\{0}"+"."+"rslt"+"."+y,fields2[1]);//makeanameoutofthesecondfield.
0
Hesham Hassanein10y ago
I tried this already, but how can i call y in the second function that has string name?
0
Madhanmohan Devarajan10y ago
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
functionDoOperation(stringy){
Step: 3
also while ending the function you need to return the y value like shown below.
y=SwapCharacters(y,0,3)
y=SwapCharacters(y,1,4);
return y;
}
Hope it will solve your issue.
0
Hesham Hassanein10y ago
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,@"(?<=\|)\d{2}\s+\w{3}\s+\d{4}\s+\d{2}:\d{2}:\d{2}(?=\|)");returnzi.Success;})
.Select(v=>zi.Value)
.ToList()
;
dates.ForEach(DoOperation);//ConvertingdatetothenewFormat
//Inthesamemethod:
stringname=string.Format(@"C:\Users\HRG786\Desktop\{0}"+"."+"rslt"+"."+y,fields2[1]);//makeanameoutofthesecondfield.
//Takingdateandperformingoperationonit
staticvoidDoOperation(stringy){
string[]month={"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"};
y=y.Replace("","-").Replace(":",".");
//Console.WriteLine(SomeGlobalVariables.yy);
for(intm=0;m<=month.Length-1;m++)
{
if(y.Contains(month[m]))
{
intmonthInDigit_int=DateTime.ParseExact(month[m],"MMM",CultureInfo.CurrentCulture).Month;
stringmonthInDigit=monthInDigit_int.ToString();
y=y.Replace(month[m],monthInDigit.PadLeft(2,'0'));
}
}
y=y.Remove(10,1).Insert(10,".");
y=SwapCharacters(y,0,3);
y=SwapCharacters(y,1,4);
}
0
Madhanmohan Devarajan10y ago
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]
0