|
Because it tends to get it wrong if the CSV data contains strings:
"hello", "hello, again", "goodbye" Is only three elements, but a Split won't spot that.
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
Good point, but not too difficult to write a parser that can handle such situations.
Use the best guess
|
|
|
|
|
Nope, but there are quite a few already written - and I wouldn't want to do it in a regex! 
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
To be honest, I would be reluctant to use a Regex for CSV processing as it all gets a bit complex when you can have double quotes inside double quotes, and comma inside them as well.
I would use a CSV file processor myself: A Fast CSV Reader[^] is pretty good!
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
|
Yes - include a reference to the assembly in your project, then follow the "Using the Code" section of the article.
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
This one is not as comprehensive as the Fast CSV but it is simpler! CSV to Table to CSV [^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
WinForms, C#, .NET 4.5, VS 2012 v.3
I am successfully using a BinaryFormatter to serialize, and de-serialize, instances of a moderately complex class.
There is a reason, related to using a 3rd. party control, I need to get the in-memory serialized stream into a string, and, later, convert it from string format back to MemoryStream. At least that's a working strategy right now ... which may be tossed out.
What I don't want to do is write temporary files on the fly. My first experiments were with using XmlReader, and XmlWriter, and I could not figure out how to use, and then re-use, a temporary file written to disk in a loop.
As you probably know, an in-memory binary-formatted stream is essentially "readable" as a Byte[].
My experiments with using the Linq Cast<string>(), Convert.ToString() ... and so forth, have all been wastes of time (should have known better).
I'd appreciate any ideas you may have. Perhaps I have missed out on finding a way to write XML to an in-memory stream ? Temporarily blinded by too much experimentation ? 
thanks, Bill
“Human beings do not live in the objective world alone, nor alone in the world of social activity as ordinarily understood, but are very much at the mercy of the particular language which has become the medium of expression for their society. It is quite an illusion to imagine that one adjusts to reality essentially without the use of language and that language is merely an incidental means of solving specific problems of communication or reflection." Edward Sapir, 1929
|
|
|
|
|
You probably want to use Encoding.GetString[^] - exactly which one will depend on what is in the stream:
byte[] bytes = myStream.GetBuffer()
string s = System.Text.Encoding.ASCII.GetString(bytes);
Or
byte[] bytes = myStream.GetBuffer()
string s = System.Text.Encoding.Unicode.GetString(bytes); Or one of the UTF properties - it depends on what is in the byte data. If it is truly byte then you may have to play to find a version that doesn't lose information when it is converted back!
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
^upvoted
Many thanks, OG !
In this case it turned out that using Unicode encoding was absolutely necessary: UTF-8, or ASCII (the only other encodings I tried), would throw errors deserializing DateTime values from a plain-vanilla .NET string-type.
When it takes me what seems like much too long a time to solve an issue like this, I usually ask myself the following questions:
1. am I dumb ?
2. did I study/research/look-up MS docs "dumb" ?
These first two questions are a result of, unfortunately, "once a Social Worker always a Social Worker" Of course, I assume that MS docs will usually be of no help, based on experience.
Then, if the answers turn out to be fairly simple, I ask the question: am I "onto something" (in this case via your kindly help) that could be valuable for other people on CP to have access to ?
Not sure, here. The case of needing to save an instance of a Class in a MemoryStream, then convert it to a string, so a 3rd. party control's very efficient own serializer can successfully serialize it ... and, secondarily ... to fish out the string resulting from de-serialising the 3rd. party control, and then turn that back into a MemoryStream in order to de-serialize that back into an instance of a Class ...
Well, the whole business kind of has a "bad code smell" to me. Might be better to do the tango using something like Mehdi Gholam's FastJSON (but, then the 3rd. party control probably won't be serializable) ?
What do you think: can anyone else benefit ?
yours, Bill
“Human beings do not live in the objective world alone, nor alone in the world of social activity as ordinarily understood, but are very much at the mercy of the particular language which has become the medium of expression for their society. It is quite an illusion to imagine that one adjusts to reality essentially without the use of language and that language is merely an incidental means of solving specific problems of communication or reflection." Edward Sapir, 1929
modified 29-Jun-13 23:10pm.
|
|
|
|
|
BillWoodruff wrote: What do you think: can anyone else benefit ?
I hope not - that has "kludge" written all over it!
I understand why you are doing it, and as long as you document in well it won't be a problem, but it's an...um...inelegant solution.
I am really surprised that byte[] or stream data rather than string aren't the default inputs to a serializer, but hey! What do I know 
Out of interest, is it a well-known 3rd party control set?
The universe is composed of electrons, neutrons, protons and......morons. (ThePhantomUpvoter)
|
|
|
|
|
^upvotedOriginalGriff wrote: Out of interest, is it a well-known 3rd party control set?
Hi OG,
It's a very lesser known specific control in a "suite" that (undeservedly, imho) is not as well known as it should be: definitely not in the Telerik, DevXPress, league, etc. It does not include a grid/Excel-thingee, though. It also costs a fraction of the cost of the big-name suites
In fairness, I should mention that I have not yet tried seeing what I could do to custom serialize the 3rd. party control in toto myself, and that there are some other avenues I have not yet explored using other features in the control to possibly "bootleg" in my custom objects: so, in no way am I complaining about the control/suite !
The developer, who's become a good friend over the last six years, is very responsive, and is thinking about the scenario I have, and what he might do in the future to make it easily possible.
The control, as is, supports serializing its entire state/content to either an XML file, or an in-memory stream, or to an SQL compatible format. I'd call that a more than "half-full cup," rather than "half-empty"
What I have working right now, is, I agree with you, a "kludge," but it is working quite well under a modest test load: by "load" I mean with a few hundred instances where I am creating a custom sub-class of the "atomic element" of the control to which I've added my own custom classes.
Again, thanks for your responses.
cheers, Bill
“Human beings do not live in the objective world alone, nor alone in the world of social activity as ordinarily understood, but are very much at the mercy of the particular language which has become the medium of expression for their society. It is quite an illusion to imagine that one adjusts to reality essentially without the use of language and that language is merely an incidental means of solving specific problems of communication or reflection." Edward Sapir, 1929
modified 29-Jun-13 23:14pm.
|
|
|
|
|
Have you considered Base64 encoding via Convert.ToBase64String/FromBase64String. It's guaranteed to give a reversible Byte[] <-> String conversion.
Alan.
|
|
|
|
|
^voted
Thanks, Alan, I will try out Base64 encoding.
yours, Bill
“Human beings do not live in the objective world alone, nor alone in the world of social activity as ordinarily understood, but are very much at the mercy of the particular language which has become the medium of expression for their society. It is quite an illusion to imagine that one adjusts to reality essentially without the use of language and that language is merely an incidental means of solving specific problems of communication or reflection." Edward Sapir, 1929
|
|
|
|
|
BillWoodruff wrote: I am successfully using a BinaryFormatter to serialize, and de-serialize, instances of a moderately complex class.... I need to get the in-memory serialized stream into a string, and, later, convert it from string format back to MemoryStream.
Doesn't matter why. It is a bad idea.
If you want a class serialized into a string (versus attempting to force binary into a string) then either create a customer formatter, or use json or xml.
|
|
|
|
|
^voted
Thanks JSchell, for your response.
As you might see, if you read my responses to OriginalGriff's responses, there are reasons I tried this strategy first, compared to XML, or JSON, and I did mention that a next step I will pursue is trying out Mehdi Gholam's remarkable FastJSON facility here on CP.
I have never written a custom formatter (and hope not to), but I suspect it would be more work than the current experiment with Byte[]=>string, which "boils down" to a surprisingly small amount of code.
In prototyping, I prefer to think of trying different types of implementation, in a case where I am constrained by the factors I am constrained by now, as "expedient experiments:" only when they prove useful/efficient, or less useful/efficient, in comparison with other implementations, do I evaluate them, and even then, I wouldn't use the word "bad" 
yours, Bill
“Human beings do not live in the objective world alone, nor alone in the world of social activity as ordinarily understood, but are very much at the mercy of the particular language which has become the medium of expression for their society. It is quite an illusion to imagine that one adjusts to reality essentially without the use of language and that language is merely an incidental means of solving specific problems of communication or reflection." Edward Sapir, 1929
|
|
|
|
|
BillWoodruff wrote: with Byte[]=>string, which "boils down" to a surprisingly small amount of
code.
It isn't a matter of implementation. It is a matter of mapping.
There is binary data that will not map into a string in such a way that one can reverse the process.
|
|
|
|
|
Dear Sir/Madam,
I wrote a function as follow:
public void ShowValueOnGrid(DevExpress.XtraGrid.GridControl grd)
{
String sValue="";
int m=0;
DevExpress.XtraGrid.Views.Grid.GridView MyGridView = new DevExpress.XtraGrid.Views.Grid.GridView();
grd.MainView = MyGridView;
MyGridView.GridControl = grd;
for (m = 1; m <= MyGridView.RowCount; m++)
{
sValue = Convert.ToString(MyGridView.GetRowCellValue(m,“InvoiceNO"));
MessageBox.Show(sValue);
}
}
I don't know why sValue contains nothing althought the I have just inputed data in InvoiceNo column on this grid control.
Please help me!
|
|
|
|
|
DevExpress.XtraGrid.Views.Grid.GridView MyGridView = new DevExpress.XtraGrid.Views.Grid.GridView();
You have created a new empty grid in this function, so none of the cells will contain any data.
Use the best guess
|
|
|
|
|
Dear Mr.Richard MacCutchan,
Thansk for your instruction
I want to get cell value on some grid via only one function
so the input parameter of this functon is a grid. How to get cell value on the grid(input parameter)?
Help me please
|
|
|
|
|
Just like it is ok
public void ShowValueOnGrid(DevExpress.XtraGrid.GridControl grd)
{
String sValue="";
int m=0;
for (m = 0; m <= ((gridview)grd).RowCount; m++)
{
sValue = ((gridview)grd).GetRowCellValue(m,“InvoiceNO").toString());
MessageBox.Show(sValue);
}
}
|
|
|
|
|
Member 2532800 wrote: I want to get cell value
Check the documentation for the method(s) to access individual cells.
Use the best guess
|
|
|
|
|
I understand how to create animation like pacman, but to move the pacman, I can only think of using location.
Problem is, how could I know there is obstacle or not?
|
|
|
|
|
Ultimately, the object will have a coordinate. This could be used to perform a rudimentary collision detection. The process could be as simple as this:
public class BaseGameObject
{
public int X { get; set; }
public int Y { get; set; }
}
public class GameObjects : BaseGameObject
{
public List<BaseGameObject> GameObjects { get; set; }
public BaseGameObject HitTest(int x, int y)
{
foreach (BaseGameObject gameObject in GameObjects)
{
if (gameObject.X == x && gameObject.Y == y)
{
return gameObject;
}
}
return null;
}
}
|
|
|
|
|
Thank you very much for the help.
I will try to understand it as I never use get set or that kind of class.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
