Comments by Himansh jain (Top 32 by date)

anything can be used ..by default I put the strings..it can be modified according to his requirement.

https://drive.google.com/file/d/1ROFq9mj2AqsHd7u2j6KESBTn5W24zj3p/view?usp=sharing

Please find the screenshot of the file when I try to open it.

I am getting responses like this. When I open it through open in a new tab through response(by pressing F12), a new excel file in xls file format gets downloaded which opens correctly.

��ࡱ�

So what am I doing wrong?

Like this

???????
%??????????????????id???????????????timesNewRoman???????????????????????????????

Please tell me ,where am I making mistake.

dbContext.Customers.Add(cust); on this line

- $exception {"Cannot create a file when that file already exists."} System.IO.IOException

i am getting this exception

DateTime? InstallDate = '25-01-2022 13:27:36';

I have to convert it into format(yyyy/mm/dd hh:mm:ss) as my database where I have to insert the InstallDate takes only the (yyyy/mm/dd hh:mm:ss) format.
Desired Output
InstallDate = '2022-01-25 13:27:36'

Please provide the code if you can figure this! Thankyou for your support.

DateTime? InstallDate = '25-01-2022 13:27:36';

I have to convert it into format(yyyy/mm/dd hh:mm:ss) as my database where I have to insert the InstallDate takes only the (yyyy/mm/dd hh:mm:ss) format.
Desired Output
InstallDate = '2022-01-25 13:27:36'

Please provide the code if you can figure this! Thankyou for your support.

DateTime? InstallDate = '25-01-2022 13:27:36';

I have to convert it into format(yyyy/mm/dd hh:mm:ss) as my database where I have to insert the InstallDate takes only the (yyyy/mm/dd hh:mm:ss) format.
InstallDate = '2022-01-25 13:27:36'

Please provide the code if you can figure this! Thankyou for your support.

Here the variable is InstallDate not MeterInstallDate

Select Id,ExtractName,NextRunTime from ExtractSchedule e join ExtractDefinition u on e.ExtractID=u.Id order by u.id desc;

Is this correct?

thank you Sir :)

thank you:)

thank you for your solution . Could you please tell where I can study about "Descendants("G1").First()?.Value" usage...i was going through documentation but could not find it .

still it is not working...what to do?

Sorry , you were right . Thanks a ton. :)

Sir , i followed your suggestion only

using System;
using System.Xml;
using System.IO;
using System.Text.RegularExpressions;
using System.Collections.Generic;
using System.Linq;

namespace ReadXML
{
class Program
{
static void Main(string[] args)
{
AnalyzeFiles(Path.GetDirectoryName(@"C:\Users\himansh.jain\Downloads\cesu\"));

}

static IEnumerable<string> GetCodes(string filename)
{
var xml = File.ReadAllText(filename);

return Regex
.Matches(xml, @"P\d -\d -\d -\d -\d")
.Select(x => x.Value)
.Distinct()
.ToList();
}
static void AnalyzeFiles(string path)
{
var filenames = Directory.GetFiles(path, "*.xml");

foreach (var filename in filenames)
{
var codes = GetCodes(filename);

var destinationFilename = Path.Combine(path, $"{Path.GetFileNameWithoutExtension(filename)}_result.txt");

File.WriteAllLines(destinationFilename, codes);
}
}
}

}

But I am getting 0 byte size txt files therefore could not find those codes in them.

This code is running fine...the one you helped with before. Here I am getting values in my txt files.

using System;
using System.Xml;
using System.IO;
using System.Text.RegularExpressions;
using System.Collections.Generic;
using System.Linq;

namespace ReadXML
{
class Program
{
static void Main(string[] args)
{
var path = @"C:\Users\himansh.jain\Downloads\cesu";
foreach (var file in System.IO.Directory.GetFiles(path))
{
var xml = File.ReadAllText(file);
Console.WriteLine(file);
var codes = Regex.Matches(xml, @"P\d-\d-\d-\d-\d");
List<string> list = new List<string>();
foreach (var code in codes)
{
string s = Convert.ToString(code);
list.Add(s);
}
List<string> uniqueList = list.Distinct().ToList();

var destinationFilename = Path.Combine(path, $"{Path.GetFileNameWithoutExtension(file)}_result.txt");
File.WriteAllLines(destinationFilename, uniqueList);

}

Console.ReadLine();

}
}
}

thank you for your solution , but now i am getting empty txt files. Value of ,

 Codes 

is not getting written in the text files.

Thank you very much

thank you for your solution but still i am not able yo print the result

string path = @"C:\Users\himansh.jain\Downloads\Xmltesting1.xml";
var xml = File.ReadAllText(path);
var codes = Regex.Matches(xml, @"P\d-\d-\d-\d-\d");
Console.WriteLine(codes);
After Running the above code I am getting this...i don't know why i am not able to print the result.
System.Text.RegularExpressions.MatchCollection
C:\Users\himansh.jain\source\repos\readxmls\bin\Debug\netcoreapp3.1\readxmls.exe (process 34808) exited with code 0.
To automatically close the console when debugging stops, enable Tools->Options->Debugging->Automatically close the console when debugging stops.
Press any key to close this window . . .

XmlDocument doc = new XmlDocument();
doc.Load("C:\\Users\\himansh.jain\\Downloads\\Xmltesting1.xml");
string pattern = @"P\d-\d-\d-\d-\d";
Regex rgx = new Regex(pattern);
foreach (Match match in rgx.Matches(doc))
Console.WriteLine("'{0}'",match.Value);

i could not make it work , can you please identify the error.