Re: Are you as polite and diplomatic as COBOL?...


On 28-Apr-2005, "James J. Gavan" <jgavandeletethis@xxxxxxx> wrote:

> Don't be 'picky' about Telephone or SINs - accept with or without
> intervening spaces or hyphens - programatically you sort out you've got
> what you want.

I hate it when a form won't accept the phone number or credit card number or
GHIN or SSaN if I don't guess the format they want. When you can't train your
customers (such as a data-entry person) - you should make the software smart
enough to accept valid alternatives.
.

Relevant Pages

  • Re: Hyphens in Excel Sort
    ... "David McRitchie" wrote: ... How about making a helper column and sort on it. ... >> Does anyone know why Microsoft would ignore hyphens and apostrophes in the ... The help says it was designed to be consistant with Windows. ...
    (microsoft.public.excel.programming)
  • Re: Sorting Datagrid With Hyphen / Dash
    ... Regardless of the ASCII value of the hyphen, this sort order is WRONG, all ... the '30-' codes should be together, and all the '303' codes should be ... > underscore(_) character and do comparison. ... > If you change the hyphens to underscore, then you will need to revert ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Collating sequence / sort
    ... Apostrophes and hyphens are ignored, with one exception: ... Maybe you can change the hypen to a different character, do the sort and then ... Dave Mills wrote: ...
    (microsoft.public.excel)
  • Re: Hyphens in Excel Sort
    ... I don't really know where Windows provides for sorting other than ... How about making a helper column and sort on it. ... >>> Does anyone know why Microsoft would ignore hyphens and apostrophes in the ...
    (microsoft.public.excel.programming)
  • Re: "-" ignored in sort
    ... Apostrophes and hyphens are ignored, with one exception: ... > as a sort using column B plus column C. ... > vlookup is considering a sorted array in the same way that SORT is. ...
    (microsoft.public.excel.misc)