I have the following string [custID] = 'A99999999' I am trying the following to remove the square brackets and the single quotes Regex.Replace(sql, "/[[]']+/g", " ") but that's not working. I keep getting the same results Note: sql is a variable holding the string above. I want the result to be
View 5 RepliesI have some existing code that looks something like this:
[tag:cb cbid="12345" cbwidth="200" cbclassname="calloutbox" cbposition="left"] Lorem ipsum dolor sit amet, consectetur adipiscing elit.
[tag:cb cbid="123" cbwidth="200" cbclass="calloutbox2" cbposition="left"] Suspendisse eleifend enim a magna pretium porttitor.
I need to write a VB .Net global function that will match these [tag:cb] and take the optional parameters and rewrite the string with Html tags.
<div id="12345" width="200" class="calloutbox" position="left">content (based on id)</div>
I need to remove all quotes from an image tag found within lots of other text. For example, I want to make
<img src="folder/image.gif" target="_blank" />
into
<img src=folder/image.gif target=_blank />
I'm using vb, and need to use a regEx specifically for the img tag and not use replace. The img tag can be in a block of other text, so I need to use regEx to search for the <img and then within that until I meet a /> I need to remove all quotes.
I have a table with many values inside of it that might have single quotes around them. I need to create a duplicate table without those single quotes. I can't modify the original table as I need to use it, 'as-is' later.
I've done this with a table.Clone and using a foreach to loop through the rows and columns removing single quotes as I need and then putting that new row into the new table. It works and it's straight forward.....but
I'd like to do the same thing using LINQ. This was my attempt....
Dim myResults = From myRow In dtTable _
From myItem In myRow.ItemArray _
Where TypeOf myItem Is String AndAlso _
myItem.ToString.StartsWith("'"c) AndAlso _
myItem.ToString.EndsWith("'"c)
I had trouble finding examples that weren't looking at a specific column in the DataRow. It looks like my code does pull back all the matching results - but I'm at a lose for how I can create a duplicate table/modify the values?
The only requirement is to not using a For Each; as I already know how to do that. I've gotten closer - but I still can't seem to create a new row or a new table.
My new approach hits a dead-end when I try to do this:
Dim MyNewRow As New Data.DataRow With {.ItemArray = myRemovedQuotes.ToArray}
The Error message I get says, "Error 1'System.Data.DataRow.Protected Friend Sub New(builder As System.Data.DataRowBuilder)' is not accessible in this context because it is 'Protected Friend'."
give me a working regex expression (C#/VB.NET) that can remove single line comments from a SQL statement ?I mean these comments:
-- This is a comment
not those
/* this is a comment */
because I already can handle the star comments.I have a made a little parser that removes those comments when they are at the start of the line, but they can also be somewhere after code or worse, in a SQL-string 'hello --Test -- World' Those comments should also be removed (except those in a SQL string of course - if possible).Surprisingly I didn't got the regex working. I would have assumed the star comments to be more difficult, but actually, they aren't.
As per request, here my code to remove /**/-style comments (In order to have it ignore SQL-Style strings, you have to subsitute strings with a uniqueidentifier (i used 4 concated), then apply the comment-removal, then apply string-backsubstitution.
static string RemoveCstyleComments(string strInput)
{
string strPattern = @"/[*][wds]+[*]/";
//strPattern = @"/*.*?*/"; // Doesn't work
[code]....
I have this text:
[Code]...
How to remove '; (anything):' and replace it with a single comma? I am sure RegEx can do it...
I have a csv that I need to parse into a gridview in vb.net. If I do SELECT *, I get the data without issue. However, I am in a situation where I need to reference the actual column names. And problem is, I have no control over the app that generates the csv, and they make the column names enclosed in square brackets.
How the heck can I do something like this:
Dim cmdSelect As New OleDbCommand(SELECT "[name], [height] FROM myTable")
so I get a return of data?
So, in an effort to be perfectly clear: I have an app that creates a csv with the column headers [name] and [height] in a table called myTable, and for the life of me I can't figure out how to return [name] and [height] specifically.
iam making a dictionary in mediawiki and for this purpose i designed a bot in vb.net when i search in a string which contains [[ code dosne detect the [[ in a string a seems it bypass the [[ code is below
[Code]...
this code search for vbNewLine & "[[ in the string and then add myid to listbox but it search "اسم نکرہ" also (without [[) so it mix up. where iam making mistake?
Is there any way to use selectnode with the attribute having both single and double quotes? If we are having single quote in the attribute we can use like below,
nodeList = root.SelectNodes("//book[contains(title,""'attribute'"")]")
If we are having double quotes we can use,
nodeList = root.SelectNodes("//book[contains(title,'"""attribute"""')]")
how can I use an attribute ['attribute"] having both single and quotes in SelectNodes.
I use SqlParameters when executing database statements. I know that I can replace a single quote with two single quotes... but in the past SqlParameters took care of this for me. I have two projects.. in one, the SqlParameter does this and it handles single quotes fine, in another, it does not and I'm at a loss why (I even copied and pasted the code):
[Code]...
I'm sure this is simple and I'll probably be embarrassed to have this question in my profile but I can't seem to get this Regex correct.
I'm tring to extract just the digits from the last group of the following string:
Properties[1].Securitymeasures[14].AdditionalSecurityType
so I want to have a regex that will return 14
The Regex I have come up with is:
[(d)+]
However - the match is returning "[14]" - including the brackets and I do not understand why. I have surrounded the d with parenthesis which should mean that this is the data I want to capture.
I am trying to build an application which does the following :
1) write some text in a richtextbox
2) when user clicks a button, the app will replace the text with another text in {} braces.
what I want is that the next time, the regex searches for any text it should exclude those which are present in {}. for eg : my world is good world and a happy world and will be a better world for everyone. first pass - change word "world"
[Code]....
I have strings that look like this {/CSDC} CHOC SHELL DIP COLOR {17}
I need to extract the value in the first swirly brackets. In the above example it would be
/CSDC So far i have this code which is not working
[Code]...
Just have a list of words, such as:
gram (g)
kilogram (kg)
pound (lb)
just wondering how I would get the words within the brackets for example get the "g" in "gram (g)" and dim it as a new string. Possibly using regex?
I am trying to make a regex that will match strings between a comma only if the comma is outside of complete brackets. Brackets inside of " " should not count. Examples below. [code]
View 6 RepliesI've got a regular expression that outputs the correct data but always puts it in quotes. Is there any way to get the data without the quotes?
Dim rgx1 As New Regex("(?<=FileID=).+?(?=FileStats)") 'find the information between these two
xReadFile = IO.File.OpenText(TextBox1.Text)'guess this can be disregarded
Wholefile = xReadFile.ReadToEnd()'and this too
MsgBox(rgx1.Match(Wholefile).Value) ' displays integer
I'm using a regex editor to help me write these and I think its just making it tougher to understand.
i'm using regex to get some information from a website, i have this code:
Dim request As System.Net.HttpWebRequest = System.Net.HttpWebRequest.Create("http://www.startkabel.nl/zoeken/index.php?zoek=" & TextBox1.Text)
[code].....
How do i remove the brackets from a string that looks like this:
[anything inside here]??
I would like to do it in one line of code
I have a string like
FVAL(XXX)="TRUE" AND FVAL(TT)="FALSE"
I want to replace all "TRUE" and "FALSE" by TRUE AND FALSE.
Now the resultant string should be
FVAL(XXX)=TRUE AND FVAL(TT)=FALSE
Will the code shown below be upto the mark for this.
Regex.Replace("FVAL(XXX)=""TRUE"" AND FVAL(TT)=""FALSE""", "[""]TRUE[""]", "TRUE", RegexOptions.IgnoreCase)
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: [[(.*?)]](?=[^[+]]*([[|$))
I have a problem with double and single quotes in a string.I have a textbox where i take a string from.In the textbox are double quotes and single quotes quotes.Problem is that if i return the string all the single quotes are replaced by double quotes.How can i get it to keep the single quotes as single quotes?
View 4 RepliesI have a string, for example "lol [-wow-] lol".
I would like to remove the brackets and the content to have something like "lol lol".
I have the following code. I tried putting brackets around all the tables and parameters with no luck. The query works in Access though.
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim str As String
[Code].....
Why does the cell text show up with �square� characters where they should be extra space?
How to remove that square characters in datagridview?
i'm having some trouble with most likely the simplest of reg ex i'm trying to get thew contents of a form: <form action='I NEED TO RETRIEVE THIS DATA' id="questionaire" method="POST"> i need to retrieve the contents of the action which is between 2 ; (single quotes rather than doubles) i have:
Dim regexSource As New Regex("(?<=action=.*?"").*?(?="")", _
RegexOptions.IgnoreCase Or RegexOptions.Singleline)
Dim regexSourceMatches As MatchCollection = regexSource.Matches(HTMLResponse)
[code].....
I made a simple gui whit vb 2005
[Code]...
I would like to know, how can I remove english quotes from a string?
e.g.: Denomina "CAMPOS" a Rua B, em local que especifica.
I want to remove this quotes, or replace it to simple quotes like "this quotes". I've tried this code, but it does not work:
Dim txt As String = mytext.Replace("""", """").Replace("""", """")
The apostrophe is used to separate data when adding records to an Access Database data table using the "INSERT INTO" SQL statement. Having apostrophes in the data really screws things up with this new software. Is there a simple workaround? Is it possible to specify a different character? Is it possible to add data without using SQL Statements? I also noticed that the new OleDbDataAdapter Add Method generates the same SQL Error because it apparently creates an "INSERT INTO" SQL Statement.gh
View 4 RepliesUser enter a command like 2+2 and instead of displaying 2+2 in the designated textbox 4 appears.
View 3 RepliesI have to create an image that is to mimic a single clock rotating hand within a square area,and the user has to choose the width and speed of the rotation and the direction.i managed to create the square area with a hand inside,with this codes and variables,
(Dim Mygraphics As graphics = e.graphics
mygrqaphics.Draw Rectangle(pens.color x1,x2,y1,y2)
mygraphics draw line(pens.color,x1,x2,y1,y2),now i have to find codes and variables to rotate the hand or line within a square area.one point remaining constant the other moving.