Re: RegEx with [modified] - C# Discussion Boards

econner1-Aug-11 9:55

1-Aug-11 9:55

Hello,

I am trying to setup a RegEx expresion to check a text box for numeric values but also have the possibility to have a < or > symbol. For example the input could be 25.1 or > 20 or < 50, etc. How can I allow for the < or > symbol?

Thanks

Re: RegEx with

PIEBALDconsult1-Aug-11 14:45

PIEBALDconsult

1-Aug-11 14:45

There is a Regular Expressions forum.

How about something as simple as: ^(\s|\d|\.|<|>)*$ (not tested).

Re: RegEx with

Peter_in_27801-Aug-11 17:18

Peter_in_2780

1-Aug-11 17:18

If you don't want to allow any spaces, try ^[<>]?\d+\.?\d*$ That scans as

^        beginning of string
[<>]?   < or >, zero or one times
\d+      one or more digits
\.?      zero or one decimal points
\d*      zero or more digits
$        end of string

Ran a few cases past Expresso and they look OK. If you want to allow scientific notation, etc, grab the examples from Expresso (see our Free Tools forum for a link) and splice in the [<>]? bit. This one won't allow .3 or >.6 - it requires a digit before a decimal point, but a few minutes with Expresso will get you anywhere.

Cheers,
Peter

ps As the previous answer indicated, the Regular Expressions forum would be more appropriate next time.

Software rusts. Simon Stephenson, ca 1994.

Re: RegEx with

OriginalGriff1-Aug-11 21:31

OriginalGriff

1-Aug-11 21:31

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Manfred R. Bihy: "Looks as if OP is learning resistant."

Re: RegEx with

econner3-Aug-11 4:38

econner

3-Aug-11 4:38

Thanks everyone for the suggestions. They have helped get started but the criteria has changed. I now need to support the following conditions:

1. a value of N/A only in the field => N/A
2. a numeric value with decimal points => 24.231
3. a numeric value that can begin with < character => < 12.1, or < .5
4. a numeric value that can begin with > character => > 27.2, or > .5

Re: RegEx with

Peter_in_27803-Aug-11 13:04

Peter_in_2780

3-Aug-11 13:04

Before we go any further, let's settle on the spec.
Is N/A required to be uppercase? Are any or all of n/a N/a n/A acceptable?
From your example, .12 is OK. What about 13. ?
Is an integer value like 123 (no decimal point) allowed?
Are there limits on the number of digits (total/before/after the decimal point)?

Your answers to these questions do not affect the solvability of the problem (the existence of a suitable regex), but they do affect the solution (the value of the regex).

Cheers,
Peter

Software rusts. Simon Stephenson, ca 1994.

Re: RegEx with

econner3-Aug-11 13:27

econner

3-Aug-11 13:27

Basically, I have a field that either can take an integer value up to 3 digits or a decimal value with up to 2 decimal places. I change the mask in code before the screen is displayed. Below is an example of the existing masks.

TextBox1.Mask ='\d?\d?\d?';

OR

TextBox1.Mask = '\d+.\d?\d?';

Now, I need to have the integer mask have the ability to accept a <, > or N/A as well as to have the decimal mask do the same. I need it in two masks because I dont want certain fields to be able to enter decimal values and other fields to have the ability.

I also can set the textbox to foce upper case for (N/A) and set a max length if needed.

Re: RegEx with [modified]

Peter_in_27803-Aug-11 15:11

Peter_in_2780

3-Aug-11 15:11

OK. Here are a couple:
*note* these are regexes, which may or may not be suitable for use directly in a maskedit control mask field.

integer, 1 - 3 digits with N/A < >
^(N/A)|([<>]?\d{1,3})$

float, 0 - 2 decimal places, with the same extras
^(N/A)|([<>]?\d+\.\d{0,2})$
This one requires at least one digit before the decimal point. If you want to allow .12 change the + in the middle to * .

Following the "teach a man to fish" philosophy, I strongly recommend you get yourself a copy of the free tool Expresso[^]
(I have no connection to Ultrapico other than as a very satisfied user.)

Cheers,
Peter

[edit] added *note* [/edit]

Software rusts. Simon Stephenson, ca 1994.

modified on Wednesday, August 3, 2011 9:17 PM

Re: RegEx with

econner3-Aug-11 15:32

econner

3-Aug-11 15:32

Thanks for the assistance and thanks for the link to Expresso.

processing ozf2 and ozf3 file with c#?

Mohsen Shahindust1-Aug-11 4:11

Mohsen Shahindust

1-Aug-11 4:11

hi to every one
i try to use ozf2 or ozf3 file in my application
is there any way to use this files with C#?
i know the ozf file is indexed image file with it we can load part of image in memory
but how can do that?
i want use this image for GPS map file
if can't do this is there any other way to load GPS map?

Re: processing ozf2 and ozf3 file with c#?

David19871-Aug-11 5:10

David1987

1-Aug-11 5:10

mohsen-unique wrote:
is there any way to use this files with C#?

Yes, always. A file is just a bunch of bytes, nothing stops you from using them.
I have no idea what a ozf2 files looks like inside though.

Re: processing ozf2 and ozf3 file with c#?

Mohsen Shahindust1-Aug-11 5:17

