|
|
Well, I'm thoroughly confused by your response.
enhzflep wrote: Mate, there's no need to SHOUT. Your question is perfectly clear without it. It merely gives the impression of someone too inarticulate to ask for the information they require who then becomes frustrated and raises their voice at the person that perfectly answered their ill-formed question. Not generally seen as a desirable personal attribute... Where did you get "shouting" or "raising their voices" from? Where did this little tirade come from? You'll have to clarify that for me.
enhzflep wrote: Typing "c# extract vba from access" into google
I DID look at Google. I ALWAYS go to Google. I also always come here because I know CP to be a treasure trove of experienced developers. More than once I've gotten answers or code from other devs here without spending hours sifting through half baked or off topic Google code samples.
enhzflep wrote: Since I've got 20 seconds to kill that I can donate to someone clearly to busy to expend it themselves, here's the first couple.
How did you come to a point where you felt it necessary to insult me? Again, I'm going on the assumption here that I somehow offended you, which I can't for the life of me see how or where.
Look, I asked a simple question. You clearly don't have an answer. I'm not interested in continuing a discussion with someone who has no substantive contribution to the problem other than redirect me to Google.
Save your replies.. I don't feed trolls.
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Kevin Marois wrote: I DID look at Google. I ALWAYS go to Google
You should specifically mention that in your first post. Given that there are so many google results you might also want to point out why those are inadequate in your post (first one.)
|
|
|
|
|
enhzflep wrote: Mate, there's no need to SHOUT
I think he was emphasizing rather than shouting.
|
|
|
|
|
No idea, in fact I started working in C# last week (and you can imagine the level of knowledge I have now).
Two ideas:
- If it would be possible to open access files in Visual studio you could try to use the DTE option (accessing the same Visual studio interface programatically to do what you are after).
-- In case this is not possible, who knows if you have an alternative to DTE but for Microsoft Access.
- Another method that could work (again no idea) see: automating access[^]
No idea if any of this could help you... just thought it wouldn't harm to let it here.
Hope this helps.
Good luck!
|
|
|
|
|
|
I asked this question in another thread but no one answered it so I'm creating a new thread to see if someone can help. I need help with pass the value in the API to XElement in C#
Here the a piece of the API schema:
<xsd:element
name="EventStatus" type="xsd:string">
<xsd:annotation>
<xsd:documentation>Event Status</xsd:documentation>
</xsd:annotation>
</xsd:element>
Is this how that would be done?
new XElement("EventStatus", "Event Status"),
),
|
|
|
|
|
|
Bootzilla33 wrote: Is this how that would be done?
No.
From the fragment you have an 'element' which has an 'attribute' which has a 'name' of "name" (the two are not the same) and has a 'value' of "EventStatus".
Then you have another attribute also.
Then that element has other elements under it.
The documentation for XElement demonstrates some of this and more importantly demonstrates how you can print out the result so you can see it yourself.
XElement Class (System.Xml.Linq)[^]
You can look for other examples using XElement and XAttribute.
I want to emphasize that figuring out how to print these out is the most important thing you can learn. You need that even once you understand most of it.
|
|
|
|
|
Hello Community.
I have built an aplication wich interacts with a webserver as if it were a browsing user. It can log in, browse products and select a product to buy. Unfortunately when it comes to actually buying the product the server returns just the logintoken and the shopping cart is still empty.
I suppose the session cookie is not sent.
Is there any way I can debug the httpclienthandler? I am a beginner in Programming and I hoped there was a way similar to Chome debugger console.
best regards,
julian
|
|
|
|
|
Hi there,
I am experiencing issue with split method. When I try split something like this:
06302017;37;Denver; Other Non-Interest Expense from RI item 7.d. : Travel Expense=$88,799. Excess public-facing website address listings f rom
RC-M line 8.b.: sparkalpha.com, www.getsparkalpha.com, www.getsparkalpha.com, www.sparkalpha.com; 07282017;Other; RCM; M4b
The tab that occurs is not my doing but what actually happens with that mass of string and I believe it is causing my problem. It splits this in half into two different arrays. This is problematic because each item separated by a ';' corresponds to a field so it causes an out of bounds error. Any suggestions on how to get it to keep the 8 different strings within the split? Based on how my program is run, I cannot make a special case of this and expect it to work well.
By the way, I didn't write the line that I'm trying to split so I cannot fix it myself. I am grabbing a file from a website location and then splitting it so that the data can be used for a database.
Thank you for your help.
|
|
|
|
|
Split is unlikely to do what you want. It sounds like you are looking for a CSV reader.
Or, if you are using SQL Server, try the bcp utility.
|
|
|
|
|
I'm currently taking in the file through a Streamreader and then running a method which has the split method. It works for all other lines except that one. It's because of the tab that inconveniently gets thrown in. I'm trying to use C# right now. I will see if CSV reader is any better.
|
|
|
|
|
What are you trying to split it into? If you know what characters you want to split on then just add them to the splitter set.
|
|
|
|
|
I am trying to split it by ';'. This is a file that I'm reading in. 20170630;37;Denver;Other Non-Interest Expense from RI item 7.d. : Travel Expense=$88,799. Excess public-facing w ebsite address listings f rom
RC-M line 8.b.: sparkalpha.com, www.getsparkalpha.com, www.getsparkalpha.com, www.sparkcapitalone.com.;20170728;Explanations;Call;m1b
C# keeps bringing the RC-M down a line (tabs it which isn't in the file). It is screwing up my delimitation and causing an out of bounds error. This doesn't happen anywhere else in the file.
class Program
{
static void Main(string[] args)
{
string CurrentLine;
string FilePath = "C:\\12837.SDF.txt";
using (StreamReader sr = new StreamReader(FilePath))
{
while(!sr.EndOfStream)
{
CurrentLine = sr.ReadLine();
GetSplit(CurrentLine);
}
}
}
private static void GetSplit(string CurrentLine)
{
string[] array = CurrentLine.Split(';');
string first = array[0];
string second = array[1];
string third = array[2];
string four = array[3];
Console.WriteLine(first + " " + second + " " + third + " " + four);
}
}
}
This is the test code I'm running for reference and not the actual code I end up using but it still comes up no matter what. I tried to Replace it and I might just try to skip the line when it pops up. By the way, I have the comments in there because I'm trying to see how many indexes it actually brings in.
Here's what it looks like in console:
20170630 112837 Denver Other Non-Interest Expense from RI item 7.d. : Travel Expense=$88,799. Excess public-facing w ebsite address listings f rom
RC-M line 8.b.: sparkalpha.com, www.getsparkalpha.com, www.getsparkalpha.com, www.sparkcapitalone.com. 20170728 explanations RIE
Here's what the different line looks like:
20170630 112837 Denver Adjustment investment
|
|
|
|
|
WoodChuckChuckles wrote: C# keeps bringing the RC-M down a line I don't know what you mean by that, but I don't think C# will do anything with your data. When I run your code (using the text in your question) I get the following output:
1: 20170630
2: 37
3: Denver
4: Other Non-Interest Expense from RI item 7.d. : Travel Expense =$88,799.Excess public-facing website address listings fromRC-M line 8.b.: sparkalpha.com, www.getsparkalpha.com, www.getsparkalpha.com, www.sparkcapitalone.com.
5: 20170728
6: Explanations
7: Call
8: m1b
|
|
|
|
|
If there is some kind of invisible character you can always scrub your string first.
while(!sr.EndOfStream)
{
CurrentLine = sr.ReadLine();
GetSplit(CurrentLine.Replace("\t", "");
}
And you should always be careful accessing an array like, you might try defensive coding (try - catch) or iterating through the array using a foreach() that way you will not end up out of bounds. If you need certain indexed members of the array to print, wrap the code and catch out of bounds exceptions.
|
|
|
|
|
How do you scrub for an invisible char? I'm not experienced with that. I apologize.
|
|
|
|
|
It was a bit of hyperbole. Any time you are parsing string data you want to understand what possible user inputs could cause you problems and make sure your string is scrubbed before you split it. If there is a possibility of newline characters, carriage returns, or inconsistent tabs you want to address those. The simple solution is a string replace, there are more advanced strategies using regular expressions and such. But in favor of simplicity try something like this:
class Program
{
static void Main(string[] args)
{
string CurrentLine;
string FilePath = "C:\\12837.SDF.txt";
using (StreamReader sr = new StreamReader(FilePath))
{
while(!sr.EndOfStream)
{
string currentLine = sr.ReadLine();
GetSplit(currentLine.Replace("\t","").Replace("\r","").Replace("\n","");
}
}
}
private static void GetSplit(string CurrentLine)
{
string[] array = CurrentLine.Split(';');
string first = array[0];
string second = array[1];
string third = array[2];
string four = array[3];
Console.WriteLine(first + " " + second + " " + third + " " + four);
}
}
}
That is just a general idea on how to handle it. One thing you always want to be wary of is bad input, and the best way to deal with it is to aggressively control your strings by stripping out troublesome characters.
|
|
|
|
|
<stackpanel> <grid text="MyNotes" fontfamily="Arial" fontweight="SemiLight" fontsize="26"> <grid text="Sample application for Windows 8 course" fontfamily="Arial" fontweight="SemiLight" fontsize="18" textwrapping="Wrap">
<stackpanel> <textbox="mynotes" fontfamily="Arial" fontweight="SemiLight" fontsize="26"> <textbox="sample application="" for="" windows="" 8="" course"="" fontfamily="Arial" fontweight="SemiLight" fontsize="18" textwrapping="Wrap">
<stackpanel>
<stackpanel> <textblock text="MyNotes" fontfamily="Arial" fontweight="SemiLight" fontsize="26"> <textblock text="Sample application for Windows 8 course" fontfamily="Arial" fontweight="SemiLight" fontsize="18" textwrapping="Wrap">
modified 22-Sep-17 6:37am.
|
|
|
|
|
We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.
Try it yourself, you may find it is not as difficult as you think!
If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
If you try them out, you'll find the answer. None of them.
This space for rent
|
|
|
|
|
var buffer = Windows.Security.Cryptography.CryptographicBuffer.ConvertStringToBinary( "The first sentence", Windows.Security.Cryptography.BinaryStringEncoding.Utf8); await Windows.Storage.FileIO.WriteBufferAsync(sampleFile, buffer);
var buffer = Windows.Security.Cryptography.CryptographicBuffer.ConvertStringToBinary( "The first sentence", Windows.Security.Cryptography.BinaryStringEncoding); await Windows.Storage.FileIO.WriteBufferAsync(sampleFile, buffer);
var buffer = Windows.Security.Cryptography.CryptographicBuffer.ConvertStringToBinary( "The first sentence", Windows.Security.Cryptography.BinaryStringEncoding.Utf8); await Windows.Storage.FileIO.ReadBufferAsync(sampleFile, buffer);
Var buffer = Windows.Security.Cryptography.CryptographicBuffer.ConvertStringToBinary( "The first sentence", Windows.Security.Cryptography.BinaryStringEncoding.Utf8); await Windows.Storage.FileIO(sampleFile);
|
|
|
|
|
byte[] bytes = System.Text.Encoding.UTF8.GetBytes("example string"); I'd like to point out that a text-encoding is not the same as encryption. A text encoded in UTF8 is still a readable text.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Or ...
byte[] bytes = System.Text.Encoding.UTF8.GetBytes(myString);
File.WriteAllBytes(path, bytes);
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|