Bryan Thorell
Brutzman, Bill wrote:
Following the comments from Susan and Dave, the following worked...
SELECT PS WITH @ID < 1
2 records selected...
DELETE PS
Thanks...
--Bill
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Susan Lynch Sent: Friday, February 06, 2004 6:51 PM To: U2 Users Discussion List Subject: Re: InValid Characters
Bill,
Not sure whether you are on UV or UD, so I will avoid using the EDIT-LIST command (which UD does not have). Given that restriction, probably the easiest method would be to
SELECT PS = "[101393" BY-DSND @ID (assuming that @id is left-justified)
If only 1 item selected, DELETE PS
If more than 1 item selected, SELECT PS SAMPLE 1, then LIST PS to be sure that the one selected is the one with the unusual characters in the key.
If yes, then repeat the two SELECTs and DELETE PS. If no, then your system is sorting unprintable characters differently than mine is, and you will have to play with the selection process in order to get the right record selected prior to deleting it.
Susan M. Lynch F.W. Davison & Company, Inc.
----- Original Message ----- From: "Brutzman, Bill" <[EMAIL PROTECTED]> To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]> Sent: Friday, February 06, 2004 5:49 PM Subject: InValid Characters
When I issue the following LIST command, there is are apparent bad characters, ascii box drawing characters.
How can I clear them ? The two characters show up a single "box" below.
Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit Up-Arrow mode, or UV.VI.
I tried the ascii equivalents of the box characters per...
>DELETE PS ^210^201 Record ID "^210^201" not found. 0 records DELETEd.
>DELETE PS ^210 Record ID "^210" not found. The records for @ID 103662 and 101393 appear to be clean.
>DELETE PS ^D2 Record ID "^D2" not found. 0 records DELETEd.
>DELETE PS ^D2^C9 Record ID "^D2^C9" not found. 0 records DELETEd.
Suggestions would be appreciated.
--Bill
-----------------------------------------------------------------------
LIST PS
D.PS......
103662 101393 101312
--------------------------------------------------------------------
D.PS............. 103662 NEXT.COMP.PN..... PREV.COMP.PN..... 103661 QTY.PER.ASSY..... TYPE............. SCRAP.FACTOR..... LEAD.TIME.OFFSET. OPERATION........ EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID....... DATE.ADDED....... NWU.PN........... PWU.PN........... BALŭNBR.......... REFERENCEŭDESIGNATORS. NOTEŭREFERENCE... ECO DATE.........
D.PS............. NEXT.COMP.PN..... PREV.COMP.PN..... QTY.PER.ASSY..... TYPE............. SCRAP.FACTOR..... LEAD.TIME.OFFSET. OPERATION........ EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID....... DATE.ADDED....... NWU.PN........... PWU.PN........... BALŭNBR.......... REFERENCEŭDESIGNATORS. NOTEŭREFERENCE... ECO DATE.........
D.PS............. 101393 NEXT.COMP.PN..... PREV.COMP.PN..... 103626 QTY.PER.ASSY..... TYPE............. SCRAP.FACTOR..... LEAD.TIME.OFFSET. OPERATION........ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users