I have the following regex to check if a number with 11 digits are entered
^[0-9]{11}$
Now I instead want to check if the number has 11-14 digits, how should I change my regex?
I have a table "RANGES" with the following columns
LowRange as int
HighRange as int
with the data similar to below
select * from Ranges
LowRange HighRange
1 100
101 200
201 300
.
.
.
901 1000
And another table "infoDetails" with the following columns
Range as INT
amount as money
with the data similar to below
select * from infoDetails
Range Amount
23 34.00
235 44.00
345 34.00
678 100.00
555 100.00
530 100.00
510 100.00
I need one report with the following format without cursor.
LowRange HighRange Count Amount
1 100 1 34.00
101 200 0 0.00
.
.
501 600 3 300.00
601 700 1 100.00
If we let users input a couple of ip ranges, e.g., 172.16.11.5 - 100, how could I write a fucntion to check if a IP (172.16.11.50) falls in the ranges?
Is there any existing library in .NET to leverage?
how i can implemnt a regex that cover integer range? means from 0 to 2147483647
View 9 RepliesI need to filter data based on a date range. My table has a field Process date. I need to filter the records and display those in the range FromDate to ToDate.
View 2 Replieswith a regex that would replace the following. The only thing that would remain the same is the div tags, the id's and classes could change and so could the content.
<div id="nav" class="whatever">Content is whatever</div>
I am currently using this regex to get the page number from the url:
@"/(d+)$";
Which worked fine for urls like:
/some_category/2
/some_category2/323
My urls now have some additional querystring values (optionally), so the current regex is not working for these cases.
So now I need a regex to support:
/some_category/2
/some_category2/323
/some_category2/323?a=1&b=2
/some_category2/323?&c=123&a=1&b=2
I am using a route with wildcards so I can use the built in asp.net mvc for this.
I am new at this so be easy on me... :)
I need to validate if a the ID number that the user typed in my site is a valid ID.
How do I check it?
Do I need to use RegularExpressionValidator?
More over, I also need to validate the credit card number, I found a few RegularExpressions for that in the net but each one is different from the other and I am not sure which one to use.. Does anyone know od a working expression that will suit all credit cards?
In my table below string are present which I have to replace *@*$*86$*$ with blank, how can I do? Here bold can be 0-99, in any row.
xOsyH *@*$*86$*$
M. V. *@*$*81$*$ .
i have an requirment where an user can enter multiple email address.
The validation should ensure that he should enter address in the format "something@abc.com".
my existing validation ensures that some text is entered before "@" symbol and "abc.com" is the domain.
@"w+([-+.']w+)*@abc.com$";
I would need my regex to check for the delimiter ";" between two mail id's .
valid: a@abc.com |
a@abc.com;b@abc.com|
invalid: a@abc.comm | a@abc.com,b@abc.com | @abc.com |
a@abc.comb@abc.com|
I've tried many links but ther were of no use and i'd be grateful if someone could help me modify the current one to suit my requirments
I want regex pattern for phone number as follow.
(111)-111-1111
area code should be entered in paranetheses is mandatory after area code there should be hypen and only three digit should be allowed to enter that is mandatory after 3 digit again hypen should be there that is mandatory and then 4 digit should be enter that is mandatory.
I'm trying to use the regular expression validator for a numeric ID field.The field needs to be a required field of any number.Currently, I'm using:
="d{1,}"
Shouldn't this make it so the user has to at least enter 1 digit?? If I hit the submit button with the field empty,it passes validation and posts back.But if I enter non-numeric characters, it errors fine. If I wanted zero or more occurrences,I'd use:
="(d{1,})?"
Why isn't this working? Do I need to use this in combination with a Required Field Validator? That would suck ><
How to Validate the Range of Number
[Code]....
I am trying to check if a string ends in "@something" and extract "something" from it if it does. For example, I am trying to do something like this:
string temp = "//something//img/@src"
if (temp ends with @xxx)
{
string extracted = (get "src");
...
}
else
{
}
How can I accomplish this?
I am trying to take user supplied raw numeric values (these numbers dont have decimal point) and correctly format the values to their correct currency display.
eg: user enters 2341 the routine would use regex to format it to 23.41
I cant find a way to do this. What I have tried is this:
[Code]....
It doesnt work.... sNjunk always comes out 299 instead of 2.99.Anyone out there that can help me with this? or point me in the right direction?
I am using the following code for extracting a number from string 'sentence'.
Regex.Split(sentence, @"D+");
For Ex: This is test , message contains 192837 and the message ends here.
This output would be 192837.
Now, Let say: sentence is: This is test, 2736 message contains 293743 and message ends here.
This output would be 2736293743.
But, I want only 2736. i.e The first number in a string omit rest all others.
How to deal with this?
i have a web site and the user is entering a number range like,
From:___ To: ____ Submit
Ex. From: _1_ To:_5_ Submit
But when the user click on the "Submit" button, this is what the code should do. It should insert the values in the database in this manner
1
2
3
4
5
I'm trying to build up some regular expressions to validate some textbox controls. I have done some research and testing but cannot get this one working. Examples of what i am trying to create regular expressions for are as follows:
Range 0-45, 0 decimal places
Range 0-20, 2 decimal places
Range 16-65, 0 decimal places
Range 0-99, 2 decimal places
Range 0-1500000, 0 decimal places
Range 0-200, 1 decimal place
For 1 and 5 respectively, I have used
([0-9]|[0-9]d|45)$
([0-9]|[0-9]d|1500000)$
The first one I am having problems for is an age range of 16-65 (inclusive), where I want no decimal places. After a post on here (Regular expression to allow numbers between -90.0 and +90.0) I thought I could use the logic and get it sussed, but can't! The expression I got to was:
(d|([1-6][6-4]))|65
Range validator ..
I have a text box , i need to check restrict user to enter minimum 5 character and maximum 50 character using range validator.
We are writing a feature that allows an administrator to block/allow ranges of ip addresses.
Is this easy enough to do with c#?
I was thinking of looking at each number [here].[here].[here].[here] and then mathing it with the ranges and just seeing if each number was between the two?
Will that work for standard ip v4 addresses?
I am getting Range1 and Range2 from database. Dataset is like below.
Range1 Range2
AB100 XY200
AB300 XY400
AB500 XY600
I have to bind these ranges to a Drop Down List as list items includung range number in my application.So list item should be like ==> 1 AB100 XY200 . When user selects a range I have to pass Range1 and Range2 to database.How can I bind the two ranges with range number to Drop Down List.
I'm using the ASP Validation control a wanted to test that multiline textbox content was between 2 and 40 characters. Any character can be provided, including the new line character. What would be the expression? What I have below fails.
[code]...
for some SQL queries I know the expected number of rows that must be affected by UPDATE, DELETE or INSERT statements. It could be a number such as 1 or a range such as 0-1 or 1-2 etc.
What is the best way to enforce that this is the number of affected rows and that otherwise an exception is thrown?
Also, can I limit the number of rows affected for UPDATE/DELETE/INSERT to say 1 row and otherwise get an exception?
I want to validate a number by regular expression. Here is the requirement.
1- It should be between 1 and 200
2- maximum 2 floating point (e.g. 24.54 accepted but not 24.546)
3- the radix point can be either Dot or Comma (e.g. 29.45 - 29,45 both accepted)
4- can be intiger in this range also (e.g. 24 or 24.00)
Can anyone post an efficient regular expression for this?
I am using the crystal report, in that i am using code like below to show the SQL data into the crystal report,
string req = "{View_EODPumpTest.ROId} IN " + str + " AND " + "({View_EODPumpTest.RecordCreatedDate}>=date(" + fromDate.Year + " , " + fromDate.Month + " , " + fromDate.Day + ")" + "AND" + "{View_EODPumpTest.RecordCreatedDate}<=date(" + toDate.Year + " , " + toDate.Month + " ," + toDate.Day + " ))";
ReportDocument rep = new ReportDocument();
rep.Load(Server.MapPath("PumpTestReport.rpt"));
DateTime fromDate = DateTime.Parse(Request.QueryString["fDate"].ToString());
DateTime toDate = DateTime.Parse(Request.QueryString["tDate"].ToString());
CrystalReportViewer_PumpTest.ReportSource = rep;
//CrystalReportViewer1.SelectionFormula = str;
rep.RecordSelectionFormula = str;
CrystalDecisions.CrystalReports.Engine.TextObject from = ((CrystalDecisions.CrystalReports.Engine.TextObject)rep.ReportDefinition.ReportObjects["txtFrom"]);
from.Text = fromDate.ToShortDateString();
CrystalDecisions.CrystalReports.Engine.TextObject to = ((CrystalDecisions.CrystalReports.Engine.TextObject)rep.ReportDefinition.ReportObjects["txtTO"]);
to.Text = toDate.ToShortDateString();
//Session["Repo"] = rep;
CrystalReportViewer_PumpTest.RefreshReport();
after running my application it executes fine with no exception but such error i am getting, A number range is required here. Error in File
C:DOCUME~1DelmonLOCALS~1TempPumpTestReport {14E557A7-51B3-4791-9C78-B6FBAFFBD87C}.rpt: Error in formula . '{View_EODPumpTest.ROId} IN ['15739410','13465410'] AND ({View_EODPumpTest.RecordCreatedDate}>=date(2010 , 12 , 1)AND{View_EODPumpTest.RecordCreatedDate}<=date(2010 , 12 ,25 ))' A number range is required here. error.