I have 2 questions regarding replacing certain text in a string which has been found using regular expressions.For example this is my string:"<span style="font-weight: bold">This</span> is <span style="font-weight: bold">2010</span>"
View 4 Replies
I have dates like the following (note trailing 'T')
2011-11-07T15:24:28
2011-11-07T
With regex i need to extract just the date part so both will look like this
20111107
20111107
.net Have a webservice that is returning a date like 2011-11-07T15:24:28, but on some occasions it returns date with no time but still with the trailing T. This causes .net's cdate function to bail out.
I have a sub that takes a string, replaces all characters that are not alphanumberic and or a "/" and replaces it with a space. Then it goes through and replaces all multiple spaces with a single space.
Right now I am using a string builder to do this. My problem is that this action must be done several hundred to thousand times depending on the filesize I am comparing it to (1 richtextbox line = 1 string)
I believe I should see a significant increase in performance if I can figure out how to do this using a single regex.replace function.How would I go about constructing a regex.replace function that would keep all alphanumberic characters and "/" and replace everything else with a single space?
[Code]...
I've got a string which could or could not contain the substring "/announce". I would like to replace this part of the string with "/scrape" if its found...so far nothing tricky. But heres the thing: I only want to replace it if the '/' in it is the last occurring in the string. Heres what I mean:
Heres a scenario where I want the replace to happen:
MyStringWithRandomText/announce?x=19
would become:
MyStringWithRandomText/scrape?x=19
And heres another scenario where the '/' in announce is not the last '/' occuring in the string, so I dont want to replace it:
MyStringWithRandomText/announce/foo?x=19
I hope that made sense. Not sure if there is a way to handle this by only using RegEx
I have file paths such as:
' Any number of folders before and after the Project name
C:acdProject1efgsomefile.someextension'
[code].....
I have a program that goes through SQL statements, identifying component parts with a space. eg: -
SELECT * FROM tblSales WHERE CustomerID=10 AND Year=2011
Would produce the following as separate components: -
"SELECT","*","FROM","tblSales","WHERE","CustomerID=10","AND" and "Year=2011"
The problem I have however is the use of spaces within values eg.:-
SELECT * FROM tblSales WHERE CustomerNameID='Test Company' AND Year=2011
Using the same space-separating logic, this would produce components of:
[Code]...
I am using vb.net to parse my own basic scripting language, sample below. I am a bit stuck trying to deal with the 2 separate types of nested brackets.
Assuming name = Sam
Assuming timeFormat = hh:mm:ss
Assuming time() is a function that takes a format string but
has a default value and returns a string.
[code]....
I could in theory change the syntax of the script completely but I would rather not. It is designed like this to enable strings without quotes because it will be included in an XML file and quotes in that context were getting messy and very prone to errors and readability issues. If this fails I could redesign using something other than quotes to mark out strings but I would rather use this method.
Preferably, unless there is some other way I am not aware of, I would like to do this using regex. I am aware that the standard regex is not really capable of this but I believe this is possible using MatchEvaluators in vb.net and some form of recursion based replacing. However I have not been able to get my head around it for the last day or so, possibly because it is hugely difficult, possibly because I am ill, or possibly because I am plain thick. I do have the following regex for parts of it.
Detecting the parentheses: (w*?)((.*?))(?=[^(+)]*((|$))
Detecting the square brackets: [[(.*?)]](?=[^[+]]*([[|$))
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]"
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>..
txt1 = help and txt2 = me! txt3 = not here, when i enter the other box i want the okay to drop sign to come up, after drop txt1=me! and txt2 = help.if i drag to txt3 display the can't drop sign.Iv'e tried everything all i can do is replace one way.also,i want the can't drop and can drop simbols to show.so far
Public
Class Form1
Private
Sub tbMouseDown(ByVal
[code]....
I'm building a program in which it asks for your name and age and determines a ticket price based upon these details. I want it to show the person's name, then their age, (jump down a line) then their ticket price, and then it jumps down a line to show the next person's name, age and ticket price. Issue is, when it's meant to jump down to show the next person, it just completely deletes the last person's details.I'm using this line of code:
TxtFareShow.Text = (Name & Age & vbCrLf & Price) & vbCrLf
How do I fix this?
I am in desperate need of code that will allow me to search through a text file (.txt) and change the word "POLAR" to a string with a particular value, for examples sake lets say the string = "SUN"
View 1 RepliesReplacing text in an array ?
View 1 RepliesI need to make it so it will replace RichTextBox1's selected text with: <ST>, where ST is the initially selected text.
View 3 RepliesI have two lines of text which have long space (more like 14-15 spaces) before the actual text. I have tried simple replace to split and merge but nothing is working. I have also tried trim and the worst thing is that ASCII gives code of 32. But nothing works. Here is the text :
your heartburn symptoms Certain foods, such as fat, chocolate, caffeine and alcohol can aggravate heartburn symptoms 1 Certain foods (BTW it's not like it looks it is. In my actual richtextbox, when I select the space it gets selected as one big piece of space like a tab and i have also tried replacing vbtab but no use)
[Code]...
What I basically have is a small game which I want to count wins/loss/ties. I have no problem with the game aspect but need to know how I can replace a string in a csv file. IE: If Jim wins the game, his 5 needs to be turned to a 6. After googling quite a while I came across the replace() function, but it doesn't actually rewrite it back to the text file
Contents of users.txt:
Jim,1.jpg,5,1,0
Will,2.jpg,6,7,0
Tom,3.jpg,5,5,0
Snippet of
[code]....
The issue I have, is if I try to use any sort of IO function after this (WriteAllLines, streamwriter, etc) - I get a process is being used and can't touch the file (because its being read).Must I somehow create a new file with a copy of everything including the replaced string?
I am using the following code, but cannot get this to work. I have got it to work if the replacement is just of one word. So if the word test is replaced by mouse and the only thing in the file is the word test, it works.
How can I replace like this:
CH_IPVOD_filename.mpg > replace the CH_IPVOD_ with nothing for the result of:
filename.mpg
?
I would like to replace every instance of ch_ipvod_ with nothing.
Public Class Form4
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim fso, inputFile, outputFile
Dim str As String
[Code] .....
Not sure what I am doing wrong here but I have 2 buttons and a rich text box. The issue is when I click the second button to add text to the rich text box and it over writes the current text that is already in the rich text box. How can I code this second button so that the text is added to the rich text box and not replacing the current text?Here's my
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code]....
Having trouble getting this to work. I'm trying to replace the name of an old company inside a text file "Matrix Construction" with it's new name "Walsh Brothers" but it's not going to hot.
Imports System
Public Class ReplaceTest
Public Shared Sub Main()
[code].....
Not sure what I am doing wrong here but I have 2 buttons and a rich text box. The issue is when I click the second button to add text to the rich text box and it over writes the current text that is already in the rich text box. How can I code this second button so that the text is added to the rich text box and not replacing the current text?
Here's my
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
RichTextBox1.Text = "This is the first line"
[Code] .....
Also how can I add spaces in a line of text (or in the middle of a sentence) so that I can insert a variable in the line.
Example:
"This is the" variable1 "line of text"
"This is the" variable2 "line of text"
I'm new to VB and am trying to create something that will change specific words within a DB entry to a random word from a table. My goal is to change swear words to a random word in a separate table (like darn, dang, waterstopper, etc.) So far I have an "Input" table with the text I need to change and a "SwearRep" table with a list of words I need to replace in col "WBad" and their replacements in "WGood".
View 1 RepliesI'm a beginner who's been trying to learn Visual Basic for a couple of months now (no prior programming experience) and I was wondering if anyone would be so kind as to help a newbie like me out with something.
What I'm trying to do is make a Mad Libs-style program with a multi-line textbox and a button where I type in something like:
[Code]...
Replacing text with AutoText entries in Word 2007 using VB.NET
View 1 RepliesI am trying to replace a string which is actually different from line to line in a text file. I want to end up with a filename but without the path. For example:
My text file contains:
C: est estingmorefilename.mpg
C: est estfiles1 estfile4.mpg
W: estinglocation estingmore estfiles9.mpg
[Code]....
I am trying to do this but it doesn't work:
VB
Dim str As String = "07" & GetBetween("Stephen 0761234567", "07", vbNewLine)Dim op As String = "lol" TextBox1.Text.Replace(str, op)
GetBetween is just a function to match something between something else. That works fine, the string (str) sets as 0761234567 just like I want but when i try to replace the text it doesn't work.
Sorry if this seems like I haven't searched, however I have. Maybe I'm not understanding something or maybe I just haven't found what I need. Anyway my question is this. How would I find multiple strings in a text file and replace them? So far I've been able to find out how to replace a single string with:
[Code]...
I'll explain the scenario. I have a list containing character list and it's corresponding unicode characters(copied from CharMap and pasted in VB editor).
For example:
Text = Unicode --> Unicode character
---------------------------------------
K = U+004A --> J
[code].....
I am trying to figure out how to replace text in a text file on a specific line number. (for testing, line number 4).
View 6 RepliesI have some large csv files (1.5gb each) where I need to replace specific values. The method I'm currently using is terribly slow and I'm fairly certain that there should be a way to speed this up but I'm just not experienced enough to know what I should be doing. This is my first post and I tried searching through to find something relevant but didn't come across anything.
My other thought would be to break the file into chunks so that I can read the entire thing into memory, do all of the replacements there and then output to a consolidated file. I tried this but the way I did it actually ended up seeming slower than my current method.
Sub Main()
Dim fName As String = "2009.csv"
Dim wrtFile As String = "2009.1.csv"
[Code]....
I have a RegEx I am using in vb.net and i can get all the matches of the text but i want to get the first match of the text, this is what i am using.
[Code]...
