List Postings

[Kenneth Brody]

Quoting Nancy Palmquist <nlp at vss3.com>:
[...]
> filePro TIP EDIT to change phone number into just numbers (machine form)
>   unphone: {!"-"!|!"("!|!")"!|!" "!|*}

I think that one definitely qualifies for "put spaces in there for the
humans to be able to read it".  :-)

   unphone: { !"-"! | !"("! | !")"! | !" "! | * }

Here's one I use:

   phonex: ( <"("> N N N <")">[!-!]<" "> N N N <"-"> N N N N
           | <"(914) "> N N N <"-"> N N N N )

This converts "nnn-nnn-nnnn" to "(nnn) nnn-nnnn", when importing from
other sources.  It also adds my area code 914 to numbers without any
area code.

I also have:

   getfone:^ { ( N N N "-" N N N "-" N N N N ) | killit }
   killit:killit1 | killit2 | killit3 | killit4
   killit1:!A! | !B! | !C! | !D! | !E! | !F! | !G! | !H! | !I! | !J!
           | !K! | !L!
   killit2:!M! | !N! | !O! | !P! | !Q! | !R! | !S! | !T! | !U! | !V!
           | !W! | !X!
   killit3:!Y! | !Z! | !0! | !1! | !2! | !3! | !4! | !5! | !6! | !7!
           | !8! | !9!
   killit4:!" "! | !"-"! | !"'"! | !"."! | !"/"! | !"&"! | !"*"! | !","!

This strips extra information from "nnn-nnn-nnnn" phone numbers on import.
For example, I need to import fields which have the phone number somewhere
in the middle of the field, such as:

    FOO123 914-555-1234 Foo Main Street Office

Finally, an edit to compress multiple spaces down to one:

    no2spc:{ " "[{!" "!}] | * }

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com