Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 18 total
Thread Field formatting for display
Sat, Dec 29 2007 7:05 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Currently I format phone numbers prior to storing them in the table with the format depending on the STD code.

eg of formatted phone numbers

01933 626285
0207 123 456
023
07 966 202885

I'd prefer to store in the database with no spaces and format on display. Any suggestions which would work for TDBText, TDBEdit and TDBGrid?

Roy Lambert
Sat, Dec 29 2007 12:35 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Currently I format phone numbers prior to storing them in the table with
the format depending on the STD code.

eg of formatted phone numbers

01933 626285
0207 123 456
023
07 966 202885

I'd prefer to store in the database with no spaces and format on display.
Any suggestions which would work for TDBText, TDBEdit and TDBGrid? >>

Sounds like a candidate for a function in an external module and a virtual
computed column in the table. Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Sun, Dec 30 2007 4:32 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim
I can see that working for a TEDBQuery, but I'll have to experiment with a TEDBTable. Also how does it work for editing. References to the manual, or example or even just some hints appreciated.

Roy Lambert
Sun, Dec 30 2007 5:56 AMPermanent Link

"Rita"
The burning question Roy UK or planet Earth ?
Rita

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:0B95DE2D-F27A-4F32-B278-5E577D6547DC@news.elevatesoft.com...
> Tim
> I can see that working for a TEDBQuery, but I'll have to experiment with a
> TEDBTable. Also how does it work for editing. References to the manual, or
> example or even just some hints appreciated.
>
> Roy Lambert
>

Sun, Dec 30 2007 6:37 AMPermanent Link

"Rita"
Hint its nearly impossible from the number to seperate
say 0204 from a valid number that may start 02045555
but if you know the place name then its simple but dont
forget London it has 3 and some places like you will
see in the list I'am posting to binaries in the newstd.txt
file look at Bouremouth whatever way you edit that file
dont forget to remove them commas or that will mess up
your import. Wink

Rita

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:0B95DE2D-F27A-4F32-B278-5E577D6547DC@news.elevatesoft.com...
> Tim
> I can see that working for a TEDBQuery, but I'll have to experiment with a
> TEDBTable. Also how does it work for editing. References to the manual, or
> example or even just some hints appreciated.
>
> Roy Lambert
>

Sun, Dec 30 2007 9:17 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Rita


The only way I know to drag the std code out of the phone number is grab the x characters, check against a validation file and peel back until you get a match eg

01933626285 used to be my business number if the validation file contains 0193362 it'll peel back to Raunds otherwise it'll peel back to 01933 Wellingborough.

Roy Lambert
Sun, Dec 30 2007 10:33 AMPermanent Link

"Rita"
Ok then use a MaskEdit that changes after your app queries the PlaceName .
5 numerics is the highest in the prefix so that would be easy enough. I
think
4 is the lowest you could add a field something like PreFixCount containing
either a boolean or an integer for the size of the prefix I would go for the
int
myself coz gov changes everything Liverpool doesnt even get a mention
its known as Merseyside now coz of maggie freakin kill everyone thatcher.
Not even going to mention that doggie killing twit who tucks his shirt in
his
knicks john major.
Good luck
Rita

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:EED81D4A-70A8-4F02-9459-97C8A3371ED9@news.elevatesoft.com...
> Rita
>
>
> The only way I know to drag the std code out of the phone number is grab
> the x characters, check against a validation file and peel back until you
> get a match eg
>
> 01933626285 used to be my business number if the validation file contains
> 0193362 it'll peel back to Raunds otherwise it'll peel back to 01933
> Wellingborough.
>
> Roy Lambert
>

Sun, Dec 30 2007 2:05 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Rita


OK if you don't mention the major I won't mention teflon Tony.

Roy Lambert
Sun, Dec 30 2007 10:43 PMPermanent Link

Sean McCall
You can use TField.OnGetText to format the value for display.

Sean

Roy Lambert wrote:
> Currently I format phone numbers prior to storing them in the table with the format depending on the STD code.
>
> eg of formatted phone numbers
>
> 01933 626285
> 0207 123 456
> 023
> 07 966 202885
>
> I'd prefer to store in the database with no spaces and format on display. Any suggestions which would work for TDBText, TDBEdit and TDBGrid?
>
> Roy Lambert
Tue, Jan 8 2008 7:27 AMPermanent Link

Roy,

> eg of formatted phone numbers
>
> 01933 626285
> 0207 123 456
> 023
> 07 966 202885

Watch out for London etc.  

When inserting spaces in a regular UK landline phone number, to my mind
the first space goes after the STD code and before the local number.
The idea being that if you are dialling the number from within the same
STD area, you can leave off the STD code and dial just the local number.

London has now been re-joined into one area, so the STD code is 020.  If
you want to dial a London number from within London, you have to leave off
only the 020 and start with the 3, 7 or 8.  (You are one digit short on
your London example by the way.  London numbers are 8 digits long after
the 020.)  So, my preferred format for London numbers is 020 1234 5678.

The same applies to some other numbers starting with 02...

Southampton and Portsmouth are one combined area and have 8-digit local
numbers with the STD code 023.  Rita's file has Southampton listed as
02380 and Portsmouth listed as 02392, but to dial a Portsmouth number from
within Portsmouth or Southampton, you dial the 8 digits starting with 92.
(I think this is correct.  Maybe a local can confirm?)

Similarly, (I believe) Northern Ireland is one combined area with the STD
code 028, Coventry is 024 and Cardiff is 029.

--Bill Sparrow--
Definition of insanity - doing the same thing day in day out, month in
month out and expecting a different result - if you want to make a
positive change go to www.sparetimebigbiz.com and watch our 15 minute
"What's it all about" video clip - seriously you can make a difference!  
The company came top of the list in a Which report in October 2007!

Page 1 of 2Next Page
Jump to Page:  1 2
Image