C# - Parse An Expression And Retrieve A Parse Tree?
Jun 8, 2012
I just want to parse simple expressions like IIF(FVAL(PFC) = TRUE, (IIF((ORGVAL(BAS, "2012/12/31") + ORGVAL(DA)) < 6500, (FVAL(BAS) + FVAL(DA)) * 12%, 780)), 0)`After parsing this I should be able to know what functions contains what parameters.
[Code]...
I'm stuck with .Net Framework 2.0, so no Linq or lambda expression goodies for me. Also I want to include the code in my custom library and not just reference it. Can anyone point me to some good library or code.
I just need to parse and not evaluate the expression and find what tokens are in use. After finding the tokens I need to change the expression string before parsing, like if the function ORGVAL is used then the parameter passed has has to be prefixed by an underscore. Like ORGVAL(BAS) will transform to ORGVAL(_BAS). Some functions can have tow parameters like ORGVAL(BAS, "2012/12/31") and this will transform to ORGVAL(_BAS, "2012/12/31")
NOTE: IF THERE ARE OTHER WAYS OF DOING IT PLEASE LET ME KNOW. I WOULD LOVE TO AVOID A PARSER AND LEXER.
View 3 Replies
ADVERTISEMENT
Mar 24, 2010
I have the following function that I am using to remove the characters �4 and nulls from my xmlString but I can't find what do I need to change to avoid removing the from my ending tags. This is what I get when I run this function
<ARR>20080625<ARR><DEP>20110606<DEP><PCIID>626783<PCIID><NOPAX>1<NOPAX><TG><TG><HASPREV>FALSE<HASPREV><HASSUCC>FALSE<HASSUCC>
find out what do I need to change in my expression to keep the ending tag as </tag>
[Code]...
View 1 Replies
Feb 10, 2009
I have this line in some
Integer.TryParse(ThisRow.Item("DatumID").ToString, n)
ThisRow is a datarow. The "DatumID" in this case happens to be an empty string, but is not Null. When I break on this line, and try to evaluate it by highlighting it and pressing Shift+F9, I get the message "Unable to evaluate expression". Interestingly, it is actually evaluating correctly (since the item holds an empty string, TryParse returns False).
I have tested this in every way I could think of (mostly I thought I had left out a parenthesis in my expression, but that wasn't true). So why won't that expression evaluate when tested, even though it is actually working correctly?
View 4 Replies
Feb 26, 2009
I want to extract
[code]...
using a regular expression. I have a regex like this:
FROM.*order
which extracts FROM codes WHERE FieldName='ContactMethod' and IsNull(Deactived,'') != 'T' order Also, how can I get rid of the capitalization?
View 4 Replies
Oct 19, 2005
In VB.NET 2005, what is the best way to retrieve and parse HTML data from a URL, a bit like a search engine crawler?I am building an app, where I need to parse a website, and collate data from it (the website uses some tags that I could pull out to get the appropriate bits of data). I want to be able to do this in a thread, and just update a DB with the data, and give the client app a status update of the progress.
View 6 Replies
Nov 9, 2010
In order for my program to share information between users, the best method I could come up with is using e-mails.I have a way of sending e-mails with the appropriate attachments, but would love a way to automatically retrieve these e-mail attachments directly from the program, without the user having to go to their e-mail account, find the correct project e-mail, download the attachment and then put it in the correct folder.I had hoped that VB.Net would have a built in procedure for doing this, but it seems there's not really anything there.
View 2 Replies
Mar 27, 2009
I'm using the following code to retrieve a URL and then parse the HTML from the page:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnStart.Click
Dim Temp As String, searchstr As String
[Code]....
I think my problem is that I don't exactly understand how I am supposed to start and end the parsing. I know that in my above code, the "meta" tag is the start and the chr(34), double quotes, is the ending.
When I modify my code, I have price line, which in th html ends with another character, the ">" sign. In the first code, the "content" tag doesn't end with another character, it just continues the line, which is easy and it works.
View 5 Replies
Jun 18, 2009
I have written code to pull some data into a data table and do some data re-formatting. I need some help splitting some text into appropriate columns.
CASE 1
I have data formated like this that I need to split into 2 columns.
[Code]...
column is the first 11 characters That is easy.column 2 should contain all the text after the first 11 characters up to but not including the first number.The last column is all the text after column 2
View 4 Replies
Mar 16, 2011
i am retrieving a iMAGE Extension variable string. for example: test.case-function.two.jpg and want to return the end '.JPG' portion only. so i can add to another variable value. Note the .JPG substring could be other Extension types such as PJPEG ect
View 1 Replies
Dec 7, 2011
Part of my project is to retrieve a string variable from an external source (google docs) and parse it. This string represents width and height. I have no problem retrieving, I just need to parse it in to two strings. The string has 4 variations.
Here are examples:
3"x4"
3"hx4"w
3hx4w
3x4
The width is always the first number and the height is always the second. Sometimes, the width and height have decimal points. Any way to parse this into two strings of the numeric values only?
View 3 Replies
Jul 29, 2010
I'm still relatively new to parsing xml documents into SQL. I am trying to parse one node out of an xml document.[code]...
View 12 Replies
Sep 29, 2009
What's the easiest way in VB.NET to parse this XML? Here's an example of the full source:View Source XML I believe that the XML can be read directly into a class structure that matches the XML's structure.Let's take a bit of the XML from the above example,
<?xml version="1.0" encoding="UTF-8" ?>
- <kml xmlns="http://earth.google.com/kml/2.0">
- <Response>
[code]....
How do I handle nested collections, for example, the Placemark collection in this example?
View 2 Replies
Sep 17, 2011
I have an app that the user selects information and it writes to an XML file. The user can increase and decrease the information in the XML file so it is dynamic. The other app reads the xml file and uses it to complete tasks. Since the XML is dynamic my code needs to account for that. Right now I have only allowed the XML to have up to four values in a certain node, I would like to allow more but I will need to increase the Select Case function.[code]
View 8 Replies
May 5, 2011
I am making a change to an existing process. Currently the csv file (which can have embedded "," with the field in quotes), is being passed to my module as a IO.StreamReader, pStreamReader.
[Code]...
View 2 Replies
Oct 31, 2010
parsing text that i have loaded in to my textbox Using ofd1 As New OpenFileDialog ofd1.InitialDirectory = "F:"
If ofd1.ShowDialog = DialogResult.OK Then RichTextBox2.Text = My.Computer.FileSystem.ReadAllText(ofd1.FileName)
End If
End Using
View 5 Replies
Apr 6, 2010
create a function that parses the input "4+7-4/4*4=" from instr into an array named tokens(1000), as string, and returns the number of arrays, or perhaps a negative number if there is an error in the input.
Dim tokens(1000) As String
Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
[code].....
View 1 Replies
Nov 1, 2009
I have XML data like this:[code]I would like to return the name of the places. How may I extract this data using Visual Basic?
View 3 Replies
Jul 27, 2011
I may be getting in way over my head, but here it goes. I am developing a small application for use on a helpdesk. The application will be installed on the client pc's and will be used primarily by the end user to assist the technician on the phone if the user's pc is offline or inaccessible. One part of the application gives the user their IP address, DNS address, DHCP address, and gateway address. I have it to where it will put all of those in the corresponding fields inside a form, but it does not work correctly outside of a domain. Outside of a domain it only gives the IP address. I am sure it is probably how I coded it, but I cannot think of any other way to get that info in a user friendly way. Is there a way to parse a command prompt command to specific fields inside of a form such as the command ipconfig /all?
View 3 Replies
May 5, 2011
I am making a change to an existing process. Currently the csv file (which can have embedded "," with the field in quotes), i being passed as an
IO.StreamReader parameter pStreamReader.
dim vLine as string = pStreamReader.ReadLine
dim vFields () as String = vLine.Split(","c)
Well ... obviously the split does not work with embedded commas in a field. Looked at TextFieldParser, but it is in the FileIO class and the module is passed a IO.StreamReader. Can it work?
Or how abour a RegEx? Does anyone have any suggestions? I have look around on the internet and it seems like a common questions with a bunch of wild goose chases.
View 10 Replies
May 5, 2011
I am making a change to an existing process. Currently the csv file (which can have embedded "," with the field in quotes), i being passed as an IO.StreamReader, pStreamReader to my module.
The code reads ....
dim vLine as string = pStreamReader.ReadLine
dim vFields () as String = vLine.Split(","c)
Well ... obviously the split does not work with embedded commas in a field. Looked at TextFieldParser, but it is in the FileIO class and the module is passed a IO.StreamReader.
Or how abour a RegEx? I have look around on the internet and it seems like a common questions with a bunch of wild goose chases.
View 1 Replies
Jun 12, 2012
Here is a snippet of an XML file that I need to read with VB.NET[code]...
I am familiar with creating a new XmlDocument and using the Load method to read the file. I know how to get a collection of child nodes and loop through them to get elements and attributes. But in this case, I need to extract all of the data between the two "verse" tags (the starting one with the "sID" attribute and the ending one with the "eID" attribute), including the tags and the data in between as one continuous string. I can loop on the nodes, but I only get the "w" nodes and one final "#text" node for the period, but I don't know how to get the spaces and punctuation between the "w" tags.
View 3 Replies
Dec 7, 2010
I have a comma delimited text file with the U.S. States and their respective state bird listed in the following format.
"ALABAMA", "YELLOWHAMMER"
"ARKANSAS","...
"...
What im trying to do is parse the rows and send the parsed data to different comboboxes. I have a combobox for states and one for birds.I can load the file into the first combo box but im not sure how to parse and send the second column to the second combobox. here is what i have so far.
[Code]...
View 10 Replies
Jul 29, 2010
How can I actually send a string or another variable on the run to another running .net app? I searched google and found nothing really,
View 3 Replies
Apr 10, 2009
I have a text file that is in a comma separated format, delimited by " on most fields. I am trying to get that into something I can enumerate through (Generic Collection, for example). I don't have control over how the file is output nor the character it uses for the delimiter.
[Code]...
View 12 Replies
Apr 15, 2012
how to convert rss feeds to datagrid in this fomat
<Row>
<Cell><Data ss:Type="String">Symbol</Data></Cell>
<Cell><Data ss:Type="String">Close</Data></Cell>
<Cell><Data ss:Type="String">Prev</Data></Cell>
[code]....
the values in the first <row> </row> of data are the column headings for the corresponding cells in the other <row> </row>considering that I can work with xml in the other format this is quite strange so any help will be needed.
View 3 Replies
Aug 13, 2010
I am using mysql and I have installed the connector... here is a sample of my code. so far I can sucessfully connect to the db, but i am trying to learn how to parse sql commands to the db. for example in this snippet, i wanted to add to the testing table, an entry consisting of Fname and Lname.... It is not working... what should i be doing different ??
Imports
MySql.Data.MySqlClient
Imports
[Code].......
View 2 Replies
Oct 8, 2009
how to read and write xml, could someone possible provide sample xml and code to parse it so I can understand it more? Is it possible to parse the xml from a textbox?
View 1 Replies
Jun 20, 2011
I have a function that excepts a Message from MSMQ, I convert the body of the message into a string which represents an XML document. I need to parse through the XML document, grab the values from the nodes and process them. I am having problems using either XDocument of the XMLReader, both of them give me the error "Illegal characters in file". Here is a copy of the XML file as it is deserialized from the message:
<?xml version="1.0"?> <queueOrder xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <InterfaceName>EPN</InterfaceName> <Ingot>U06506L</Ingot>
[Code].....
View 6 Replies
Oct 24, 2009
I am fairly new to vb.net, but have quite some experience with Delphi, and did some VBA. Oh, I'm old school. I like DOS.
So, I need to write a program, and chose vb.net (visual studio 2008) as my language to do this in.
What the program is supposed to do is generate a webpage hit (but not necessarily render the html in a browser) and then parge through the returned HTML code, finding links, certain key words etc.
View 2 Replies
Jan 11, 2012
I'm trying to parse data from the web, basically, from an API rl...How do I approach this? Could I use XMLDocument to do this or MSXML2? [code]I've only worked where the node root doesn't have the name of the thing I need. So, how would I specifically retrieve the data for the node symbol? [code]
View 2 Replies
