how to parse and extract specific elements out of a JSON that I obtain from a web source. Using Visual Studio 2010 and VB. I can get the JSON but I haven't been able to find any examples or tutorials regarding parsing the data, locating specific elements and their associated data.
View 1 RepliesI'm writing a little web service which generates SO/SF/SU/MSO user flair in the form of an image with various "themes". I find this preferable to using the HTML/JS solutions offered by SO as it's more flexible and also works better in forum signatures.
I'm retrieving the data using the apparently unofficial API (More info here). I can have the data in HTML or JSON. I assumed the JSON would be easier to parse.
Unfortunately, I'm not great at regexes. and the best I can come up with is some very hacky sub-stringing. I believe a regex should be the most elegant solution
regex that matches ID, GravatarURL, ProfileURL, DisplayName, Reputation and Badge Counts (Bronze/Silver/Gold).
FWIW This is to be used in a VB.Net project (in case that affects the syntax at all)
[Code].....
In case any of you are interested, some screenshots of the flair as a work in progress are available here: Me, Jeff Atwood, Joel Spolsky
I have a parse from Wikipedia saved in a text file in the following form: The town itself is situated to the south-east of the rock, and overlooks the Palaia Monemvasia bay. A small hamlet with about 10 houses lies to the northwest.The founding of the town and fortress of Monemvassia most probably occurred in the 6th century AD. The town was founded in 583 by people seeking refuge from the [[Slavic peoples|Slavic]] and the [[Eurasian Avars|Avaric]] invasion of Greece. From the 10th century AD, the town developed into an important trade and maritime centre. The fortress withstood the [[Arab]] and [[Normans|Norman]] invasions and conquests in 1147. Cornfields that fed up to 30 men were grown inside the fortress.What I need to do is to extract specific texts from the parse given the header names. For example, if I type in a textbot Geography I need ONLY the geography text returned.
View 8 RepliesThe info i need extracted is formatted:
<TD><A HREF="http://xxxxx.com/xxxxxx/index.html"><IMG SRC="../xxxxx/thumbnails/xxxxx.jpg"> </A></TD>
<TD>=== <B><A HREF="http://xxxxxxxxx.com/xxxxxxxx/index.html">LINE 0</A></B> ===<BR>
<FONT SIZE="2" COLOR="#400080">
[code]....
how do i extract the info between TD=== and /a and Line 1,2, and 3 and store it into a database from a live website?
I'm sure this has been asked before but I'm not finding quite the information I'm needing so I thought I'd post this.
I've written a PHP script that returns a simple JSON object that looks like this:
{"status":"success","level":"admin"}
I'm doing a standard web request that submits the required data to the script over the internet and that's working fine.
Now, I want to use JSON.NET to pull out the individual variables so I can know what the values of "status" and "level" are. The problem is, I have no idea where to start.
I'm doing this in VB.NET (on the .NET Compact Framework).
I created a method and pass the element type, id, and any inner text that instantiates a new html element. The last statement: Me.Controls.Add(element) adds it to the end of the page, but I would like it to be inserted in a specific position (between 2 divs within a form). What I am describing is very similar to this post on SO here, although it was for javascript.
View 1 RepliesI have to the replication.That time have to pass String as JSON
{"Table1" :
[
{"Name" : "MyCustomer","Description" : "cutomer","Status" : "1"}, {"Name" : "Kiraa","Description" : "My","Status" : "1",}[code]......
This is my format of JSON result. I want to convert to DataSet.I have installed JSON.NET library. I am using C#.net
public bool convertJSONToDataSet(string strBusinessUnit, string strExecutiveCode, string strTableName, String jsonContent)
{
DataSet dataset = JsonConvert.DeserializeObject<String>(jsonContent);[code].....
here this statement is wrong DataSet dataset = JsonConvert.DeserializeObject<String>(jsonContent); how to covert to a JSON string to a Dataset.
I looked on the JSON.org website but I couldn't find any JSON library for Visual Basic .NET, does one exist?
View 4 RepliesHow can I parse json from such as twitter etc in vb.net applications.
View 2 RepliesHere's my json:
{"d":{"key1":"value1",
"key2":"value2"}}
Is there any way of accessing the keys and values (in javascript) in this array without knowing what the keys are?
The reason my json is structured like this is that the webmethod that I'm calling via jquery is returning a dictionary. If it's impossible to work with the above, what do I need to change about the way I'm returning the data?
Here's an outline of my webmethod:
<WebMethod()> _
Public Function Foo(ByVal Input As String) As Dictionary(Of String, String)
Dim Results As New Dictionary(Of String, String)
[Code]....
I need to parse a text looking for the string - [[Extract|xxxxxxx]] and extract the xxxxxxx characters.How would I do this?
View 2 Repliestell me an efficient method of retrieving the CSS between tags on a page of markup in .NET?I've come up with a method which uses recursion, Split() and CompareTo() but is really long-winded, and I feel sure that there must be a far shorter (and more clever) method of doing the same.it is possible to have more than one element on a page, and that the element can be either or .
View 3 RepliesI have been working on a project to read some data of facebook user walls. So I have researched I need to use json and System.Web.Script.Serialization to extract the required data I suppose. Has anyone have a tidy example of how to get something out of json script?
View 2 RepliesI am trying to parse incoming data from a serial port that appears to be XML format but an exception is thrown when I switch from a simulated setup to the real deal.My program runs great in a simulated setup but when I try it out on the real device I get: XmlException was unhandled Unexpected end of file has occurred. The following elements are not closed: li840 line 1, position 9.The li840 tag is my root tag and the position never seems to get past 40. I've tried using a try catch block but in my in both my simulated and real setups my values are blank but the program will run without exceptions. Should I take my received data and put it into a file and then read from the file? or is there something else I can do to make this work properly? [code]
View 12 RepliesPretty much the only thing I have changed is created a loop because I have one xmlstring and want to break it up and create tif files from it(which it actually does do).My problem is this: readbytes inside the while loop throws an exception at the last time through the loop that says I have an "unexpected end of file; the following elements are not closed" and lists them
[code]...
So there are tags left open after the readtofollowing("image"). I tried catching the exception to no avail, tried to read until eof, no avail. I dont really need elements to be closed, I just need to continue because I created files using whats in the image tag.EDIT: I think my xmlstring is going to have times where it will be too big to do a parse without slowing down too much.../parsing binary data?
I'm getting a JSON response after accessing a web service with my window application written in VB.NET. How can I convert the JSON response to a VB.NET object and vice versa?
View 1 Repliesi have this code to extract all form input element in html document. currently, i cant get select, textarea and other elements except input element.
Dim htmldoc As HtmlDocument = New HtmlDocument()
htmldoc.LoadHtml(txtHtml.Text)
Dim root As HtmlNode = htmldoc.DocumentNode
[Code]....
how to get all elements in all forms in the html document?
I am having a question on parsing XML files. In my local folder c: estrdl, I have a bunch of xml files.... what I want to achieve is to extract the contents between <commandtext>. The extracted information is basically a SQL query.... Next step is to extract the FROM Clause from the query and save that piece of information into a file with the same of xml file and suffix is "FROM", for ex, if the xml file is called abc.xml, the extracted piece will be called abc_FROM.txt....
View 3 RepliesI have tried a few things like converting HTML to XML and then using an XML navigator to get input elements but I get lost whenever I start this process.What I am trying to do is to navigate to a website which will be loaded using textbox1.text.Then download the html and parse out the input elements like . username, password, etc and place the element by type (id or name) into the richtextbox with the attribute beside the name.[code]Any clues or how to properly execute an HTML to XML conveter, reader, parser?
View 2 RepliesI'm a newbie about web services in VB.NET. I'm making a desktop application that will talk to JIRA[URL]..They provided a REST api that I decided to use. The first step is to login which they say that...
"To log in to JIRA, you need to POST a username and password in JSON format..."
{"username" : "admin", "password" : "admin"}
to this url...
https://addressgoeshere (we are using https)
Can someone provide me a sample code to do this so I can have a guide and a good start?
this is the JSON string the data is required in to be sent using a given URL.[code]I am using VB.net and i need to create this string using VB.net. I tried using namevaluecollection and doing a POST. I also tried making a string and send data using GET. Both failed. how can i do this?
View 2 RepliesI need to load and parse a text file and extract data between points on any given line. I can load the file, but it's the parsing that's giving me headaches. e.g. "Phoned Jim and arranged for John to attend site" First I need to search for "Phoned" because the line always starts with that, and then I need to extract "Jim and arranged for John"
[Code]....
I got this
<?xml version="1.0" standalone="yes"?>
<SAF-T_PT xmlns="urn:OECD:StandardAuditFile-Tax:PT_1.01_01">
<AuditFile>
<Header>
<AuditFileVersion>1.01_01</AuditFileVersion>
[Code]...
but doesnt do anything please help me, my boss is almost spanking me because this :O
I am using VB.NET to read an XHTML file. I need my program to find every element within the XML structure which has the "class" attribute set to a specific value.IE: I need an array (or similar list) of all elements from the document which contain class="mytag".There is a list of several values I need to detect, all of which start with the same word 'mytag' followed by another word - so using a "contains" function seems sensible here
View 2 RepliesThere seems to be no documentation on the codeplex page and for some reason intellisense doesn't show me available methods or anything at all for htmlagilitypack (for example when I type MyHtmlDocument.DocumentNode. - there is no intellisense to tell me what I can do next)
I need to know how to remove ALL < a > tags and their content from the body of the HTML document I cannot just use Node.InnerText on the Body because that still returns content from A tags.[code]...
i have a log file which contains hundreds/thousands of seperate XML messages and need to find a way to extract a complete xml message depending on the parameters given (values of nodes).My biggest problem is that even though i program a fair amount i have had very little contact with XML or the XML libraries of the languages i use and didnt think that a simple text parsing would be an elegant solution!I am going to attempt this in C# or VB.net
View 3 RepliesI am trying to extract a number from a specific line and finding it an arduous task.
-#comments">18 comentarios</a></span>
I need the number before the word commentaries. This is a common phrase to search for and extract. the start of the line varies.
I am trying to extract a specific bit of text from a xml file. The file is located in C:Testspac emp1.xml and the specific text is between <space></space>How do I go about getting this text and displaying it in a textbox.
View 2 RepliesI know how to extract an entire page source into VB.NET, but once I do that how do I make VB.NET search the text and return a specific vlaue that is not constant? Take this line from the page source for example:
[Code]...
I need to parse some text to extract the name/path of an image file inside an X file. The part of the file looks something like this:
TextureFilename {
"C:\\Users\\USER\\Documents\\Map\\Textures\\Grass01.dds";
}
[code].....