Use Regex To Replace Non-word Chars In A Specific Piece Of String?
May 5, 2009I have text file with a row like this:
[Code]...
I have text file with a row like this:
[Code]...
In VB.net I've got the following line that removes all non-alphanumeric chars from a string:
return Regex.Replace(build, "[W]", "")
I now need to extend this to remove non-alphanumeric chars that aren't [] or _. I've changed the line to:
return Regex.Replace(build, "[W[]_]", "")
However I'm pretty sure that this says
replace non-word or [ or ] or _
how do I negate the tests for the [] and _ chars so that it says
replace non-word and not [ and not ] and not _
Some examples:
"[Foo Bar_123456]" => "[FooBar_123456]"
"[Foo Bar_123-456*]" => "[FooBar_123456]"
make a program to replace the word followed by the selected. But I got stuck at the start..An Example:"My name is Dunley Mike and my father, Dunley Robin are on a holiday at the mountain. There they will meet the uncle Dunley Harry." So what I want to do is to loop through the text for the word Dunley (Underlined) and replace the First name (Bolded) (Mike, Robin, & Harry) to 'family'.
View 9 RepliesI have a long string of HTML code that contains several quotes around objects in the string. I have a Regex.Replace() function to change the "img src" tag, due to the way its stored in a database.
Here is my string: <p><strong><u><font color="#cc0099">RICH TEXT BOLD UNDERLINE. PICTURE TO APPEAR BELOW</font></u></strong></p><p><strong><u><font color="#cc0099"/></u></strong></p><p><img src="/inlineimages/WorkOrder/6/1245981403232.jpg"/> </p><p /><p>W00T!</p>
[Code].....
Notice how the "<font color=" has single quotes around its value, and "<img src=" has single quotes, with a double quote jammed in between?
Also, is there an automated way to go from my initial string, to the "Dim input As String" I created? I had to manually type that out, editing the quotes just to try and make it work.
I want to select a random space in a string and replace it with a word (%word%) but there is a problem. The position cannot be fixed as i want it to be inserted at a random break. Few things which iam considering :
1)break the string at a space and merge it with the word
2) find a random space and replace it with the word. I like this point and so far all i have is break the selectedtext into string array and then iterate over each line. But i don't know how to find a random string position? Any short and sweet code please?
If (rtfArticle.SelectedText.Length > 0) Then
Dim strArray As String() = rtfArticle.SelectedText.Split(New Char() {ChrW(10)})
For Each str3 As String In strArray
[code]....
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.
View 2 RepliesI've been working on this RegEx for the past day or so and I think I have it worked out so that it returns the data I want. First a little background.I have a content editor that users will be able to edit web pages. They can format text, add links, etc.. standard content editor stuff. When they click save, the editor provides the ability to get the content (editor.Content) and put it into a string. What I want to do is get any links (<a> tags) and find out if they are internal or external links and if they are PDF files.
Here is the Expression I've come up with:
<a[^<>]*hrefs*=s*[""'](?<domain>https?://[^/s'""]*)*/?(?<path>/?[^s""]+?)?[[>""']
With this, I am able to separate the domain (if it has one) and the path out. Then, I loop through the matches...
dim matchColl as MatchCollection = Regex.Matches(editorContent, regExString)
For Each m as Match in matchColl
If m.Groups("domain").value <> myInternalDomain and m.Groups("domain").value <> "" then
'this is an external domain... do some stuff
[code]....
My question is this... the parts where I 'do some stuff' to the values, what would be the best way to get that back into my 'editorContent' string? I could probably put the editorContent into a StringBuilder and do a whole bunch of replaces on it, but is that very efficient?So, for example, with the PDF, I want to specify that it open in a new window (target="_blank") and for the external URL, add some javascript code into the onclick attribute.
Problem: Your task is to take input from the user in string and give the following options to the user in a menu.
1- Find a String
2- Create sub-string
3- Erase a portion of a sting
4- Replace a word in the string
5- Count number of words and characters in the string without spaces.
6- Capitalize first character of each new sentence and convert the rest
of the characters to lower case.
7- Sort all the words in alphabetical order. (Use Bubble sort algorithm to perform sorting).
To perform all the above mentioned tasks you can only use pointers. Create a function to perform every task.
I'm trying to replace all the carriage return characters in a string obtained from a multi line text box in a Windows Form with the string ", <BR>" so that when I use the string in some HTML it displays correctly.
Function Blah(ByVal strInput As String) As String
Dim rexCR As Object
rexCR = CreateObject("VBScript.RegExp")
[code]....
i need to replace the whole word from a string.
for example. String= "Hi VBFriends, I am learning VB 2010."
i need to replace only VB as C#.
if i put String.Replace, its changing as "Hi C#Friends,I am learning C# 2010."
i used regex, Word boundary but not worked, below my code.
Dim sHTMLStream As String = "Hi VBFriends, I am learning VB 2010."
Dim oColl As MatchCollection = Regex.Matches("sHTMLStream", "\bvb", RegexOptions.IgnoreCase)
For Each sTemp As Match In oColl
MessageBox.Show(sTemp.Value)
Next
I am trying to replace an entire word in a string.
This is my example string:
"Hello test this is testing".
I want to replace the word "test" with "abc". I want the output to be:
"Hello abc this is testing".
Whenever I try and use the Replace() function I get:
"Hello abc this is abcing"
How I can do this with Replace or RegEx
I'm trying to replace a string with another but the problem is that the string is matching some other string partially.
For e.g. -
Dim x as String = "I am Soham"
x = x.Replace("am","xx")
After this replace I would only like the word am to replaced with xx but because my name also contains am its also getting replaced.
I have a string which consists of the raw HTML of a webpage. I would like to search for the first use of /imgres?imgurl= within the string and display the url of an image which follows exactly after it in a text box. Below is an example of part of the string: [URL]..In this case it would find /imgres?imgurl= then it would display [URL]...
View 2 Repliesi have to search a string for a few words eg, dog, cat, lion but i want regex to fail if lizard is found in the string even if it contains cat, dog or lion.ismatch(pass) "dog|cat|lion" "This is not your average cat!"ismatch (fail) ??? "This is not your average cat! It's a lizard."??? - here the regex statement is unknown word spaces and boundaries or lower/uppercase is not a concern. I run the string through Replace(" ", "").Trim(" ").ToLower before handover to Regex.
View 3 RepliesI've been hammering at this over the weekend with no joy - been through page after page of RegEx Language documentation too.It's very easy to negate a match on characters. For example:
Dim MatchString As System.String = "<test0><test0><test1></test1></test0></test0><test0></test0>"
Dim NegationPattern As System.String = "([^<>])"
Dim RepStr As System.String = ""
[code]....
I am reading a csv file in VB.net and saving the line to a SQL database. At a later point in my code, the SQL line is retrieved in the application, and the Split function is used to get 'field' values. The Split is done taking comma as the separator. The application processes many other files (including excel), and the split function is used for all of them. The problem I am now facing is that one of the csv files I read, has a field value that starts with " followed by multiple values separated by a comma and ends with another ". The normal reading of the csv file results in each of those single field values is taken to be a separate value.
An example line is:
Elker,MissB,"Bus, Taxi, Train, Ferry, Parking, Toll",800253
Where there should only be separated to 4 columns, they get separated to 9 columns instead. What I want to do is replaced the commas after 'Bus' and until 'Toll' with a '?' instead. I have tried using Replace, including the overloaded one with starting position, but it ends up replacing ALL the commas in the line with '?'
Attempt 1:
If vstrLine(intStartPos) = "," Then
strRetVal = Replace(vstrLine(intStartPos), ",", "?")
end if
Where vstrLine is Elker,MissB,"Bus, Taxi, Train, Ferry, Parking, Toll",800253
and intStartPos is the first instance of a comma after the "
It returns only the '?' and not the string with 1 comma replaced by '?'
Attempt 2:
If vstrLine(intStartPos) = "," Then
strRetVal = Replace(vstrLine, ",", "?", intStartPos)
end if
It returns a string with all commas replaced with '?'
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 looping through a word doc where I need to find a string to replace and these are in text box's so I thought I could do something simple like this but its not working.
vb
For Each oRng In doc.StoryRanges
Do
strTxt = oRng.Text
If strTxt = "textToReplace" Then
[Code] .....
I use a simple for each loop toi grab a piece of data from a regex like:
[Code]...
How can i replace the enter key with an other set of chars
example - text.replace(" ", "this is a space")
that previous statement will replace all spaces with the string "this is a space"
how do i do this for an enter?
I am trying to think of a regex replace to replace double quotes with nothing. Example:
hello("hi there") would become hello(hi there)
"hi" would become hi
"example "3" would become example "3
-edit Maybe an easier way to explain this is, replace all " that do not have a backslash before them.
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]...
i want to replace the value of a cell that it have a mask of time like this "##:##" i want to type the numbers and the text inside this cell be replaced for the new char for example:
value of the cell = "15:05"
so i press "2" and
new value of the cell should be like this = "25:05"
[code].....
I am trying to filter out all unwanted characters from a string. All I want in the string is letters A-Z, numbers 0-9 as well as comma (,) plus (+) and quotes (").I figured how to do the letters and numbers, but the 3 special characters are giving me a problem. I also tried with the Chr(34) equivelant for the " sign, but no luck, as and " or , messes up the way the code is read. Here�s what I have so far, but it only works for A-Z and 0-9:
STR = System.Text.RegularExpressions.Regex.Replace(STR, "[^A-Z, 0-9, Chr(43) ]", "")
I would like to search a webpage for a value in the left column of a table, then pull the value from the right column as my result. In a Visual Basic Forms Application.
the data is listed in a table, for example...
abc 123
def 234
ghi 345
jkl 456
and if i just want the value of ghi ( I know "ghi", but i want the goal of the code to find the "345")
I want to build a VB program that will go to a web site and pull out a specific piece of data.I am using VB Express 2010 not sure if it belongs in this .net forum.I am successfully getting to the website using WebBrowser.navigate()The data is provided to me in XML format and I am told that it is ready to be retrieved. They tell me to use XML Parser.When I go to their web site I see the data I need to pull out there is a column with tags in front of each piece, the piece I need is between <Vr0> and </Vr0>.I have no resources other than the net currently I do have a dummies book ordered but will be at least next week (at the earliest) before my first book arrives.Can you explain how I can sort through the data and pull out the data in XML format on a web site?
View 5 RepliesI am trying to split a long string based on an array of words. For Example:Words: trying, long, array Sentence: "I am trying to split a long string based on an array of words."Resulting string array:Multiple instances of the same word is likely, so having two instances of trying cause a split, or of array, will probably happen.
View 5 RepliesI am writing a hangman type game and I am displaying the word to the user in a label as all *'s, but I cannot figure out how to have just one of the *'s changed in the label to the correct letter when the user inputs the correct letter into the text box and clicks the check letter button.Everything else in the program works perfectly, except for this part.[code]When I use the .Replace it changes all of the *'s to the correct selected letter.
View 2 RepliesI was wondering how I would replace a specific character at a specific position.[code]...
View 7 RepliesI'm using the following VB.net Code to find phone numbers in HTML and make them "clickable":
Regex.Replace(pDisp.Document.Body.innerHTML, "([0-9+ ]{3,6}[s]{1,1}[0123456789 -/]{4,15})", "<a href=http://DIAL/$1>$1</a>")
There appears an issue if the numbers contain white spaces, for example:
089 12233 455
This will be replaced with:
<a href=http://DIAL/089 12233 455>089 12233 455</a>
Is there a way to get
<a href=http://DIAL/08912233455>089 12233 455</a>
instead?