Regular expression (regex) required


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

I want to block all special characters except alphanumerics.. and "."(dot ) character

currently am using /[^a-zA-Z.]/

I want to even block only single dot or multiple dots..

ex:
. or .............. should be blocked.

please provide me the reg ex.

---------- Post updated at 05:11 AM ---------- Previous update was at 04:19 AM ----------

am trying =>[^a-zA-Z .{1}] . this is not working

Please provide me the solution asap
# 2  
Old 01-06-2010
Quote:
I want to even block only single dot or multiple dots..
can you please elaborate this?
better give an example.
# 3  
Old 01-06-2010
choose the test you want from below:-

example:-

Code:
shopt -s extglob

INPUT="Ad123"

case $INPUT in
   ( +([[:digit:]])  ) echo "$INPUT is all numbers" ;;
   ( +([[:alpha:]])  ) echo "$INPUT is all characters" ;;
   ( +([[:alnum:]])  ) echo "$INPUT is alphanumeric" ;;
   (                *) echo "$INPUT is empty or something unknown" ;;
esac

Code:
o/p
Ad123  is alphanumeric

# 4  
Old 01-06-2010
MySQL

@anchal

in first name field I want to block multiple dots
ex:

FirstName should not be => . (dot)or .......(multiple dots)

it can be => a.b.c.

am using => split( [^a-zA-Z0-9.] )


But it does not workSmilie
# 5  
Old 01-06-2010
provide i/p and desired o/p that means an example.
# 6  
Old 01-06-2010
Quote:
Originally Posted by shams11
I want to block all special characters except alphanumerics.. and "."(dot ) character

currently am using /[^a-zA-Z.]/

I want to even block only single dot or multiple dots..

ex:
. or .............. should be blocked.

please provide me the reg ex.

---------- Post updated at 05:11 AM ---------- Previous update was at 04:19 AM ----------

am trying =>[^a-zA-Z .{1}] . this is not working

Please provide me the solution asap
Hello,
what do you mean by this "I want to even block only single dot or multiple dots..
". this implies that you dont want dots at all?
the regex that you are trying is absolutely wrong.
In [ ] (character class) {}(counter) doesnt work. except it becomes a literal.
([^a-zA-Z]) implies that these alphabets are not included contrary to the one you have stated above. -> "want to block all special characters except alphanumerics.. "..
# 7  
Old 01-06-2010
Quote:
Originally Posted by shams11
@anchal

in first name field I want to block multiple dots
ex:

FirstName should not be => . (dot)or .......(multiple dots)

it can be => a.b.c.

am using => split( [^a-zA-Z0-9.] )


But it does not workSmilie

are you sure you should allow single dot at the end?
if yes, this should work ( please test first)
Code:
^([a-zA-Z0-9]+\.?)+$

if you dont want dot at the end:
Code:
^([a-zA-Z0-9]+\.?)+[^.]$

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