Regular expression (regex) required


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Regular expression (regex) required
# 8  
Old 01-06-2010
MySQL

I want to allow alphanumeric characters and single dot in between the characters,multiple dots should not be allowed.

ex :
1 . (single) dot should not be allowed in the string
2. ...... (multiple dots should not be allowed in the string)
3. a.b.c (dots in b/w the characters can be allowed)
4. special characters other than alphanumeric characters should not be allowed


regex should pass the above mentioned criteria
# 9  
Old 01-06-2010
Please test this:

Code:
^([a-zA-Z0-9]+\.?)+[a-zA-Z0-9]+$

# 10  
Old 01-06-2010
How about:
Code:
egrep -v "([^a-zA-Z0-9.]|^\.|\.\.|\.$)"

# 11  
Old 01-07-2010
MySQL

The following is the jquery code.
Here am reading the values entered in the text box and evaluating that string.

variable fName contains the original string here .

Code:
$("#fName").blur(function(){
        var fName = jQuery.trim($("#fName").val());   // removing white spaces
        var words = fName.split(/[^a-zA-Z0-9.]/);   // allowing only alphanumerics and //.(dot character) here
  
        nfName = jQuery.trim(words.join(" "));   // again joining the string
        if(nfName != fName)
        {
                alert("Special characters other than \".\" are not allowed");       
        }       
});

am able to block all special characters except .
but i want the following criteria to be passed.

ex :
1 . (single) dot should not be allowed in the string i.e (complete string should not be single dot)
2. ...... (multiple dots should not be allowed in the string) i.e (string should not be only dots)
3. a.b.c (dots in b/w the characters can be allowed)
4. special characters other than alphanumeric characters should not be allowed


please post the ideas.

Last edited by pludi; 01-07-2010 at 02:19 AM.. Reason: code tags, please...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help required in writing the regular expression.

1 1982 1 testing init.cc 3001 Apr 25 2014 09:56:13.617 Task(0x5bac5060) tRestart (stack st:0x5bace000, end:0x5bac8000) deleted 1 1982 1 testing init.cc 3001 Apr 25 2014 09:56:13.628 Task(0x5bac5060) tRestart (stack st:... (12 Replies)
Discussion started by: VSSajjan
12 Replies

2. UNIX for Advanced & Expert Users

sed: -e expression #1, char 0: no previous regular expression

Hello All, I'm trying to extract the lines between two consecutive elements of an array from a file. My array looks like: problem_arr=(PRS111 PRS213 PRS234) j=0 while } ] do k=`expr $j + 1` sed -n "/${problem_arr}/,/${problem_arr}/p" problemid.txt ---some operation goes... (11 Replies)
Discussion started by: InduInduIndu
11 Replies

3. Emergency UNIX and Linux Support

Regular expression (regex) clean up text

Hi, Server - MEDIAWIKI - MYSQL - CENTOS 5 - PHP5 I have a database import of close to a million pages into my wiki, mediawiki site, the format that were left with is not pretty, and I need to find a way to clean this up and present it nicely... I think regex is the best option as I can... (1 Reply)
Discussion started by: lawstudent
1 Replies

4. Shell Programming and Scripting

passing a regex as variable to awk and using that as regular expression for search

Hi All, I have a sftp session log where I am transferring multi files by issuing "mput abc*.dat". The contents of the logfile is below - ################################################# Connecting to 10.75.112.194... Changing to: /home/dasd9x/testing1 sftp> mput abc*.dat Uploading... (7 Replies)
Discussion started by: k_bijitesh
7 Replies

5. Programming

Perl: How to read from a file, do regular expression and then replace the found regular expression

Hi all, How am I read a file, find the match regular expression and overwrite to the same files. open DESTINATION_FILE, "<tmptravl.dat" or die "tmptravl.dat"; open NEW_DESTINATION_FILE, ">new_tmptravl.dat" or die "new_tmptravl.dat"; while (<DESTINATION_FILE>) { # print... (1 Reply)
Discussion started by: jessy83
1 Replies

6. Shell Programming and Scripting

Required help in perl regular expression substitution for this date format

Hi, I have written a small perl script to handle particular date format using perl, but it is not substituting the whole string. Can some one please check on what is the issue with the code. $_ = "Date: November 25, 2010 09:02:01 PM";... (1 Reply)
Discussion started by: sarbjit
1 Replies

7. Shell Programming and Scripting

Integer expression expected: with regular expression

CA_RELEASE has a value of 6. I need to check if that this is a numeric value. if not error. source $CA_VERSION_DATA if * ] then echo "CA_RELESE $CA_RELEASE is invalid" exit -1 fi + source /etc/ncgl/ca_version_data ++ CA_PRODUCT_ID=samxts ++ CA_RELEASE=6 ++ CA_WEEK_NO=7 ++... (3 Replies)
Discussion started by: ketkee1985
3 Replies

8. UNIX for Advanced & Expert Users

Regular expression / regex substition on Unicode text

I have a large file encoded in Unicode that I need to convert to CSV. In general, I know how to do this by regular expression substitutions using sed or Perl, but one problem I am having is that I need to put a quotation mark at the end of each line to protect the last field. The usual regex... (1 Reply)
Discussion started by: thomas.hedden
1 Replies

9. Linux

Regular expression to extract "y" from "abc/x.y.z" .... i need regular expression

Regular expression to extract "y" from "abc/x.y.z" (2 Replies)
Discussion started by: rag84dec
2 Replies

10. Shell Programming and Scripting

Regular Expression + Aritmetical Expression

Is it possible to combine a regular expression with a aritmetical expression? For example, taking a 8-numbers caracter sequece and casting each output of a grep, comparing to a constant. THX! (2 Replies)
Discussion started by: Z0mby
2 Replies
Login or Register to Ask a Question