?_gdKWNlĮ/:1Help for McXtract, multi-columns file extraction/&;)z4 FRP   |CONTEXT5C|CTXOMAPf2|FONT<1|KWBTREE2|KWDATAq2|KWMAP2|SYSTEM|TOPIC|TTLBTREE;KIJ0001:0002: 3E9: FFFF: 2DA 0001:0003: 589: FFFF: 3E8 0001:0004: 18B6: FFFF: 86B6 0001:0005: 1B6D: FFFF: 88C1 0001:0005: 2302: FFFF: 10253 0001:0006: 28AC: FFFF: 1070D 2aKIJg77! aKIJg77!8H [WINDOWS]2aKIJg77! 8%62aKIJg77! aKIJg77!8%62aKIgJOg7aKXKOj7KI7JbrLKIe^[KI8 Fichier projet (HPJ)|*.hpjJpcJ rLKI7JpcJ lmeRKIJKIeIKI~KI7JbrLKI,5<,16KI8:D5Impossc:\windows\TEMP\~hc100001:0002: 3E9: FFFF: 2DA 0001:0003: 589: FFFF: 3E8 0001:0004: 18B6: FFFF: 86B6 0001:0005: 1B6D: FFFF: 88C1 0001:0005: 2302: FFFF: 10253 0001:0006: 28AC: FFFF: 1070D 070D 5I7JpcJrL5I7JpcJrL5I7JpcJrLKI55I7 9JpcJrL5I**m95I7 9JpcJrLI7JpcJr,, 6B1BqIndex/ q& IndexBt] M5ixFq0iy»Multi-column text conversion32 bit release 3.0, CR 1996-2000 Pierre GEEVERSOverviewUtilityHow to proceedTrial version limitsThis program is a ShareWare: you can use and copy it (see the necessary files). But if you appreciate it and want to use it evenly, you can get your own registered release for a cheap sum from:M Pierre GEEVERS103, rue grande77140 MONCOURTCompuserve ID: 101705,2301\+q1 0WYE-Mail pierregeevers@compuserve.comHome page http://ourworld.compuserve.com/homepages/PierreGeeversSee also the the registration form.You can have an eye on:Home page http://ourworld.compuserve.com/homepages/PierreGeevers/mcx.htmBy connecting on this page, you can register via Internet@t1XIpNecessary files9I& &Necessary files'p, &McXtract works under WINDOWS 95, WINDOWS 98, WINDOWS 2000 and WINDOWS NT.(A 16-bits release exists for WINDOWS 3.x)The necessary files are following:MCX32.EXE (program)MCX32.HLP (this help file)See also the examples and the file: README.TXT?I1HHow to process8p& $How to process2 2Welcome to McXtract, the multi-columns text file extraction!This program brings you a great help to take advantage from any text file for carrying out any of its data.The goal of McXtract is simple: it is to divide the text file into appropriate columns to give it back its significant fields.The result is given in a new text file: each field is separated by a character, in the shareware version, it is a semicolon (;), this character can be chosen in the registered version.<= N j  For example, you have:SMITH 33New YorkJONES 26LondonMARTINS 37SeattleYou can get:Name;Age;LocationSMITH ;33;New YorkJONES ;26;LondonMARTINS ;37;SeattleSo this result file can be used by any database or worksheet manager: any of those programs can import a text-delimited file and save it to its suitable type.How to proceedOpen McXtractNormally, it is set by default with the [General data window], if not, go to the menu Window/General dataV = H3Select the input file (i.e. the text data file you want to extract all of part of fields), by typing its name (path and file name) or by going to the menu FILE/INPUT (short key is Ctrl-F12).Example: DATA.TXTThen the fields separator can be changed (registered version only), for example to a , which is very useful to export the result directly by copy/paste to a worksheet.Then it is time to choose the fields definition:- by opening a field definition file (example DATA.TAB) with the menu Fields definition/Recall+= @ N- or by making directly this definition with the menu Fields definition /Define (then the program goes to the [Fields definition] windowSo the fields definition can be saved (menu Field definition / Save as): please notice that those files have the .TAB extensionFor helping to define field, you can have a view on the input file (menu Window/Input file)It is also possible to get automatically a view of both input file and delimiter (menu: Window /Both input and delimiter).V AC T'    In the input file view window, a rule can be inserted or remove as wanted; this rule is displayed on each 24 lines in that window: it looks like this:---------------------------------- (rule) 1 2 3 -> col. number, by 10x1 Ap234567890123456789012345678901234 -> col. number, by unit----------------------------------This rule is a great help to find precisely the positions of the fields to be extracted.The rule display is made for help and no element of the rule appear in the output file.1C0 .Please notice that on the trial version, the rule length is limited to 60 characters.Then you can return to the [General data] (menu Window/General data) if you wish to improve the extraction. Some additional features are proposed:- extract only a sample with the number of desired lines, in order to make tests before preparing big extractions- choose to display field names ahead - sort the extraction- obtain unique (not duplicates) records (registered version only).0 AaE/ ,- Give a rank number (registered version only)- Give a lower and an upper (registered version only) limit to the extracted values, which is useful for files containing blank lines for example.After that work, the extraction can be launched (menu File/Go). A message tells when extraction is finished, then the result is immediately displayed.Please notice that the extraction file has the .XTR extension.The zone in the result view can be selected and copied to be pasted, fore example into a worksheet. 1CmG- (You sure can make another process with a new input or output file as the fields definition is still in memory.A previous job log can be displayed: it helps to follow precisely what jobs were run by McXtract, each new job is inserted at the first line of the log, so it is reversed sorted by date/time. This log is saved into the MCX32.LOG file. Each row contains: - input file name - delimiter file name - output file name - delimiter - sorted or not - unique or not0aEH; DY - line number or not - Lower limit - Upper limit - Job date - Job timeTo exit from McXtract, just choose on the menu FILE/.EXIT.Thank you for using McXtract; if you have to use this program evenly, do not forget to register...8mGH1HITKUtility1 HI& UtilityHK* "What is McXtract made for?Imagine you have one or more text file in which you want to extract some fields for an analysis, or you want to extract just a column to make a copy/paste into another program...McXtract makes that possible: this program can cut a text file into selected fields and is able to prepare the importation work into a database or a worksheet manager.Then you will find it very useful, especially if you have to extract the same fields from multiple files.?ITK$ 6So welcome to McXtract!BKK1=SKKRegistration form;TKK& *Registration form/KNA P Registration FormPlease send this form with a money order to the following addressMr Pierre GEEVERS103, rue grande77140 MONCOURT-FROMONVILLEE-Mail pierregeevers@compuserve.comHome page http://ourworld.compuserve.com/homepages/PierreGeeversPlease choose your currency[ ] US$[ ] Euro[ ] French FrancMCXTRACT personal licence ____ x [ ]US$ 26.00 ______ x [ ]Euro 26.00 ______ x [ ]FRF 170.00 ______,K8F Z  Shipping [ ]$ 1.00 ______ [ ]Euro 1.00 ______ [ ]FRF 6.50 ______Total: [ ]$ [ ]Euro [ ]FRF ______Disk size:[ ] 3 1/2 [ ] 5 1/4 [ ] does not matter[ ] Name_________________________________________[ ] Company_________________________________________Address (please mention it as clear as possible)N8TK_________________________________________NU7 < _________________________________________ _________________________________________ _________________________________________ _________________________________________Country_________________________________________EMail __________________________________________Which release do you own? _____How did you get McXtract?__________________________________________________________________________________m8' Date ________Signature _________________________________You can of course mention all your comments...9U"1p "TOverview2 T& Overview"b9 @The McXtract is composed with several windows:- The [General data] is where are displayed the input/output/delimiter files, and where the field separator and other features are chosen, in order to improve the extraction- The [Fields definition] is where the fields for extraction are defined- The [View input file] (only active where an input file is chosen) is where the input file can be displayed, in order to help for choosing the fields for extraction.T3 4- [The result] (only active when extraction has run) is where the output result file is displayed, in order to allow an immediate control.- The [Previous jobs] is the log trace of all what has been done by McXtract. This log is saved to the MCX32.LOG file. The lines are reversed sorted by the job date/time, ie the last job is displayed on the first line.To retrieve the desired window, it is just necessary to chose Window on the menu.The active window name is displayed on the main program bar (or highlighted if this window is not maximized). If you get lost, just click on the menu Window and chose the place you want to go.Zb% You can have an eye on:http://ourworld.compuserve.com/homepages/PierreGeevers/mcx.htmE؈12S؈Trial version limits>& 0Trial version limits؈8 >5ixMcXtract is a shareware program, it is downloadable as a trial version. So there are some differences with the registered version.They are listed below, located by differents windows available in the program.General data - field separator is only a semicolon (";") - No unique records - No adding line number to the output file lines - No upper limitView input file - Rule length limited to 60 charactersThe result - No 'select all' - No copy+ $Previous jobs (log) - Registration reminding line added - No editing - No 'select all' - No copySo there are some advantages to register... And by registering, you give to the product its good luck!1H1UHl$l"  1H1*! HelvMS Sans SerifMS SerifCourierArialTimes New RomanCourier NewSymbol  ULS /&;)i24LISEZMOI pouBut what for??CopyingExtractionFee FormIndexInstallMCXTRACTOrder Presentation, Overview$Proceeding(Process,Purpose0Register4Registration form8Sharaware<Trial, Shareware, Limits@UsingDUtilityH Sharaware 88C1 Presentation, Overview 10253 Trial, Shareware, Limits 1070D , Limits 1070D 0001:0005: 1B6D: FFFF: 88C1 0001:0005: 2302: FFFF: 10253 0001:0006: 28AC: FFFF: 1070D 070D 5I7EIndex 0 Proceeding 2DA Install 2DA MCXTRACT 2DA Copying 2DA Using 3E8 Process 3E8 Extraction 3E8 Purpose 86B6 Utility 86B6 But what for?? 86B6 Order 88C1 Register 88C1 Form 88C1 Registration form 88C1 Fee 88C1 Sharaware 88C1 #Presentation, Overview 10253 %Trial, Shareware, Limits 1070D :0002: 3E9: FFFF: 2DA (0001:0003: 589: FFFF: 3E8 (0001:0004: 18B6: FFFF: 86B6 (0001:0005: 1B6D: FFFF: 88C1 (0001:0005: 2302: FFFF: 10253 (0001:0006: 28AC: FFFF: 1070D de 16 rubdKIJZcJ L7@P8/\KI,\)>J:O55IJZcJ L/^5I48 JbrL5I~5I(KWO,\ >iOO5Ig,\M>cJOg7aKXKOj7KI>,\*0945I,\M>c:\windows\TEMP\~hc23>g,c:\windows\TEMP\~hc23Oj7$Impossible de crer un nouveau texte4882ProblmeRKIJHKIe^[KI48 JbrLKIgJOg77aKxXKOj7KI7JbrLKIe^[KI,/KI428=585I~5I42S/5I428=954I  Lec:\windows\TEMP\~hc23 n'existe pasG=488 DsolRIJ*5I5KI5KI/&;)Lzvvv v v u IndexNecessary filesHow to processUtilityRegistration formSOverview Trial version limits  ;؋FVFVFFFFVFVFFF\NUISIBILITIES\MMEDIA\PLAYER\REALPLAY.EXE(~ϟ~C:\PROGRAM FILES\WHEEL MOUSE\3DMAIN.EXE(#N~ϟ~C:\WINDOWS\RunDLL.exe(G^~ϟ~C:\PROGRAM FILES\DR SOLOMON'S\ANTI-VIRUS TOOLKIT\TK_SCHEN.EXE(Wp~ϟ~C:\PROGRAM FILES\DELRINA\DELFAX\WFXSND32.EXE(;~ϟ~C:\WINDOWS\MENU DMARRER\PROGRAMMES\DMARRAGE\DESKMENU.EXE(OT~춑ܶROGRAM F 춑ROSOFT OFICE\FIN, E</&;)L4\<»[,YF5ixSq0iy $12XSSPanel# <; Bienvenue dans AidEdit MS Sans SerifASSRibbon<hJ~BM~v(wwwwwwwwwwxwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwx~BM~v(wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwx~BM~v(xwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwxwwwwwwwwxww<2OK^  QBAideSWPanel3D1Panel3D3 Etiquette3 Etiquette4 Etiquette5Panel3D2Dessin1OKL"KIgJaK|XKj7KIe^[KI7J(rLKIe^[KInJ, L uL"KIgJaK|XKj7KIe^[6ܶ ̆춑̶ ̄ܶ"̊ 춑,`B, t̮<r̬L,b̜\<DlL&̈|\.̎Ȍl0PȜ|2RȬȌ4TȼȜ6H̷Ȭ fܷȼ d췑̷bܷF 췑`̚