Quite. Less lines than the original post.
----------------------------- Epicor Software (UK) is a limited company registered in England & Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. ----------------------------- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mecki Foerthmann Sent: 29 May 2013 08:25 To: U2 Users List Subject: Re: [U2] UniData PreStore to change the KEY of a record? To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: > Dang, David, you beat me to it. ;^) I was just going to suggest the > same thing. Just because the OP wanted to use ED (a hammer) to drive > in a screw doesn't mean that it is the best tool ( a screwdriver). > Good answer. > > Charlie Noah > > On 05-28-2013 3:42 PM, David A. Green wrote: >> I would take my saved list and copy it to a text editor then using >> copy commands and a quick macro convert the list into a bunch of COPY >> FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and >> then execute it. >> >> David A. Green >> (480) 813-1725 >> DAG Consulting >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of David >> Wolverton >> Sent: Tuesday, May 28, 2013 10:48 AM >> To: 'U2 Users List' >> 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 >> > > _______________________________________________ > 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== to report this email as spam. This message has been scanned for malware by Websense. www.websense.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