Mohsen Shahindust

1-Aug-11 5:17

the ozf2 file is a kind of file for map that used in oziexplorer program.this program in gps tracking
for more information about oziexplorer go to http://www.oziexplorer3.com/[^]

Re: processing ozf2 and ozf3 file with c#?

David19871-Aug-11 5:24

David1987

1-Aug-11 5:24

Ok, I can't find any useful information there though - such as the structure of the file.

Re: processing ozf2 and ozf3 file with c#?

Mohsen Shahindust1-Aug-11 5:31

Mohsen Shahindust

1-Aug-11 5:31

i have same problem i can't found any information about structure of the file Cry | :((

Re: processing ozf2 and ozf3 file with c#?

Pete O'Hanlon1-Aug-11 5:38

Pete O'Hanlon

1-Aug-11 5:38

So what are you trying to do? Crack open the files so that you can extract the underlying maps?

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Re: processing ozf2 and ozf3 file with c#?

Mohsen Shahindust1-Aug-11 5:46

Mohsen Shahindust

1-Aug-11 5:46

na i want use the ozf file for my application that load map file and show the location of user from GPS device

Re: processing ozf2 and ozf3 file with c#?

Pete O'Hanlon1-Aug-11 5:53

Pete O'Hanlon

1-Aug-11 5:53

It looks like this file format was invented by the author for his application. I doubt you'll find it readily available anywhere I'm afraid.

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Re: processing ozf2 and ozf3 file with c#?

David19871-Aug-11 5:53

David1987

1-Aug-11 5:53

See if the file looks like this:
https://svn.osgeo.org/gdal/sandbox/klokan/ozf/ozf-binary-format-description.txt[^]

how run access query with params

goldsoft1-Aug-11 4:05

goldsoft

1-Aug-11 4:05

hi i have this code for update datetime fileds in access using params
SQL = "update ConfTbl set D_from = @MyFrom , D_to = @MyTo where Code = " + Convert.ToInt32(TmpCode1) + "";
OleDbCommand Cmd = Conn.CreateCommand();
OleDbParameter dateparam1 = Cmd.Parameters.AddWithValue("@MyFrom", DbType.DateTime);
dateparam1.Value = dt_From.Value;
OleDbParameter dateparam2 = Cmd.Parameters.AddWithValue("@MyTo", DbType.DateTime);
dateparam2.Value = dt_To.Value;
Cmd.CommandText = SQL;
Cmd.ExecuteNonQuery();
how to change this for run query that find between two dates ?
somthing like: `select * from ConfTbl where Tdate >= #MyFrom# and Tdate <= #MyTo#`
thanks in advance

Re: how run access query with params

Not Active1-Aug-11 4:11

Not Active

1-Aug-11 4:11

One, this seems related to what you posted directly below. Edit the original, don't start a new thread.

Two, FORMAT your code snippets!!!

I know the language. I've read a book. - _Madmatt

find data between 2 dates

goldsoft1-Aug-11 2:25

goldsoft

1-Aug-11 2:25

hi
i have in my access datetime filed that hold date in short format in this format: `01/08/2011`

i have in my C# program datetimePicker that hold date in this format:

`dt_from_A.Value.ToShortDateString()` and hold `01/08/2011`

i try to run this query :

SELECT * FROM ReturnConfTbl where Tdate >= #01/08/2011# and Tdate <= #01/08/2011#

but i dont receive any records

Re: find data between 2 dates

SomeGuyThatIsMe1-Aug-11 2:45

SomeGuyThatIsMe

1-Aug-11 2:45

in sql server, both of those dates default the time to midnight, not sure bout other db's but i assume its the same. If all you have is the one date you can use a some DATEADD function to add a day to it and just make the query Tdate < date + 1. all the db's i've seen have some form of that function as do most popular languages..even javascript can do it.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: find data between 2 dates

PIEBALDconsult1-Aug-11 2:52

PIEBALDconsult

1-Aug-11 2:52

goldsoft wrote:
filed that hold date in short format in this format: `01/08/2011`

Don't store dates as text/char; use a proper date/datetime datatype.

goldsoft wrote:
and hold `01/08/2011`

No, it holds a proper DateTime value; it simply displays the value in that format (or any other).

goldsoft wrote:
>= #01/08/2011# and Tdate <= #01/08/2011#

Use a parameterized query.
Those two values are the same, so you will only get rows with exactly that value. You could use the AddDays method of the DateTime type to calculate the second value.

Re: find data between 2 dates

OriginalGriff1-Aug-11 8:34

OriginalGriff

1-Aug-11 8:34

As PIEBALDconsult said, store dates and times in a proper DateTime, and hand them through as parameters.

It is also worth noting that Access (like every other database I have seen) uses ISO format for dates anyway: yyyy-MM-dd so the query you tried would not work as the date format would cause an error.

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Manfred R. Bihy: "Looks as if OP is learning resistant."

Re: find data between 2 dates

#realJSOP1-Aug-11 9:54

#realJSOP

1-Aug-11 9:54

This is a SQL question, not a C# question.

You want to use the BETWEEN keyword in your SQL query:

SQL

select * from table where table1.datecolumn BETWEEN date1 AND date2

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.