Complex Regex With Custom Formula Builder?
Oct 1, 2011
I have a string which is like this - MVAL("A","01-01-1900")+MVAL(B,"01-01-1900")+MVAL("C")+MVAL(D). Now I want to extract B AND D out of this using regex because it is the first parameter and it has no quotes around it in both the overloaded version of the functions. Secondly because MVAL function is an overloaded function with two versions like MVAL("A") and MVAL(B,"01-01-1900") how will I find which version of the function is being used.
I'm using System.Text.RegularExpressions.Regex method.
View 2 Replies
ADVERTISEMENT
Nov 17, 2011
I've been working straight since yesterday trying to get this to work. I'm a noob to RegEx and I've tested out about 5 different RegEx "builders" but each of them require you to navigate through the options to build the Regex...each of them has failed when I try to use them.Is there an application out there free/paid where you select the line you want to grab and the RegEx is auto generated from that highlight rather than having to try to build the line of code? [code]
View 1 Replies
May 21, 2011
I need help from the Regex wizards out there. I am trying to write a simple parser that can tokenize the options list of a Snort rule (Snort, the IDS/IPS software). Problem is, I can't seem to find a workable formula that breaks apart the individual rule options based on their terminating semi-colon. The formulas that I have cooked up grab all options between parenthesis into a single capture group.
I am using the excellent RegExr tool at the GSkinner site with some of the below sample rule options from Emerging Threats (I parsed off the rule header -- that's easy to tokenize):
[Code]...
I had to play with a few example regex's that work with quoted strings. Finally realized that I am staring at negative look-behinds that avoid quotes that are escaped. This seems to solve any other escaped character, too, because escaped characters only appear inside unescaped quotes.
View 1 Replies
Jan 5, 2009
Has anyone created a regex that matches each of the cell references in a given Excel formula? I'm trying to extract a list of cell references into an ArrayList from a provided Excel formula. Ideally, the ArrayList would also preserve any cross-tab or cross-workbook reference information. The key is for the regex to be compatible with any potential Excel formula, as the formula will change with each use.This seems to capture cross-workbook references:
'[.+'!($?[A-Z]+$?[0-9]+(:$?[A-Z]+$?[0-9]+))
View 2 Replies
May 3, 2012
I need to use regex to check if the user add the numbers of phone in this 'Formula'
0911111111,0922222222,0933333333
must the number start with '09'
must the number contains '10' characters'
must the numbers seperated by Comaa ','
View 4 Replies
Apr 4, 2011
I'm in need of some help trying to figure out the RegEx formula for finding the values within the tags of HTML mark-up like this:
<span class=""releaseYear"">1993</span>
<span class=""mpaa"">R</span>
<span class=""average-rating"">2.8</span>
<span class=""rt-fresh-small rt-fresh"" title=""Rotten Tomatoes score"">94%</span>
I only need 1993, R, 2.8 and 94% from that HTML above.
View 2 Replies
Aug 12, 2011
I want to develop select query builder in my vb.net application. If user write the "select query" in a richtext box that query will be executed and the result will be displayed in a grid view. Any one send the Sample Application for this
View 1 Replies
Dec 23, 2010
I am trying to parse the parameters of Excel formulas like "=a(b)", "=a(b,c)", "=a(b,c,d)". I'd like extract the function name "a" and the parameters "b", "c" and "d".
There are loads of examples on SO to parse HTML and so forth, but none specifically for parentheses.
So far, I've got this "=(.+)(([^,)]*)(,[^,)]*)*)" but when I parse "=a(b,c,d)" it puts "a" in match(1), "b" in match(2) and ",d" in match(3). So "c" is lost and the comma before the "d" is a pain.
How can I parse a string like this with an arbitrary number of parameters, ideally dropping the commas?
The ability to parse "=a(b(c),d(e(f)))" would be great...
Edit: I know that a parser is the correct solution and I have used Devin Cook's excellent Gold Parser with great results before.
However, the particular case I'm facing is to extract the arguments from a known Excel formula. Specifically, if the formula contains the string "=Travel(", I know that it will have 4 arguments and if they don't parse it's not a problem. This is simply a "nice to have" function which can fail occasionally without it being an issue.
regex for "=a(b,c,d)", "=a(b,c,d,e)", etc., with the constraint that there will be no nested parentheses or commas?
View 1 Replies
Jun 2, 2010
I did not see a forum for Crystal Reports but seeing as I am using CR with Visual Studio 2008 I will post here and move the thread if told to. That being said here is my problem. I created a custom function named formatTime. Here is the code
[Code]...
View 2 Replies
Feb 20, 2009
I want to place two radio buttons in so I can select one of them to use one formula, and then select the other to use another formula. I want to use the I=P(1+r)^n formula and I=P(1-r)^n formula with the radio button text showing Appreciation and Depreciation.
Heres my copy of the original code.
Public Class Form1
Private Sub cmdExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExit.Click
End
End Sub
[CODE].......................
View 5 Replies
Apr 5, 2012
I am having an issue where I am using regex.Replace to replace part of a string. The basic idea is that I want to capture the beginning of the string then replace the end of the string with a value from code. For an example pretend I have a string that says "Test Number " followed by number and I want to increment that number. I capture the "Test Number " but when I try to concatenate that capture with the new number it treats the capture ($1) as a literal and replaces the entire string with $1[new number].
[code]...
This will output "We are on Test Number 2", as expected. how I can use a variable in the replacement string portion of the Regex.Replace when including a captured group?
View 1 Replies
Feb 23, 2012
I want to take the text and some special characters between the xml tags.. My input file contains:
[Code]...
now i want the Regex to take text and the special characters between the tags <line>,<inline>..
View 2 Replies
Jun 21, 2012
I'm creating a program in VB.NET to output multiple images. Some images will have the same file name. If there is multiple files with the same name I want to add "_1_" to the end of the file name. If the "_1_" file already exists I want to increment the 1 to be "_2_". If this file already exists I want to continue incrementing the number ultil it doesn't exist. So for example "filename", filename_1_", "filename_2_", etc. Here is the code that I have tried
[Code]...
View 1 Replies
Jan 20, 2012
I'm getting an intellisenxe error saying that the statement below is expecting a ')' and is positioning the correction ater the parenthesis following "Approved". I'm not familiar with this IF syntax and I can't seem to make the correction; trial and error isn't working ;o)) If (reader.Item("Approved"), True, False) = 0), (reader.Item("DoNotDisplay"), False, False) = 0)) Then
View 2 Replies
Jun 10, 2010
I am having a problem setting up my combo box to pull its menu from a SQL Server table and store to the main data table.Currently my drop down list displays correctly but saves 'System.Data.DataRowView' to the data table. My main data table is called 'Survey' with staffname as a column, then I have another menu table of staff member names which populates the drop down menu.I found that when I remove the DataSource and populate the Items collection instead the combo box saves the correct value as expected but when I use the datasource it saves the words ''System.Data.DataRowView',[code]
View 2 Replies
Sep 9, 2010
I have combox1 and i want to dispaly Foure Columns in combox1 and I make this
Dim dr As SqlDataReader = SqlHelper.ExecuteReader(conn, CommandType.Text, "select FirstName,FatherName,GrandFatherName,FamilyName from dbo.PersonalData")
Dim dr As SqlDataReader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "GetSpecialFieldOFPersonalData")
Do While dr.Read
Me.ComboBox1.Items.Add(dr(0) & " - " & dr(1) & " - " & dr(2) & " - " & dr(3))
Loop
View 5 Replies
Apr 18, 2011
How do I use complex numbers in Visual Studio 2008 and in Visual Basic, dont tell me I spent all this money on VS2008 Pro only to find out that it cant handle complex number arithmetic!
View 1 Replies
May 17, 2012
In my spare time i give myself programming stuff to do. Today i want to write a function that goes through a string, if the string contains any numeric value the function must return false, if the string has any special characters it must also return false else return true. For example the following strings would return as follows:
String Return Value
Travis True
78* False
[code].....
View 4 Replies
Sep 15, 2009
I am currently working on a project, which purpose is to call a webservice through a VB script. VB is by far not my first language and I simply reach the point where I do not know how to go on from here.
I have a Webservice descriped in a WSDL document that defines a service that takes a complex type as parameter and returns such one as answer.
The complex type is basically just a string that is wrapped inside a class object. So what i did was to create a new class module and added a public variable to it. I created a new instance of this class, gave it for the purpose of testing a value and tried to call the webservice. Everything goes well untill i reach the call to the webservice, where the program throws an exception that says:
"Class does not support automation or does not support expected interface"
My first thought was that the initialization of the object might have gone wrong but i am quite able to set and get the values on it. So i have to assume that the object is okay. I know that the url to the WSDL document is correct, due to the fact that I can call the document via the browser and it will throw an exception of "wrong type" when i feed the soap method with a primitive.
With out luck I browsed several pages on the net to find a clue what this could. So now i wanted to give this forum a shot.
You should know that i am not able to alter the WSDL file. I have to go with the way it is. In addition am supposed to stick to VB 6.0.
I used a Form in VB to make the call to the webservice.
Here is the call procedure:
Private Sub Command1_Click()
On Error GoTo ErrorHandler
Dim tS
[Code]....
View 4 Replies
Feb 8, 2011
I have a custom modelbinder built to handle my accountRequest class.This class consists of some boolean values and a UserViewModel.The UserView Model is made up of strings such as Firstname, Last Name, Address.Originally I was just passing the UserViewModel as the action parameter but I now I need to package UserViewModel inside of accountRequest.however, now my modelbinder will not map the strings in the httpContext.Request to my UserViewModel inside of AccountRequest. All of the booleans map just fine.Is there an easy way to get his data to map to the UserViewModel properties other than hardcoding it? [code]
View 1 Replies
Mar 26, 2010
I'm trying to save some settings in a complex object. If I make a dll of the class I can then add it in the projects properties settings list as that type.When the program runs though it won't show up as anything other than nothing. I read you have to have a sub new empty constructor which I have but don't know why else this would fail.First question is how to you do this. Second is there anyway to use a class inside the project as the target of the settings type or do you have to bring a in an external dll to do this every time? [code]
View 4 Replies
Jul 29, 2009
I suppose this is more of an opinion question, but, when you start a big project, what do you think about before you even start Visual Studio? Do you setup structure and files before actually coding them, or do you code them one-by-one?
View 2 Replies
Nov 16, 2010
I have a product table which has around 90 columns in. Must of the columns are integers. When I search for an existing product and insert it into a row its fine but when I alter one of the columns and do an update using the command builder I get 'Expression Too Complex'. Does anyone know why this is happening and how to fix it?
View 4 Replies
Oct 3, 2011
Im making a herbal database program and I am having troubles setting up HierarchicalDataTemplates for my main data class.
[Code]...
View 1 Replies
Apr 15, 2009
Im trying to make an EXE with a GUI have made so they can input there info and make the program.
Im trying to make a mail sender
View 11 Replies
Feb 9, 2012
I would like to know if there is any simple/fast way to create a complex XML file, when I say complex, I mean more than 20 elements encapsulated. Although this is VB.net,unfortunately literals will not work in this case
View 2 Replies
Apr 1, 2009
I have an XML File that I am processing using LINQ. I want to basically serialize the XML data into custom objects but don't know how.
[Code]...
How can I finish the above LINQ query to populate the Children property of the Group object?
View 2 Replies
Feb 26, 2012
Imagine you want to draw a regular shape such as a triangle, rectangle ... all the way up to say a 10 sided figure ( a decagon ) or more. I know that when we try lots of sides it looks closer and closer to a circle or an ellipse. The problem I am thinking of is placing smaller circles ( or ellipses ) at the correct positions near the points of that shape as shown for a triangle below.Here comes the question(s) How could we: a) Correctly place the circles ( or ellipses ) at the points so that the sides are at a tangent to them andb) Can we combine the REGIONs of these to produce a figure with rounded points so the light blue bits get excluded? I guess that to produce a method to deal with all the mathematics involved would be quite a complex task.Has anyway previously tackled doing this or know of any .Net tools I could use for this problem?
View 11 Replies
Jun 16, 2010
I am currently trying to find a way to accurately print a complex form that I created in VB6.
I stumbled upon a company that has a very impressive package called Winform Reports.
[URL]
Currently it is only supported in .NET.
Does anything like this exist for VB6?
View 2 Replies
Aug 15, 2011
I wanna search items like MS windows search for example if i wanna search mp4 files i should write "*.mp4" its enough my searching but if i ll use filter function i cant do this on datagridview couse when i want to search something i need to know full name of this record... its to bad for me... is there any way? can i do it?
View 2 Replies
