RegEx - How To Retrieve String Variable From External Source And Parse It
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?
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
I'm using a Microsoft Word form template to create objects in a form programatically, so depending on the information read by the program from the template.
So, I've got some fields where I store formula data for the form, in which I specify that the value for that field is obtained by multiplying other fields in the template. So I store in the string something like this:
"Text1.Text * Text2.Text"
So I need to convert these string values into variable calls to actually operate these values.
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.
Using VB or C#, I am getting a string of variable length from the database. This information is sensitive information that only certain users will be able to see.I have two cases that will use the same logic (I think).scenario 1: replace all characters with xscenario 2: replace all characters with x except the last 4 characters (assume length > 4 - this check is being done).I thought that this would be easiest using Regex.Replace(input, pattern, replacestring). As opposed to a lot of string handling with substrings and forcing a length of 'x's.
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?
I am trying to remove the tables within an HTML file, specifically, for the following document, I'd like to remove anything within the tags <TABLE....> and </TABLE>. The document contains multiple tables with texts in between.
The expression that I came up with, <TABLE.*>s*[s|S]*</TABLE>s*, however would remove the text in between the tables. In fact it would remove everything between the first <TABLE> and the last </TABLE> tags. I would like to keep the texts in between and only remove the tables.
Some things with the file are standard, like the "TableName" (Never in quotes) starts the table. Variables always have [" "] around them and then equal something like ["Test"] = 0. However, the variable could have multiple variables within it. split up the file within each {} and then try to parse each ["QuotedString-Key"] = 0?
I'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've used regular expressions in the past. I have an app that parses a .csv file and replaces certain characters (commas). Here's an example.. item1, item2, item3, fruits are apples, oranges, grapes. Squash is a vegetable, not a fruit. What my app does is search each line between character1 and character18 and replace all "," with "~". How this is done through regular expressions?
I have a string which i need to parse using Regex class of System.Text.RegularExpressions. I need to find if the first 2 characters of the string are either "00" or "07" or "16" or "23".
Problem: Current regex pattern does not filter all lines. Adding ^ to the beginning and $ to the ending of the pattern seems to break it as well. If I try it ont gives partial results using options(multiline & case insensitive). Using it in the application returns nothing at all.
I'm attempting to parse a text file containing several Windows paths; I'd like to use regular expressions if possible, and I'm using VB.NET.The file is formatted somewhat like so:
M - Network Mode C:ClientSystem - System Path C:ClientProducts - Product Path
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
What I'm trying to do is parse out some links via a google search and fill a text box with said results. This is the code I have in a module which I call upon inside of a command button.
I am trying to extract inforamtion from a website, I was able to get to the point of extract HTML to TXT. not I want to parse from this line TOTAL 3723
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.
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.
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.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim StrInput As String = Display.Text Dim firstInteger, secondInteger As Integer firstInteger = StrInput.IndexOf("ad_list_link", 0) secondInteger = StrInput.IndexOf("ad_list_link", firstInteger)
[Code]...
I need to string z from a webpage source file but having trouble cutting the code around it away.
I am currently working in a very large solution (120+ projects). Very often, we need to find a particular form in a large desktop application, consisting of hundreds of forms. For example, we might have a requirement to edit some controls on a certain form.We don't know the form name, but we know how to navigate to the form when running the application.
In order to identify a form, we currently try to find some unique text on the form, and then search all the source files for this string. That's not very cool.Instead, I'd like to make a little tool that can identify the source file for a form, or at least the name property of the form object. We can't add code to the solution itself, so we will have to make an external exe.
I have a MS Access database set up, with a Period field that has either values 1, 2, 3, 4 or 5. I retrieve these values using a database connection and I would like to reference a particular control based on what period was grabbed from the database.
Here's example code, pseudo of course.
TextBox(dr(3)).Text = dr(0)
dr(3) contains the period, and dr(0) contains the content I would like to put into the text box. I have these text boxes on my form: TextBox1, TextBox2, TextBox3, TextBox4 and TextBox5.
So if dr(3) contained 2 then I would want to reference TextBox2.
sort the listbox that is being populated by data from an exteranl hard drive. The DB's on the Hard drive are contained in folders with a naming format as follows (Jan94 - Dec08)The issue is that on the HD all the folders(yrs) for Apr are listed together and then the rest listed the same way, just sorted based on 1st alpha character. The format I want to show in the list box is as follows:
What I would like to do is to find a way to get the results from a HTML/Javascript script in a string, using VB 2010.To make it clean on a practical case, I would like to get, in my VB application, the results provided by the run of the following external script:The resulting string should be something like this :
I was offered this interesting scenario by a visitor of my site and have been trying a few approaches, but not seeming to get it quite right. I have a Form with a WebBrowser control (or an AxWebBrowser if that works too) and on the page loaded in the browser, is a link that uses javascript to open a new popup window.This popup window I am unable to take "ownership" of and it launches in a new instance of the user's default browser (IE for this scenario). I need to then interact with that javascript popup window which now is not part of my application. If I needed to set a value of an input box on that form, how would I accomplish that if I can't "interact" with the form?
What I would like to do is to find a way to get the results from a HTML/Javascript script in a string, using VB 2010.To make it clean on a practical case, I would like to get, in my VB application, the results provided by the run of the following external script:
<script src="http://partner.tcgplayer.com/syn/synhighlow.ashx?pk=MAGCINFO&pi=fnmp-124"></script> The resulting string should be something like this :
