There is also the danger in a PreStore where you go to field 30 to make your change, but the record(s) in question does not have that many field. It instead goes to the last field and execute the change. This can be disastrous! Be careful!
JRI -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, May 28, 2013 3:54 PM To: U2 Users List Subject: Re: [U2] UniData PreStore to change the KEY of a record? And if you go that route, I have used Excel a number of times for this type of thing. I use formulas to replicate what a user would type and then paste into either TCL or ED. It takes a little time to work out the details, but once you have it, you can reuse pretty easily. As someone noted earlier, the rub comes in ensuring you don't overwrite an existing record. Assuming you've done that, this might get you started. Bad Good Command A B ED FILE A SV B FD Y Where command is this Excel formula: ="ED FILE "&A2&CHAR(10)&"SV "&B2&CHAR(10)&" FD"&CHAR(10)&"Y"&CHAR(10) Depending on which version of Excel you have, it may include the leading " when you paste. If so, paste into Notepad or Word and remove the leading " HTH, Brad. From: Wjhonson <[email protected]> To: [email protected], Date: 05/28/2013 02:42 PM Subject: Re: [U2] UniData PreStore to change the KEY of a record? Sent by: [email protected] I do not think you can Prestore a replacement command to operate on the KEY (attribute zero) I would suggest giving the task to an expert user and teaching said user how to look at the Key, mentally replace bad with good and then SAVE GOOD1234, followed by FD -----Original Message----- From: David Wolverton <[email protected]> To: 'U2 Users List' <[email protected]> Sent: Tue, May 28, 2013 10:48 am Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users U.S. BANCORP made the following annotations --------------------------------------------------------------------- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. --------------------------------------------------------------------- _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
