LEFTIFY - first incarnation of "sweep" Script searches through all filepro files for occurances of a field type you specify, and performs a Left-Justify on that field in all records of all files containing that field. Example, lets you left-justify all customer numbers, even though there are already many documents and records containing customer numbers because it finds every occurance of a customer number and performs the same edit on all of them, thus references remain intact I recommend using the TEST-RUN feature several times and examining the log files and honing the selection parameters before actually RUNning a job. THIS SCRIPT IS DANGEROUS - Test often, Run once, Cry least. :) This is the very very beginning of a set of tools or a single, general purpose tool I intend to develop for performing other sweeping manipulations such as this. Next will probably be: DOEDIT (perform any filepro edit) What a tool like this enables you to do, basically, is change your mind about decisions that were made way back when you first started creating data, even from previous systems and several migrations ago, by updating all the history to match your current wishes. After finding myself using leftify test-runs purely for it's reporting ability, I formed an idea to make another branch of 'sweep' that just does that. gathers reports about the layout and structure of your application. You could use this to find inconsistancies in your application easily. "are ALL the fields that hold dates updated to the new y2k compatible length?" "is this field even referenced from any other file or processing table?" "do any of my files have record lengths over 1024 bytes?" "is this phone number or this part number that I don't seem to recognise, maybe buried somewhere in a notes or comment field anywhere in the system?" "better yet, Find me any and all phone numbers, look in all fields that are large enough, excluding those that are already known to contain phone numbers (phone edit), in all files on the system." WARNINGS/NOTES/TODO Doesn't automatically recognise and deal appropriately with ascossiated fields yet. IE: if your search for "category" you'll find "category" fields scattered around in various files, but if a file has a set of asossciated fields which are all "category" fields, but only the first one has "I1) category" in it's label, while all the others have just "I1)" then by rights, those particular "I1)" fields should be included it the selection set. you have to look at the log files and take care of these by doing another leftify run, using "I1)", the field size and the field edit as selection parameters, and hope that you don't have other files with fields matching all of those exactly, yet not containing the same data. Doesn't parse map files for alien files correctly, do not allow leftify to if a non-filepro file shows up in the test-run sweep - sweeps through file pro directory performing some action based on prc2ascii usage: place in /usr/appl/fp, then add this entry to the menu "util": 11 ---------------------------------------------------------------------------- Só Sweep ó /fp/leftify ó perform an action on all filepro files (currently only Left-Justify) ó Brian K. White - linut@squonk.net -- Brian K. White http://www.squonk.net/users/linut +++++[>+++[>+++++>+++++++<<-]<-]>>+.>.+++++.+++++++.-.[>+<---]>++. filePro BBx Linux SCO Prosper/FACTS AutoCAD callahans Satriani