I have to process a string that could include all sorts of non-standard characters and I've been asked to provide a regular expression that will match and remove all characters that are non-alphanumeric except punctuation and spaces. Is there a way to do this?
View 3 RepliesI need to define a regular expression that accepts Alphanumeric and the following special characters:
@#$%&*()-_+][';:?.,!
I've come up with:
string pattern = @"[a-zA-Z0-9@#$%&*+-_(),+':;?.,![]s\/]+$";
But this doesn't seem to be working.
It's the same with how to remove double white space using regexp
View 3 RepliesI have to match string like "DAY1","DAY2","DAY3"....."DAY31" with regex in vb.net. I tried something like this - ^?DAY(0[1-9]|[12][0-9]|3[01])$ but it did not work.
The pattern should have succesfull match if the source string is either DAY1 or DAY2 or DAY3 to DAY31 like so.
I'm working in Microsoft Access attempting to concatanate the results of a query into a single string. The code looks like this:rtn = Trim(rs.Fields(0).Value) Trim$(rs.Fields(1).Value)When I display the string in a list box, I only see the value for Fields(0) I cannot see the value for Fields(1).When I run the code in debug mode, I can see the value of rtn and it contains these non-alphanumeric boxes like this:"Earth4[] Admin[]" (where [] indicates the non-alphanumeric character)What can I do to cleanup the string, remove the [] and then display in my list box?
View 8 RepliesBasically, for each character in a charArray created from the string to split, if the character is a letter, digit, or hyphen, I append it to a temporary string. When I see a split character or the last character, and the temporary string has value, I add it to the collection to return.
For i As Integer = 0 To (charArrayLength - 1)
charToInspect = CChar(charArray.GetValue(i))
If IsLetterOrDigit(charToInspect) Or charToInspect = hyphen Then
[Code].....
I'm trying to use a GUID to generate 6 random alphanumeric characters (just letters and number). Is there a way to change the format of a GUID before it is generated. Or must I generate the GUID in its standard format and then manipulate it.
View 5 RepliesI 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>..
Essentially I am trying to replicate the Windows 7 (In-Windows) activation key TextBox form. The Form where it will auto capitalize letters, remove or deny all non alphanumeric characters except dashes every 5 characters that will be auto-input.I assume this can be done with a fairly complicated replacement Regular Expression but I cannot seem to create one to fit the needs.
This is an Example of what I have right now, but it creates an infinite loop as it removes all characters including dashes, than adds a dash, which changes the text and removes the dash again.
[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 have been trying to remove special characters. i am not able to remove many crlf in middile of the string.
View 3 RepliesI'm using Visual Basic 11 (VS 11 Beta). I am having trouble finding, anywhere, how to delete all the spaces in a text box. Here let me give you an example: The user can load in a text file, that is fine. There is a button and when the user clicks it I want every single space in the file to be removed.
View 2 Replieslets say I had a string variable that contained "Hello World!", (or whatever the string contained) how would i remove the the right most spaces to make it say "Hello World" (im reading in items from a text file using substrings that has fixed positions with one line of the text containing several different items) or does it automatically eliminate the right most spaces???
View 6 Repliesmoding my code so it can remove spaces and punuations.
Here's my code.
How do you remove spaces from a string in VB.NET?
View 3 RepliesIs there a way to set a textbox in vb such that it does not accept a space or a non-numeric character entered by a user? I am writing a program that has a textbox called "phoneField" in which the user should type in only numbers and if the user trys to type a non-numeric character or space, nothing should be displayed in the textbox. How could that be done?
View 3 RepliesHow can we remove all blank spaces from end of the string fox example the string name before remove space
View 6 RepliesI am trying to remove all spaces from a text field when a form is submitted so that the contents of the post code field match those in a database...
If drSet5c.Tables(0).Rows(0).Item("post_code") = UCase(Replace(tbPostcode.Text, " ","")) Then
response.write("Postcodes match")
[Code]....
So if the postcode in the database is AB12CD and the user types AB1 2CD the space is removed on submitting the form and the match statement shows. This is not working though.
Is there any way to remove the spaces at the end of text after it has been pulled out of an SQL Database. Ive tried timming but ive had no luck.
View 6 Repliesi need to be able to check files in a folder to check if any has spaces in there names and then remove the spaces.
View 4 RepliesI have this code, it lists all the photos in the list box, i want to rename them and remove the spaces in the files names, such as "Photo1.jpg" not "photo 1.jpg"
vb.net
Dim File As String
Dim files As String()
[Code]].....
this works but how can I rename them?
I'm implementing a feature which reads comma separated txt file from server(one line at a time). Format of file is fixed, There are 3 columns on each row. After reading the row from file I insert it in a database table. But first value of each row aoutomatically appends two blank spaces, even if there are no blank spaces at the begining of each row. I tried to use "TRIM/LTRIM/Replace" to remove blank spece from the first value of each row, but didn't succeed.
[Code]...
I want to know how remove all blank space in my Richtextbox for exemple:
(remove) hi
(remove) there
I found how removes extra blank line and here is the code : Me.RichTextBox4.Lines = Me.RichTextBox4.Text.Split(New Char() {ControlChars.Lf}, _
StringSplitOptions.RemoveEmptyEntries)
I assign title value of page using VB.NET as page.title = "a" but when I run the page and look in page view source i found it shows like <title> a </title>Problem is that i want to remove all the spaces between title tag and it show like this <title>a</title>
View 1 RepliesI use to use .Trim() code to remove spaces tell I found that It only remove spaces before and after the text only not between word
for example:
" a b c d " ---after .Trim() --> "a b c d"
so, is there any code like .Trim() but to remove spaces between letters and words?
Ive been reading up on the split function on Msdn but grasp how if I had a text in textbox1 it would remove all spaces and textbox1.text and is split the easiest method?
View 3 RepliesI want to check if a Vb.net string contains at least 3 non white space characters of which at least one non numeric character. i dont know creating the regular expression for it?
[code]...
Im trying to extract ALL urls from a webpage in between two sets of strings.
I have the code to extract all links, but I am
href="http://www.blah.com/yadayada?tf=info"
Using regex; I want to grab everything between href=" and the quotation mark at the end .
This was a snipit I found that works for extracting in between 'href="' and </a>
HTML
Regex.Matches(data, "href=""(.*?)"".*?>(.*?)</a>")
I learn best by example, and I tried piecing it together by comparing the regex match above, to a URL in between hreft" and </a> - but I couldnt do it. Ive been working on this project for a while, and im getting tired.
I've got this implementation in javascript:
EscapeForRegex = function(input) {
var specials = ["[", "\", "^", "$", ".", "|", "?", "*", "+", "(", ")", "{", "}"]
for (var k in specials) {
[code].....
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?