Regular expression to validate sql's Post: 302856075

10 More Discussions You Might Find Interesting

1. 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. 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"

3. Shell Programming and Scripting

validate a string against a regular expression

Hi there i have a script which will create unix user accounts. Id like to validate the entered string so that it is specifically 8 characters or less and consists of only ! not Is there a way to validate a string against a regular expression.. i.e size=`printf "$var | wc -m` ...

4. Shell Programming and Scripting

validate date pattern using Regular Expression

Hi, i am java guy and new to unix. I want to validate date pattern using Regex expression here is the sample program i have written. #!/bin/sh checkDate="2010-04-09" regex="\\d{4}-\\d{2}-\\d{2}\$" echo $regex if ] then echo "OK" else echo "not OK" fi But the ouput is...

5. Shell Programming and Scripting

Validate time pattern using regular expression

Hi, I am new to scripting. please help me in validating the user entered time Pattern Here is the program #!/bin/bash validateTimeFormat() { checkTime=$1 timePattern="::" if ] then echo "Valid time pattern" return 1 else echo "InValid time pattern" return -1 fi } echo "Please...

6. 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 ++...

7. 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...

8. 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...

9. Shell Programming and Scripting

Need help on regular expression

Hi , I am trying to write a mod_header module rule which will look a specific url (https://partner.testing.com) and rewrite it. The header line is given below. where the url comes in between of the line. i know ^ expression can be used for match the beginning of the line. but not sure how to...

10. Fedora

Use of regular expression

Hi, I need some help. My task is, to write a "one-line" command, which must use ls and awk. Task: Write a command-line, which should rename all files in dir from form "value1.dok" to "value2.doc". And value2=value1+1. For example: ls | awk -F: '{print "mv "$0" "$1+1".doc"}' | sh But...

LEARN ABOUT DEBIAN

tangram::type::dump::storable

Tangram::Type::Dump::Storable(3pm)			User Contributed Perl Documentation			Tangram::Type::Dump::Storable(3pm)

NAME

       Tangram::Type::Dump::Storable - map any Perl object as scalar dump via Storable

SYNOPSIS

	  use Tangram::Core;
	  use Tangram::Type::Dump::Storable; # always

	  $schema = Tangram::Schema->new(
	     classes => { NaturalPerson => { fields => {

	     storable =>
	     {
		diary => # diary is a perl hash
		{
		   col => 'diarydata',
		   sql => 'BLOB',
		   indent => 0,
		   terse => 1,
		   purity => 0
		},

		lucky_numbers => 'int', # use defaults
	     }

DESCRIPTION

       Maps arbitrary Perl data structures by serializing to a string representation. The persistent fields are grouped in a hash under the
       "storable" key in the field hash.

       Serialization is done by Storable::freeze, which traverses the Perl data structure and creates a binary representation of it. The resulting
       string will be mapped to the DBMS as a scalar value. During restore, the scalar value will be restored with Storable::thaw to reconstruct
       the original data structure.

       The structure should be able to contain pretty much anything that may be safely dumped by Storable.  However, be aware that Tan-
       gram::Type::Dump::flatten() must be able to find the persistent objects in the field.  Unless you're using classes that are implemented in
       C and contain other objects, you should be fine (Set::Object has a special work-around).

       The field names are passed in a hash that associates a field name with a field descriptor. The field descriptor may be either a hash or a
       string. The hash uses the following fields:

       * col
       * sql
       * indent
       * terse
       * purity

       The optional fields "col" and "sql" specify the column name and the column type for the scalar value in the database. If not present, "col"
       defaults to the field name and "sql" defaults to VARCHAR(255).  Values will be always quoted as they are passed to the database.

       The remaining optional fields control the serialization process. They will be passed down to Data::Dumper as values to the corresponding
       Data::Dumper options. The default settings are: no indentation ("indent=0"), compact format ("terse=1"), and quick dump ("purity=0").

AUTHOR

       This mapping was contributed by Gabor Herr <herr@iti.informatik.tu-darmstadt.de>

perl v5.8.8							    2006-03-29					Tangram::Type::Dump::Storable(3pm)