|
Hi,
I have one flat file which contains data in particular format.The file contains data in particular format which generates pages. Each page contains Year in MM/DD/YYYY format which always starts with specific position means specific x,y coordinate, so out of this it will generate N no of pages. There are multiple dates available in one page like YearStarting , YearEnding etc and out of this i want to find out only particular date like YearStarting. I don't want to find out values for YearEnding.
My requirement is that i have to find out each and every YearStarting value contains in the flat file from first line to end of the reports. YearStarting data is having specific position in each pages.
Can some one tell me how to find out each value of Year from the Flat file(or text file) using C#??
Thanks a lot.
|
|
|
|
|
You could try regular expressions.
|
|
|
|
|
I have multiple columns which contains Year format, so basically year format is NOT unique thru out the
file, so if i use regular expression then it will fetch values from multiple column and i want all the values from
specific single column.
|
|
|
|
|
Not if you write your expression properly.
We'd need to see a sample of the file.
|
|
|
|
|
Pseudo code
open the file (System.IO)
read line (System.Text)
test that it contains the YearStarting pattern in the text (System.Text or regex)
extract the first date after pattern (System.Text or regex)
store the details (System.Data)
repeat test if it is possible to have more than 1 date per line
repeat line 2 until end of file
close file
Fairly simple really
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Use a StreamReader to read the file into a List<string> or some other “collection”.
Iterate over the list looking for page start / end (e.g. form feeds or whatever).
Since you know the x,y of the date in question, count “y” lines from the top / bottom of a “page”.
Once you have the line in question, use “string” functions to get date at “x”; e.g.
// Assumes x relative to 0 and date in mm/dd/yyyy format
String strDate = line.SubString( x, 10 );
Then just convert the “string date” to a suitable format for further processing using Parse or whatever.
|
|
|
|
|
hii........plz help
by use asp.net .... if i hve one image...if i click on some color(i take as buton click event like btngreen_click) i need to change that total image to that green color..
thanqu fnds...
~@nisha~
"The work will teach you how to do it.....!!"
|
|
|
|
|
Why fiddle with the image, why not just replace the image with a green rectangle.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hummmm.....i need 2 fill with color to that total image.... bye just click on button...
|
|
|
|
|
I'm writing an application that started fine as a Windows Application using Visual c# 2008. I had problems with my PC and had to restart. Now when I try to run the program in the editor it thinks that the ouptput is a Class Library even though it is set to Windows Application under project preperties. How can I fix this?
|
|
|
|
|
Maybe your solution contains several projects and the one that you want isn't the startup project any more?
|
|
|
|
|
hello all,
i have a windows application program contains a dll and i need to decomplie this dll to modify some functions.
can any one advice me how i can do it?
please reply me quickly
best regards
Abdullah
|
|
|
|
|
As you posted this in c# forum, I assume that it's a .NET dll, and you can decompile it with Reflector: http://www.red-gate.com/products/reflector/[^]
Die Energie der Welt ist konstant. Die Entropie der Welt strebt einem Maximum zu.
|
|
|
|
|
Member 4528123 wrote: please reply me quickly
Quickly? Ok, here are some quick options.
1) Contact the company that wrote it, and ask them to change it
2) Teach yourself how to reverse engineer (This might take a few years or more)
3) Figure out another way to solve your problem that doesn't involve decompiling someone else's code.
|
|
|
|
|
If those methods are virtual, you could always override them.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
I would usually try opening it in Reflector ( + ReflexIL plugin) and then just edit the function at the IL level. Much easier that way - if you have the Reflector decompile it completely it will almost always make some mistakes, which you'd have to fix.
If someone was so silly as to use "Reflector breakers" I'd probably first try the tools from NTCore (eg using Rebel.NET to replace the function)
|
|
|
|
|
Hi Guys
Hope you can help. I'm writing a program to do a record count within an XML file
The XML file is structured as per below:
<WEBRequest>
<Request>
<BlockA>
<REC>
<CustomerNumber></CustomerNumber>
<FirstName></FirstName>
<LastName></LastName>
<Email></Email>
</REC>
</BlockA>
<BlockB>
<REC>
<FirstName></FirstName>
<LastName></LastName>
<OrderDetail></OrderDetail>
<PartType></PartType>
</REC>
<REC>
<FirstName></FirstName>
<LastName></LastName>
<OrderDetail></OrderDetail>
<PartType></PartType>
</REC>
<REC>
<FirstName></FirstName>
<LastName></LastName>
<OrderDetail></OrderDetail>
<PartType></PartType>
</REC>
</BlockB>
<BlockC>
....
....
....
....
</BlockC>
....
....
....
</Request>
What I need to do is count and output number of <REC>'s for each <Block> element and output to a cell within excel (Excel Automation is working).
E.g.
BlockA = 1 REC
BlockB = 3 REC
.
.
.
BlockM = 32 REC
I have the excel automated correctly, however, I'm afraid that my inexperience with XML is quite telling, so I dont have a clear idea on how to do the record count.
Thanks in advance!!!
Grg!
|
|
|
|
|
Using XDocument it's quite easy:
XDocument doc = XDocument.Load("YourXMLHere.xml");
var distinctBlocks = from rec in doc.Descendants()
where rec.Name.ToString().StartsWith("Block")
select rec;
var results = from rec in distinctBlocks.Descendants("REC")
select rec;
var output = (from rec in results
group rec by rec.Parent.Name into g
select new {Block = g.Key, Count = g.Count()}).ToList();
modified on Tuesday, April 27, 2010 3:55 PM
|
|
|
|
|
Thanks for Info!
I don't suppose you have the c# code?
|
|
|
|
|
GrgBalden wrote: I don't suppose you have the c# code?
That was C#(3) code.
Using XLinq => Linq to XML.
modified on Wednesday, April 28, 2010 10:33 AM
|
|
|
|
|
Hi can anyone else help with this, I'm somewhat limited to c#2 (using VS2005)??
|
|
|
|
|
here you go.
I created a dummy class that holds the Block name and the rec count:
public class BlockCount
{
private int count = 0;
public int Count
{
get { return count; }
set { count = value; }
}
private string block;
public string Block
{
get { return block; }
set { block = value; }
}
}
private void button1_Click(object sender, EventArgs e)
{
XmlDocument doc = new XmlDocument();
doc.Load("Abs.xml");
XmlNodeList requests = doc.GetElementsByTagName("Request");
if (requests != null && requests.Count > 0)
{
blocks = new List<BlockCount>();
foreach (XmlNode nd in requests)
{
foreach (XmlNode blck in nd.ChildNodes)
{
BlockCount c = new BlockCount();
c.Block = blck.Name;
foreach (XmlNode rec in blck.ChildNodes)
{
c.Count++;
}
blocks.Add(c);
}
}
}
dataGridView1.DataSource = blocks;
}
}
modified on Wednesday, April 28, 2010 2:11 PM
|
|
|
|
|
Thank you kindly!!!
Will give this a go tommorow!
|
|
|
|
|
i would like to achieve a checkbox on a ColumnHeader in a listview.
i have been trying for days.
i have achieved a checkbox on the right spot in the listview by virtual placing it on top.
<br />
[DllImport("user32")]<br />
private static extern IntPtr SetParent(IntPtr hWndChild, IntPtr hWndNewParent);<br />
<br />
protected override void OnHandleCreated(EventArgs e)<br />
{<br />
SetParent(_cCehckBox.Handle, Handle);<br />
base.OnHandleCreated(e);<br />
}<br />
but the visual style/effect of the header causes the checkbox to fall in the background if you hover the mouse of the header.
the Header class doesn't provide anu usefull stuff, atleast i don't see any usefull stuff.
i have bene reading alot about it and viewed many things regarding headers.
i have also been using ...
<br />
protected override void WndProc(ref Message message)<br />
{<br />
....<br />
}<br />
filtering on WM_NOTIFY for 'HDN_ITEMCHANGINGA', 'HDN_ITEMCHANGEDA', 'HDN_BEGINTRACKA', 'HDN_BEGINTRACKW'.
i used a piece of code from a project here on codeproject, virtually unchanged.
but i only get the windows handle, the other things are empty.
[StructLayout(LayoutKind.Sequential)]
private struct NMHDR
{
public IntPtr hwndFrom;
public int idFrom;
public int code;
}
base.WndProc(ref message);
*/
const int WM_NOTIFY = 0x004E;
const int HDN_FIRST = (0 - 300);
const int HDN_BEGINTRACKA = (HDN_FIRST - 6);
const int HDN_BEGINTRACKW = (HDN_FIRST - 26);
bool callBase = true;
switch (message.Msg)
{
case WM_NOTIFY:
NMHDR nmhdr = (NMHDR)message.GetLParam(typeof(NMHDR));
OnMessageNeedsSending("WM_NOTIFY " + message, Color.Black);
OnMessageNeedsSending("code: " + nmhdr.code + ", hwndFrom: " + nmhdr.hwndFrom + ", idFrom: " + nmhdr.idFrom, Color.Black);
switch (nmhdr.code)
{
case HDN_BEGINTRACKA:
OnMessageNeedsSending("HDN_BEGINTRACKA " + message, Color.Black);
break;
case HDN_BEGINTRACKW:
OnMessageNeedsSending("HDN_BEGINTRACKW " + message, Color.Black);
break;
}
break;
}
if (callBase)
{
base.WndProc(ref message);
}
}
http://www.codeguru.com/forum/showthread.php?t=352366[^]
http://www.codeguru.com/cpp/controls/listview/headercontrol/comments.php/c1057/?thread=12184[^]
A Much Easier to Use ListView[^]
is there is a why to add properties, like Controls 'xxx.Add(checkbox);?.
Bad = knowing 2 much
modified on Tuesday, April 27, 2010 11:04 AM
|
|
|
|
|
i extented ...
[StructLayout(LayoutKind.Sequential)]
private struct NMHDR
{
public IntPtr hwndFrom;
public int idFrom;
public int code;
}
to ...
[StructLayout(LayoutKind.Sequential)]
private struct NMHDR2
{
public IntPtr hwndFrom;
public int idFrom;
public int code;
public int coder;
}
this new variable 'coder' contains numbers, like: -12, -16, -23 -320, -321, -326 -327, -530
-12 and -530 seam to be mouseover and mouseleave.
-16 and -326 seam to be mouseclick / down and mouse release.
i posted a logoutput.
http://pastebin.com/HuCk5cac[^]
anyone experienced with this?
Bad = knowing 2 much
modified on Tuesday, April 27, 2010 2:47 PM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
