In my old application I could define a field as INVERTED:
My A5 application Imports from external TEXT files (over which I have no control) that only have a Fullname field:
Paul J Kosko,Jr
The Key or index would then sort by:
Kosko,Jr Paul J
If I opened on the index, the order would be:
ROBERT M BANKSTER
PAUL J KOSKO
ALLEN A MCMANN
If you did a search you would enter Kosko instead of Paul J Kosko,Jr
Also, the user prints File Folder Labels where they want the first 4 of the Last Name:
K
O
S
K
on the edge of the label in BIG letters so it's easy to find a name in the vertical folder storage, where there are 1000's of folders.
So, I have to have a Last Name isolated to do this.
There are many exceptions to this "invert" :
Ex:
AMERICAN INSULATION INC. (I'd want (AMER). I don't want INC
THE DOROTHY WEST GROUP LLC (I'd want WEST). I don't want LLC or GROUP or THE. ie WEST GROUP LLC THE DOROTHY. or
at least DOROTHY WEST GROUP LLC THE
The invert type field took care of 85%. The 15% where inverted key/index sort would create a mess as above, I had to write a yarnball UDF to test if the name indicated a Company or Title or Both, and no adjectives at the beginning and ignore titles at the end: LLC INC CO CO. DDS PHD. N.A. III etc. Even then some would slip through.
I've searched the archives for "invert" and nothing relates that I found.
Any Ideas?
Field type: Inverted Alpha Numeric Counter Date Time
Paul J Kosko,Jr
The Key or index would then sort by:
Kosko,Jr Paul J
If I opened on the index, the order would be:
ROBERT M BANKSTER
PAUL J KOSKO
ALLEN A MCMANN
If you did a search you would enter Kosko instead of Paul J Kosko,Jr
Also, the user prints File Folder Labels where they want the first 4 of the Last Name:
K
O
S
K
on the edge of the label in BIG letters so it's easy to find a name in the vertical folder storage, where there are 1000's of folders.
So, I have to have a Last Name isolated to do this.
There are many exceptions to this "invert" :
Ex:
AMERICAN INSULATION INC. (I'd want (AMER). I don't want INC
THE DOROTHY WEST GROUP LLC (I'd want WEST). I don't want LLC or GROUP or THE. ie WEST GROUP LLC THE DOROTHY. or
at least DOROTHY WEST GROUP LLC THE
The invert type field took care of 85%. The 15% where inverted key/index sort would create a mess as above, I had to write a yarnball UDF to test if the name indicated a Company or Title or Both, and no adjectives at the beginning and ignore titles at the end: LLC INC CO CO. DDS PHD. N.A. III etc. Even then some would slip through.
I've searched the archives for "invert" and nothing relates that I found.
Any Ideas?
Comment