Log In

Log In



Not registered yet?


Reset password Activation link

Forums ~ FAQ's

How to use Regular Expressions in QuintaDB
April 12, 2011
Completed
0
 

Igor Petrushenko
April 12, 2011

In QuintaDB you can use Regular Expressions as an advanced validation option for text fields.


Go to the Fields menu. Open text field for editing. Find the link Additional options under the Validation section and click on it.
Insert Regular Expression in the field Format.


Regular Expressions


You can use this validation for mobile number checking.
Example:

/^[ 1 ]\d{6,15}$/ – USA phone number format. Starts with the 1 then from 6 to 15 digit.

/^([ 2 ][ 1 ][ 2 ]|[ 3 ][ 1 ][ 5 ]|[ 3 ][ 4 ][ 7 ]|[ 5 ][ 1 ][ 6 ]|[ 5 ][ 8 ][ 5 ]|[ 6 ][ 0 ][ 7 ]|[ 6 ][ 3 ][ 1 ]|[ 6 ][ 4 ][ 6 ]|[ 7 ][ 1 ][ 6 ]|[ 7 ][ 1 ][ 8 ]|[ 8 ][ 4 ][ 5 ]|[ 9 ][ 1 ][ 4 ]|[ 9 ][ 1 ][ 7 ])\d{7}$/ – NY phone codes.

/^([ 0 ][ 8 ][ 0 ][ 0 ]|[ 8 ][ 0 ][ 0 ])\d{7}$/ – For free 800 or 0800 numbers.

/^([+][ 3 ][ 3 ]|[ 3 ][ 3 ])\d{8,9}$/ – For France numbers, format +33 or 33 and from 8 to 9 digits


Regular Expressions in MyTaskHelper.png

Reply:

File attachment (max 10MB)




Share the discussion in the social networks:





Tags

#Android

#CSV

#Can't be blank

#Excel

#Export

#Google

#HIPAA Compliance

#HTML

#IP

#Import

#Mobile

#PCI compliant

#QuintaDB

#SMS

#URL

#access rights

#account

#actions

#activation

#activity

#advanced options

#api

#attach

#autocomplete

#autoincrement

#background

#backup

#birthday

#blocked

#boolean

#browser

#button

#calendar

#captcha

#chart

#checkbox

#clone

#close the form

#cms

#color

#column

#conditional formatting

#confirm

#constant

#cookies

#country

#crm

#css

#custom

#data security

#database

#date

#date & time

#date format

#description

#dropdown

#dublicate

#duplicate

#dynamic form

#email

#example

#extract

#field

#field names

#field type

#file

#file upload

#filter

#font

#form

#form builder

#formatting

#formula

#forum

#free

#ftp

#gap

#geolocation

#grouping

#horizontal

#id

#iframe

#images

#in-place editing

#instruction

#integration

#invite

#java

#js

#language

#limits

#link forms

#links

#location

#log

#login

#logo

#map

#mc access

#members

#moved form

#moved project

#ms access

#multiline field

#multipage form

#multiple

#multiple forms

#mysql

#new features

#new window

#newsletter

#not empty

#notification

#number field

#number of records per page

#number separator

#numbered column

#offer

#offline

#operand

#page break

#partnership form

#password

#payment

#pdf

#phone number

#plan

#popup

#portal

#position

#print

#quotation tool

#radio button

#records

#redirect

#referral program

#registration

#regular expressions

#relationship

#remind

#remove

#rename

#report

#rules

#script

#scroll

#search

#security data

#security menu

#server

#service

#sheets

#show/hide

#side by side

#signature

#size

#sort

#special character

#state

#storage

#subscribe

#suggestion

#support

#table

#team

#template

#text

#text direction

#time

#total

#trial

#tutorial

#two-column

#update column

#update records

#updates

#upload file

#users

#validation

#video

#view

#widget

#window

#wysiwyg

#youtube

#zip code