Article View: bit.listserv.wp50-l
Article #308Sort and hyphens
From: David Lesher
Date: Sun, 12 Jan 1992 23:05
Date: Sun, 12 Jan 1992 23:05
33 lines
2175 bytes
2175 bytes
I have a table with data like this: XRT/TY-91-161 XRT/TY-91-162 XRT/TY-90-47 I need to sort by both the year and serial number. According to TFM: space, forward slash, and hyphens act as word separators in a sort. Well, I spent quite a bit of time on the phone with Utah, and I'm not sure this is true. WPF has two different characters that appear on the text screen as the "-" character. The first is a hyphen, generated by the key between the = and the 9. The other is what you get when you hit HOME - and it is called hard hyphen. The h.h. does NOT allow WordPerfect to split the word; rather it is treated the same as a through z. [Hope I don't have this inverted...] But the manual and experience don't seem to agree. After futzing around, reading the sort and Appendix C of the manual, (that's the part that shows you how characters show up under reveal codes) I called for help. Well, after HE had the same problems I did, he agreed: WPF did not treat it as a separator, and thus I could not sort on the words. He's writing it up. I solved MY problem. I wimped out, decided that slashes looked just fine, and used a Replace. XRT/TY/91/162 sorts just fine now, thank you. -- A host is a host from coast to coast.....wb8foz@mthvax.cs.miami.edu & no one will talk to a host that's close.......................... Unless the host (that isn't close).........................pob 1433 is busy, hung or dead....................................20915-1433
Technical Details
Message-ID:
<kn1id0INNa2q@mthvax.cs.miami.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!paladin.american.edu!darwin.sura.net!wupost!mthvax.cs.miami.edu!newsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 100789,6dfa8d343e3e6701,start X-Google-Attributes: gid100789,public X-Google-ArrivalTime: 1992-01-12 15:47:21 PST Path: arc1-ca.pugleaf.net!sparky!uunet!paladin.american.edu!darwin.sura.net!wupost!mthvax.cs.miami.edu!news From: wb8foz@mthvax.cs.miami.edu (David Lesher) Newsgroups: bit.listserv.wp50-l Subject: Sort and hyphens Date: 12 Jan 1992 18:05:04 -0500 Organization: NRK Clinic for habitual NetNews Abusers - Beltway Annex Lines: 33 Distribution: na Message-ID: <kn1id0INNa2q@mthvax.cs.miami.edu> Reply-To: wb8foz@mthvax.cs.miami.edu (David Lesher) NNTP-Posting-Host: mthvax.cs.miami.edu Summary: minor problem ;_]