x27;$Phone
Business$','+',''),'/',''),'-',''),'(',''),')',''),'!',''),'#',''),'*',''),'
,','')),'.','
(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Friday, April 04, 2008 9:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Phone number formatting...
**
Most applications default phone number columns to characters instead of
number.. This is to allow flexibility for users to put sp
to mine to revert at this phase!
Thanks for your suggestions..
Cheers
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of PS_Is_Fun
Sent: Friday, April 04, 2008 9:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Phone number formatting
e '' end +
case when substring( PHONE , 21 , 1 ) LIKE '[0-9]' then substring( PHONE ,
21 , 1 ) else '' end +
case when substring( PHONE , 22 , 1 ) LIKE '[0-9]' then substring( PHONE ,
22 , 1 ) else '' end +
case whe
OTECTED] Behalf Of Grooms, Frederick W
Sent: Thursday, April 03, 2008 6:20 PM
To: arslist@ARSLIST.ORG
Subject: Re: Phone number formatting...
**
I just realized I meant to give an example
Say you are on an Oracle db and you want to force all of your Login Names
in the User form to be c
---
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Grooms, Frederick W
Sent: Thursday, April 03, 2008 5:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Phone number formatting...
**
Joe,
You do know that you can use the TRANSLATE to drop characte
e
versatility of the Set Fields from SQL action and the Oracle psuedotable
DUAL
Fred
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Thursday, April 03, 2008 4:57 PM
To: arslist@ARSLIST.
Souza
Sent: Thursday, April 03, 2008 4:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: Phone number formatting...
**
I didn't get what you were trying to send but, I did work out a pretty
good query that cleaned up the results on a view form, but they are not
willing to accept that solution as its a vie
e(replace(replace(replace(replace(replace(replace(replace(PHO
NE_ALTERNATE_BUS,'+',''),
'/',''),'-',''),'(',''),')',''),'!',''),'#',''),'*','&
an write to get rid of everything in the range a to
> z
> and A to Z??
>
> Any ideas?
>
> Joe D'Souza
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.518 / Virus Database: 269.21.7/1327 - Release Date: 3/12/2008
> 1:27 PM
>
>
I do the phone number formatting with a sweet little filter plugin.
Email me off the list for more information. Doug "UWIP" Tanner
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black
Sent: Thursday
I have to create a
> filter to trap when AIE does the submit or modify to run it??
>
> Joe
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] Behalf Of Carey Matthew Black
> Sent: Thursday, March 13, 200
To: arslist@ARSLIST.ORG
Subject: Re: Phone number formatting...
**
Joe,
Here is a SQL Server function that can be used to format your phone
numbers. It works with US 7 and 10 digit phone numbers and 10 digit phone
numbers with extensions. I like using a function because you can call it
Sent: Thursday, March 13, 2008 7:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: Phone number formatting...
Joe,
I would look toward the Java Scripting Plugin. (Call a Filter Plugin and use
RegEx's from there.) That approach will keep the work in the Application
layer and also keep it RDBMS indepe
@Ext)
RETURN @ReturnValue
END
Stephen
Remedy Skilled Professional
____
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Sent: Wednesday, March 12, 2008 10:20 PM
To: arslist@A
f Of Kurniadi
> Sent: Wednesday, March 12, 2008 11:23 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Phone number formatting...
>
>
> Hi Joe, how about export the data and using text editor with regular
> expression feature to clean it up. I use Notepad++ (it's open source)
>
>
] Behalf Of Kurniadi
Sent: Wednesday, March 12, 2008 11:23 PM
To: arslist@ARSLIST.ORG
Subject: Re: Phone number formatting...
Hi Joe, how about export the data and using text editor with regular
expression feature to clean it up. I use Notepad++ (it's open source)
Some regexes to clean the
Hi Joe, how about export the data and using text editor with regular
expression feature to clean it up. I use Notepad++ (it's open source)
Some regexes to clean the data
- replace all format of Ext and x to unique string
replace: [Ee][Xx][Tt]\.*
replace: x
- replace non digit
replace: [^1-9]
- c
In the intention to clean up the phone number information that is coming
from a PeopleSoft database that has phone numbers in a practically free
format I am trying to write a select statement so that all non numeric
characters in the field will be eliminated.
A sample of the phone data could be
##
19 matches
Mail list logo