Is it possible to use regex with Range.Find.Text or set the Word.Range according to a regex in word automation? I just want to find strings that match a regular expression an manipulate them.
View 2 RepliesI want to match a string for example "yes" but where it is not in brackets so that the following would be matched: yes (bla yes bla) bla yes
View 7 RepliesHow can I match the domain part only of a URI with regular expressions? I see lots of examples but the mutch the subdomain too. What I am looking to do is to capture only the domain. So, for example [URL] should match only google. As a secondary question, I am looking to implement this on a VB.NET program. Would there be some other way to do it without regular expressions?
View 2 RepliesI want a regular expression for the following issue:I want to match a string that contains A,B,C,D,E and F. string length should be 0 to 6. and not character should be repeat in the string.Example: ABCDEF, ACDEFB, EFBCDA, etc. but not ABBCDES/W Engineer
View 3 RepliesI would like to match a certain url from an html page using a regular expression. For example I only want the url that appears after the <h2 header in the html page.basically here is the url I want to match; so what would the regular expression look like.
<h2 style="display: block"><a href="http://url.com/">url</a></h2>
I have matched the href part, but I only need to pull this particular one on the page that appears after the h2 header.
I want to match whole words for any kinds of strings, my
Text: to happening behitond .to.the to curtains of this .<NET> open <NET> sou<NET>rce project.<NET>
now i have tried this to find "<NET>" (without quotes) the whole word with[code]...
Quick RegExp problem (i hope). I need to identify a sub string from any string based on a regular expression. For Example, take the following strings:
[Code]...
I am pretty good with perl regular expressions but evidently I am at a loss on why this doesn't work.The code below stores "Person Test" in output variable.
im output As String
Dim userName As String = "Test, Person"
Dim re As New Regex("(w+),s(w+)", RegexOptions.Singleline)
output = re.Replace(userName, "$2 $1")
So why doesn't the following code store "#Test##Person#" in output variable.
Dim output As String
Dim userName As String = "Test, Person"
Dim re As New Regex("(w+),s(w+)")
For Each Match As Match In re.Matches(userName)
output &= "#" & Match.ToString & "#"
Next
I am trying to write a regular expression string match in vb.net. The condition that I am trying to implement is that the string should contain only alphabets and must contain atleast one letter of both lower and upper case. i.e AAA-fail, aaa-fail, aAaA-pass.
The regular expression that I have come up with is ^(([a-z]+[A-Z]+)+|([A-Z]+[a-z]+)+)$
Does anyone have a regurlar expression available which only accepts dates in the format dd/mm/yy but also has strict checking to make sure that the date is valid, including leap year support?
I am coding in vb.net and am struggling to work this one out.
Say the string is something like
bla bla bla bla (cat) bladfdskdfd dsgdsdksf (dog)
dfdshfdskdskfsdfkhsdf sdkfhdsfkdf (kathy) fdsfhdskfhdsfkd (doggy)
I want a generic.list (of string) containing
cat
dog
kathy
doggy
How to do that with regular expression in vb.net
Later I want to do something more complicated like getting all strings between "url":" and ", from this strings
[Code].....
Looking for a Regular Expression that will extract all links out of Href=""
View 5 RepliesI am trying to use a regular expression to find a certain string within a textbox.
Is it possible to include the equals sign (=) within the regex so it looks for this? When i type the equals sign within the regex it doesn't fnid it any more.
Works when searching this string - "and JobID 816138</Detail>":
[Code]....
Dim RX As New System.Text.RegularExpressions.Regex("(?<=" & TextBox1.Text & "</a></td>s<td>).+?(?=</td>)", System.Text.RegularExpressions.RegexOptions.IgnoreCase)
If textbox includes ( or ) it does not find anything? (Using them at text box)What would be reason for that?
I am importing data from an Excel spreadsheet into an array. I want to search the array to find the location of each "cell" with text that contains a certain string (e.g. "MyTestString"). So far the best I can do is loop through each element and test it using CStr, but the code takes too long to execute (please assume all variables are properly declared):
[Code]...
(1) Is there a better way than looping through each element, such as a built-in function or a lambda that will return an array containing *the location of* all string matches?
(2) Would it be faster to convert the Object array to a String array rather than using CStr on each element? If so, what is the fastest way to convert a 2-dimensional Object array to a String array?
I've considered using Excel's Find function instead, but would prefer to limit the number of Interop calls to Excel.
I am wanting to take a string of say the following:
Guiness Harp "Holy Moses"
So that in C# or VB get a match set of:
Guiness
Harp
Holy Moses
Essentially it splits on the spaces unless there are quotes around the spaces, then those words between quotes are considered a single phrase.
How do I make a regular expression to find a substring within a string that looks like: |sdrt446-7fdfs23| ? The number of characters and types change. So I need whatever in within the | |.
View 3 RepliesI may have a string for example potato in a vb.net application. I want to find all the occurrences of o and convert them to 0, so the desired out is: p0tat0.I know it can be done by the provided string operations but I need a regular expression in my scenario.
View 1 RepliesCells.Find(What:="Reaction", After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
In VBA I am able to search a text in an excel range like this:
Code:
Workbooks("Book1").Activate
With Worksheets(1).Range("C1:C10000")
[code].....
I have upgraded to Visual Studio because of the jobs I am to carry out. So I am translating all the codes from "VBA" to "VB.NET" (Visual Basic 2008)But I haven't been able to use "Find Method" in VB.NET. I am using Microsoft Office XP Standart Edition (2002 Version). I downloaded and installed Office XP PIAs. After that I referenced them in my project. I used the code Code:Imports Microsoft.Office.Interop.ExcelBut I can't do what I want Now, how can I use "Find Method" in Visual Basic 2008 to find a text in an excel range in one of my workbooks?
is there a way of getting the screen coordinates of individual cells on an open Excel sheet, what I want to ultimately do is pass in a cell range say, "A5" into a function and watch the mouse cursor move slowly to that cell. I know this might seem a weird request. I already have a mouse move function but that accepts the x/y coords in pixel terms where excel using .TOP and .LEFT give an entirely different format?
View 1 RepliesI am using Outlook 2003, VB 2008 and Win XP.I am storing user ID's in the User1 field of the Outlook Address Book. This is working find I want to Find all Address Book items with a value in User1 [code]This will find an Address Book item, even if the User1 field is not blank. When I debug, the first entry found has OlContactItem.User1 = Nothing.If I set User1 to a value (for example Id # is 1234, so I set User1 = "1234"), I can find just the one Address Book item with:[code]How can I find just the Address Book Items with User1 is blank?
View 1 RepliesI have users check off lab facilities in a UI. I want to use linq to fetch corresponding records for all of the labs that they have checked off. Basically,
Dim myRecs = (From l As EpiData In myDataContext.EPIDatas Where l.facility= _
one of the checked labs
So basically, I need to write a linq query where the "strings" to match are determined at runtime. Is there any way to do this easily? I know that there is a library out there called dynamic LINQ, but (1) it's in C# and I'm writing in VB (2) I'm really just looking for a single, simple solution for this single case.
It appears that when one creates an instance of Excel, using CreateObject, (Late binding), the suggested Excel closing function (with GC.collect etc) does not work. I have tried several suggestions, and the only one that works is process.kill method. Do you see any problem in using this? BTW: the reason we are using late binding is that we cannot use Office PIAs....not sure which version of Office would be installed on the client site. We work with O2003, but the client might still be at 2000 or 2002.
View 7 Replies[Code]....
Website from download and fetch data, but i get empty value. I don't know how to make it find with multiline between " - ", but they're on different rows. (")
I have written an automation addin in Excel with C# (addin.dll). To use the addin, I need to 1. register it using "regasm /codebase c:...addin.dll"2. select in ExcelOptionsAddInsExcel AddinsAutomation the respective addin from the list
I would like to automatize 1) and 2), so that the user just needs to run an exe-file in order to use the addin. 1) should be no problem, but how can one automatize 2)?
Ok basically what I need to do is the following:Read FirstExcelDoc (attached)For every row in that: Retrieve data from sql server db based on info in the Orange columns of FirstExcelDoc Let's say I retrieved data elements A, B, C, D, and E from sql server. Then I need to enter those same data elements A, B, and C in another excel spreadsheet (which has formulas etc) After inputing A, B, and C in that spreadsheet, read a couple of calculated fields and compare those results to data elements D and E retrieved originally from SQL Server DB. Finally, output the results in the Blue columns of the FirstExcelDoc spreadsheet for that row.Loop through and do the same thing for row 2 of the FirstExcelDoc and keep on until you see "END TEST" in the FirstExcelDoc.
I'm looking for a method of doing this efficiently. I have read several articles over the past few days as well as those from Mike R. but just need some direction to get started on this.To start of I'm looking for whether to read the entire FirstExcelDoc spreadsheet or just read the info for first policy number(2nd row) and process it and write out the blue column info for that row and then loop through and come back and read the second policy number (3rd row) etc... Please attach a code snippet for either way of reading the data.
I'm using excel via interop in application.Sometimes users kill application that created excel instance and that results in excel instance sitting in memory without any chance of disposing it.First I tried to tackle this using ROT(running object table) looks like not all instances of excel are registered there.Than I tried to somehow mark excel process after it is started via interop.[code]This works as long as excel is visible but in my case excel window is invisible.All I need is to somehow mark process that started via automation with the parent PID, so that later I can kill it if parent does not exist.
View 19 RepliesI have successfully automated a PowerPoint Metrics presentation with VB.Net. However, since there were many complicated calculations, it took quite some time to make the 120+ slide presentation - so I recently tried to revamp the application to be multi-threaded.
[Code]...
I've got VS2008 and Office2010, but I don't have Office2007. Therefore, I have the Word14 Object Library but not the Word12 Object Library. Will the code that I create for Office2010 automation also work where clients only have Office2007 or will they have to upgrade their office suites?
View 1 Replies