Home

StyleList Reference Guide

1. GeNETWORKS femos l xod Bem T moo jJ gp Y soles ois 1 T BOO COMPANY a00 compes T BOSHOPPING CY _ aDshoppingcomf B M srcEMERGv BrECEew T m 58 TECHNOLUG B Technologies Append Goto Locate Print Cleanup T d OK X Cancel Help Structure of the Company Table SLCo dbf Len Field Type LOOKUP Character ABBREV Character CASETO Character EXPAND Character INSIG Character INTENSE Character Editing 24 10 24 32 1 1 Tools Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter AQ Style List Users Guide Tools Lookup Tables 4 Letter non Company Table This utility allows you to explore edit append new records and delete records in StyleLists Words Table Delete Append Goto Locate Print Cleanup X Cancel Help This table holds words which we believe as less likely to be company acronyms e g XYZ Co The list was compiled by combining the following sources
2. Part of File RecwdRange From ho o Fa Express Bus wie Espresso Buiter Help Help not available for this prompl x Cancel 7 Hslp Method of Splitting Split into n Records Bytes or Files Split the file so that the resultant files are no larger than the specified size Select every lt n gt th record from file Split the file so that every nth record is taken often known as an nth select Randomly select n records from file Randomly select a specified number of records from the file Base split on the contents of a field Use a source field to determine to which resultant file a record should be deposited Commonly used for undoing a Merge P urge or dividing a file up by ZIP Code or SCF oplit into n Records Bytes or Files Make files having no more than n records each Each output file will have the specified number of records Make files with no larger than n bytes each Each output file will be no more than the specified number of bytes Make exactly n files Records will be evenly divided into the specified number of files 32 Tools Select every lt n gt th record from file Take every lt n gt th record from the file Specify the gap between each record selection For example 4 will select every fourth record or 25 of the file Randomly select lt n gt records from the file Randomly select n records from the file Specify how many records to be selected
3. So that you can see at a glance how you have chosen to treat a field the field name will be highlighted with one of the following colors Green Expand Orange Abbreviate Yellow Neither Style List Users Guide File New Setup Field Type Field Type Pretix C Fist Neme gt ast Name Om Suffix Y Full Name E nveerse N ame Gov t Inverse F Dspartment Title Company Slreet Address C Ciy fory f Slate only amp Zip onp PM Ck Step Phone E Mail address Gsneral Custom File Each time you select a field to convert you need to tell StyleList what kind of field this is Choose the Field Type most appropriate for the current field For example if you pick a field holding last names select Last Name in the Field Type column To save you time StyleList always tries to guess the correct Field Type based on the field name and highlights its best guess For example StyleList will default to Address if the field s name starts with ADD or STR If StyleList doesn t pick correctly click the radio button next to the Field Type which best describes this field s data To change StyleList s Field Type determination abilities see Tools User Settings Default Field Names Once a Field Type has been selected options on the far right are activated What each Field Type can contain Prefix Prefixes only First Name First names that can include prefixes and middle names
4. Base split on the contents of a field Split on field Specify the field whose contents will determine to which file a record should be stored Use first n characters of field How many characters of the specified field should be used to determine the split i e to split on full ZIP enter a 5 for an SCF enter a 3 Output Files Ask me each time Each time a file name is needed you will be prompted Use the contents of the field to name the output files The file name will be derived from the contents of the split field Assign each file a number put them here Each file will get a sequential number and they will all be deposited in the specified directory Record Range All Process all of the records in the database Part of File Process only certain records e Record Range Process only the records between the from and to range given To process from a specific record to the end of a file specify 0 as the to record e For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder e While Records are recalled until the while expression is no longer true Using a while expression do
5. Scroll Record Range f l E Dart of Vile Recad Range Fari 1 ta Ja Fikes Express Buiter sd OF X Cancel 7 Halp Processing Options StyleList Operations Slike List C peialiur iz ADDRESS Coss Ony SUITE Coss Ony oTr Cass Ony Check Hon Select which fields you want to process Check All will select all fields in your currently active setup and Check None will remove all check marks Processing Screen Processing Options Processing O paliar Exdinas cil M Backup Data End in ASCII Pro Series only Check this option if you want the dBASE file converted to ASCII after processing available only if you started in ASCII Style List Users Guide Backup Check this option if you want to backup your database before processing It would be prudent to always backup data before processing Processing Screen Display Mode Display Moe Maximum Speer Scroll Display Mode How do you want your data displayed during processing Maximum Speed Processes the file as fast as possible Scroll Displays each record as it is processed Processing Options Record Range Revud Farge a Part of File Reced Range Fri Tw jo Fika Expression Bien Record Range You may choose to process all or part of the file You can also choose to seta filter condition All Process all records Part of File Process only certain records e Record Range Only p
6. Style List Users Guide Tools Lookup Tables Email Domain Table This utility allows you to explore edit append new records and delete records in StyleList s EMailTable MM Editing EMail Domain Lookup Table Record 1 of 7 B xj a aaa sa LL mes T s PC econ EME Roma mates pane T MEDIADNE eden PEOPLE petete vanoo 1 taco Y Delete Append Goto Locate Pririt Cleanup X Cancel Help This table holds common domain names found in email addresses otructure of the Email Domain Table SLEMail dbf Field Type Len LOOKUP Character 20 CASUAL Character 20 AGGRESS Character 20 CASETO Character 20 EXPAND Character 20 INSIG Character 1 Editing Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter Tools Lookup Tables Custom Table This utility allows you to explore edit append new records and delete records in a StyleList custom Table StyleList allows you to make custom tables Why would you do this Think of StyleList as an incredibly fast and versatile Search and Replace engine For example you could use a custom table to rep
7. and For example Melissa Data Melissa Data and Melissa Data all specify the same character literal You cannot embed the delimiters For example MacDonald s is not valid so use one of the other delimiters like MacDonald s Date Literals Delimit with curly braces and and use the format mm dd yy For example 8 10 68 represents March 10 1968 In the old days there was no such thing as a date literal and people usually specified them by converting a character literal for example CToD 3 10 68 Numeric Literals There are no delimiters just specify the number For example 3 14 is a numeric literal Logical Literals There s only two so they re special T for True and F for False Yes those periods are required opecifying Functions Functions are fairly simple Type the function s name a left parenthesis any parameters separated by commas and a right parenthesis If you nest functions be sure that you consistently match parenthesis Following the dBASE tradition casing is not significant and only the first four letters of a function s name are needed so ALLT SUBS NAME 5 4 AllTrim S ubStr Name 5 4 are identical Limited Warranty Melissa Data warrants that the Software will perform substantially in accordance with Melissa Data s current published specifications documentation and authorized advertising that the User Manual contains the necessary information to utilize the Software
8. or unmark a record for deletion either select File Control Toggle Delete or hit CTRL T Records marked for deletion can be permanently removed by packing Menu Commands e File Control Perform file wide operations on a database e Column Add remove or change columns e Options Customize your browse tool to your liking Tools Browse File Control e XA Is Jr ier d 21218 ttal e Set Filter Allows you to view records that meet certain criteria Delete Records Mark records meeting specified criteria for deletion Recall Records Remove deletion marks from the records meeting specified criteria New Record Add a new empty record at the end of the database Go to Record Proceed to a particular record number Locate Record Locate a record fitting specified search criteria Locate Again Locate the next record fitting the previously specified search criteria Copy Records Copy records fitting specified criteria to a new file Append Records Add records from another database to your current database Sort Records Sort the database by a specified sort expression Replace With Replace the contents of a field with a specified expression Count Records Count the number of records meeting specified criteria Print Records Print the records meeting specified criteria Pack Database Physically and permanently remove deleted records Concatenate Fields oin up to twelve fields together Split File S plit file in a variety of ways Se
9. Even word Endir y The blue highlight shows the current record Red indicates the text that would be truncated by StyleList Style List Users Guide Next Mac StyleList will highlight the next Mac name justto make sure there isn t one we missed in the Last Name Table Next Truncation StyleList will highlight the next record that will lose data when you modify the file structure to the length you specified in the Setup Since your structure hasn t been modified yet this is your chance to edit these fields before you shorten them In addition to manual editing you can use StyleLists six methods of automated abbreviation See File New Setup Abbreviation Options Next Either StyleList will highlight the next Mac name or truncation depending on which is first 18 Tools Tools Browse The Browse tool allows you to view and modify the main database s contents Each row of the table represents one record File Control Column Options Help e Mlle DIA mei 21 3 ce EJ sTETET Sdi Sharon Amitty Boworly 0 jidamo LSS Boaoh Lagoon Rd 1387 Yellow Brick Rd Dan Browse Keys LEFT RIGHT CTRL LEFT CTRL RIGHT HOME END UP DOWN CTRL UP CTRL DOWN CTRL HOME CTRL END PAGEUP PAGEDOWN Fender 7803 Phillips Hill Bd _ 6117 Bush Ave Hrmbkmyn Uilmn 9573 Hahernakhy Gay Bishop 1186 Beer Run Move highlight left right one field Pan window left right one f
10. Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax can use the Expression Builder 27 Tools Tools Browse File Control Recall Records HEN IIA Record Range FP Pat of File Reced Range Fia 1 in fo Fe Exwesn e Bud thie Expression Buia x Cancel 7 Halp Removes deletion marks from records meeting specified criteria Applies only to dBASE files All Remove deletion marks from all of the records in the database Part of File Recall only certain records e Record Range Recall only the records between the from and to range given To recall from a specific record to the end of a file specify 0 as the to record e For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder e While Records are recalled until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder Tools Browse File Control New Record Adds a new empty record at t
11. Rec TRE Ioj xi LOOKUP AGGRE SEO P BUM mu AP Accounts Payab AR Accounts Receiy as T RE JAR AR AVR Assistant Vice P CADEMIC Acadre CCIDENT O pooo gt hd LA AA P a sls a X C mH I I IL IL I el I CCOUNT CCOUNTA CCOUNTA id ACCOUNTS Accts ACCOUNTS lact Pa Y ACCOUNTS fAcct Rec ACCREDITIQAcerdn doo oo d Append Goto Locate Print Cleanup T d OK X Cancel Help Structure of the Title Department Table SLDept dbf Field Type Len LOOKUP Character 24 ABBREV Character 24 CASETO Character 24 EXPAND Character 32 INSIG Character 1 INTENSE Character 1 Editing Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter 48 Tools Lookup Tables Company Table This utility allows you to explore edit append new records and delete records in StyleLists Company Table lli Editing Company Lookup Table Record 1 of 8278 A inue jussi cupio er ES B x ini x e Eo SO0ATTORNE eoar T Ten FLOWERS __ 800flowers conp
12. Records OPROn PORO O_O O o n 25 PAS CME XO OWE ao 40 AS GMI OO Fle ceci iet oa ias 39 B Batch a sooo easel ciate ebat C doe a hd 60 BOWS Csi sate cies tates Saree rund sspe elon eut To 19 BIOWSQ FODEs di sies aa meret pan ida on near Mass meet 38 BIOWSe O DUON Scania 37 C Change Column Display ari 36 Change Database ten i eoe ies et e a 14 City Wales e startet 52 COUN aaa aaa 36 Command Lie as 60 Company TapE ua ea 49 Contcatenate Fields edi sio 30 CODY ROeCOFS ainsaiy id 24 COUNE RC COGS d inira pte baden rad ean 28 CUSTOM AIO IG ostia tacuit ia 54 D BASE SYM X datae a e bnc cand el e a tants 64 Delete Records sivit optica decli erai Cet lod 22 D eiiih A oO E Lar maia Yd Rl Cs 42 E pl M PM 13 F FMS CONTO na E 20 File Requirements i iii caa aae aho sa ed raids 4 mag cT 6 Ello NON aras 6 A xr 42 G General User Settings ccccccccnnnoccccnnnncnnnnonaniccnnnnnnns 56 GOTO RECO t E 23 H Hide COMA sursang 36 l MECH AS CIL FIOS iaa 39 In aseo DIMCUILY rada 62 Interactive Importer eeeeeen 41 Field InfortmallOn usse cerni a vea nr 42 File informato innanti 42 OCU CHONG e E 1 L Last Name Prefix Table occccccccocccnnccnocccnncnnononons 46 Last Name Dabei eon teins curiae nord 47 E vestes cuts ebay aon A aS 24 Locate RECOU e nod 24 LOOKUP N Ezio i e P 43 44 M Modi S truces e RS 38 Modifying Lookup Tables outside SL 56 N NeW Recodo 23 New SEUD rini
13. The last name must be either in the Last Name or Full Name field Last Name Last names that can include suffixes and any titles that are included in the Suffix Lookup table First and middle names must be either in the First Name or Full Name fields Suffix Suffixes and titles only Full Name A full name in this order prefix first name middle name last name suffix Not all name parts are necessary Inverse Name An inverse name in this order last name suffix prefix if any first name middle name Not all name parts are necessary Gov t Inverse A gov t inverse name in this order last name prefix if any first name middle name suffix Not all name parts are necessary Prefixes are seldom present in this format Department Title Department names or people s titles only Don t use for company subsidiary names or continuation of the company field Company Companies only Street Address Street addresses only Field can t contain city state or ZIP information City only P ure city town fields If the field has states provinces and or zips use City State Zip State only Pure state province fields If the field has cities towns and or zips use City State Zip Zip only Pure ZIP and Postal code fields 9 digit ZIP 4 and or Postal codes will be reformatted in the manner you specify Also US ZIPS with less than 5 numbers i e because they were reformatted by Microsoft Excel are repaired If the field has cities towns a
14. a nonexclusive Interface Distributor and NCOA Full Service Provider DPV and LACS Licensee of the United States Postal Service The prices for NCOA and DPV services are not established controlled or approved by the United States Postal Service AD 4 07 Document number SLO108U Last Update J anuary 8 2008 MELISSA DATA CORPORATION 22382 Avenida Empresa Rancho Santa Margarita CA 92688 Phone 1 800 MELISSA 1 800 635 4772 Fax 949 589 5211 E mail info MelissaData com Internet www MelissaData com Table Of Contents o o A AE 1 WES Ir Un ERR 2 SISTE REQUIEM Sai NA 3 FIS Requena A 4 An i 5 FI Oeo E T ULT 5 mimm T 6 IE Viewer Preto Ma ON racista initial di 6 Fl New SCU Did sides 7 ME NES StU RE Ga EM 7 CH News C Up Pela TDS dado 8 gia secu OPIO TT 9 Fed News eub ADDEeVISUOL ODUOFS denda Ra Ret ERR adios 9 Ee NewS cup PUR cua ton O PIONS eta ideada lic od 10 Fe NeweS culo i Make Use Deal Raras tonto v a Ex 11 Files NeW S Ctup restinga ellos acia rd ads 11 PIE ODE Cela idad ais 12 AA e I THREE C E UI I UO 12 Ele Save crie 13 AA de 13 A A o e O Cibi m ve tach aie et 13 FIE EIU AA gt 13 A T RE 14 Setup Chshge Ddtdbdse citet a isis 14 xi
15. and or line feed in this number Tools Lookup Tables WARNING If you plan to modify the Lookup Tables read these sections carefully This utility allows you to explore edit append new records delete records etc in StyleList s Lookup Tables It s easy and you can mold StyleList s action just as you want it But if you don t follow carefully the instructions in this section the program s accuracy will decline The Lookup Tables are databases of words and abbreviations StyleList uses these much as you d use a dictionary to look up a word or phrase These tables help the program to understand how you want it cased expanded abbreviated and or punctuated The lookup tables Prefix Table Last Name Prefix Table Last Name Table Suffix Table Title Department Table Company Table 4 Letter non Company Table Words Table Street Address Table City Table State Table Custom Table These tables are sorted on the first lookup field which is always in all Upper case whereas the other fields are in Upper Lower If you edit the fields be sure to follow this same format When StyleList looks up a word from your data in a lookup table it temporarily converts your word to upper case Therefore it doesn t matter whether your source data is in upper lower or upper lower case A word about word and delimiter Generally the program takes what emerges from the General Caser if U L is active and then scans the field looking for words
16. display to update while you are dragging the vertical scroll bar thumb tab For slower computers this option can be quite annoying though it looks pretty cool if your computer can handle it The user changes the size of a field Check this box if you want the browse display to update while you are resizing a field Slower computers will exhibit a fascinating zebra effect with this option on When ENTER is pressed during editing Proceed to the field on the right ENTER will save the current field s changes and then proceed to the field on the right Proceed to the record below ENTER will save the current field s changes and then proceed to the field below e Move Current Record so it always is displayed If checked whenever you use the vertical scroll bars to move through the database the highlighted record will move so that the highlighted record is always displayed Display Appearance Change Display Font Click this button to change the browser font o Style List Users Guide Tools Browse Options Display Font Size i X Cancel E Help 14 A Emended Old Enclih Tet MT 7 Sample AabBlrylz Changes the browse display font First select the font from the Font list Next select the font s style from the Font style list Then selecta size from the Size list Finally click the OK button to choose the font Tools Modify Structure Modify Structure allows you to change
17. fran Use the Interactive Importer Manually enter E Inherit current database s structure F Append onto current database Co py another database s structure E X Cancel Help When you use an ASCII file you are first prompted for the location and name of the file Then your choices are Use the Interactive Importer Use the interactive importer to determine the structure of the ASCII file Manually enter Hand enter the ASCII file s structure using a dialog much like Modify Structure Copy another database s structure Use another database that you will select as a starting point for the ASCII file s structure Once you specify the ASCII file s structure however you did that you are prompted for an output database name The file is then imported 39 Style List Users Guide Tools ASCII Conversion DBF to ASCII If you need to create a text file from your database use the ASCII Conversion DBF to ASCII Eq ld Fa ES Export Fields Soure Database Output File Add gt gt lt Hemave Allo lt lt Mone cnc ne cnc Esport Options File Type Deviant m First record contains field names M acirtash larmal CR no LF s Delimiter Cuno M Espor records marked for deletion E X Camel lelp Source Database This lists each field in the database By default all fields will be exported If you wish to export just a few fields first click None then click on ea
18. is usually the result of a misplaced or missing parenthesis comma or misspelling Type error One of the parameters given for the specified function is of the wrong type For example S ubStr RecNo 12 3 will result in a Type Error because SubStr s first parameter RecNo is a Numeric expression but SubStr requires a Character expression as its first parameter Other Errors These errors may occur anytime while running StyleList and may indicate a bug in the program Unknown error An unknown error has occurred in StyleList Make a note of what you were doing when the error occurred as precisely as possible and call Melissa Data technical support Exception Error An unexpected error has occurred in StyleList Make a note of what you were doing when the error occurred as precisely as possible and call Melissa Data technical support GPF An unexpected error has occurred in StyleList Try the operation again If the situation persists call Melissa Data technical support dBASE Syntax If you wish to restrict processing to only certain records you may enter a conditional expression While it is beyond the scope of this documentation to explain the full use of dBASE syntax you should see a book or manual on dBASE Clipper or FoxPro for that some rudiments are explained below dBASE syntax involves using quasi English expressions to tell the program what you want to do These expressions use Operators Functions and Literals i
19. the content of up to twelve fields together into a single field Input Fields Input Field 1 12 Enter the fields you want joined in the order you want them joined Output Field The field where the joined result should be deposited If data already exists in the output field Append new data to the end New data will be added to the end of any existing data in the output field Overwrite the existing data New data will replace any existing data in the output field Separate concatenated fields with A single space Example J ohn and Smith becomes J ohn Smith No spaces Example J ohn and Smith becomes J ohnS mith This separator Example J ohn and Smith becomes J ohn your string gt S mith Remove leading trailing spaces Trim no spaces Don t remove any spaces at the beginning or end of fields Trim leading spaces Remove any spaces at the beginning of fields Trim trailing spaces Remove any spaces at the end of fields Trim leading and trailing spaces Remove any spaces at the beginning and end of fields This is usually the preferred option 30 Tools Record Range All Process all of the records in the database Part of File Process only certain records e Record Range Process only the records between the from and to range given To process from a specific record to the end of a file specify 0 as the to record e For Setting a for condition restricts processing to just those records which meet the
20. the field length using the current settings 11 Style List Users Guide File Open Setup NETT TRIN Ix Look in ET aia bakout d Files of type Styla Setup E r L ancel Help Drive C statistics View Total 9 5 GE Used a2 GB Free F 6 GE Opens a previously created setup file Select the folder that contains the file you want from the Look in list Then select the file from the display box Alternately you can type in the drive subdirectory filename in File name Click Open Once you open a setup you can edit process or analyze the results See Setup Edit Processing Screen and Analyze Edit for more information File Save Setup El Aj cel lea mg File name T Save Save as tyne Sie iet Setup E L ancel Help t Drive C statistice Total 9 5 GB Used 41 GE Free 1 5 GB 12 File Menu Allows you to save the setup that you have just created or changed If you have never saved this setup before you will be prompted for a file name You can give a setup a new name by using Save Setup as see File Save Setup as The settings you save are available for future reuse by selecting File Open Setup File Save Setup as aj cl lea ng Save im ET File name a Save Save as type Slant Setup d L ancel Help dd Drive C statistics Total 9 5 kB Used 4 0 GB Free F 6 GB Saves the currently open setu
21. which need special treatment Normally StyleList checks for six delimiters plus the space to differentiate one word from another 43 Style List Users Guide Rules for Editing Lookup Tables Rules for Editing Lookup Tables 1 Be consistent In other words look at the words supplied and the way they are formatted and coded 2 Use allcaps 3 Omit punctuation There are two exceptions to this o In multiword lookups when the delimiter is not a space For example by pass AT amp T Dr Mrs or Wal Mart o If the punctuated version of a lookup results in a different expansion abbreviation than the non punctuated version For example S S 100 S Street might not be South Street S South 100 S Street probably is South Street LA La LA PUNTA shouldn t become Los Angeles Punta L A Los Angeles L A is Los Angeles Delete Mark the highlighted record for deletion Records marked for deletion can be unmarked by clicking this button a second time To permanently remove marked records choose Cleanup Append Add a new lookup table entry It is extremely important to note how the other records are formatted so that the one s you add are correct i e try to follow suit at all times Because StyleList ignores punctuation when doing lookups you should not punctuate lookup fields Make single word entries only For more details see Appending a Lookup Table Goto
22. with dBASE syntax use the Expression Builder e While Records are recalled until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder Tools Browse File Control Print Records Frinling Option Print Field Structure y Header amp Page Numbers Reconds Record Munbers Field Headings Font Record Range a Al Part of File Raced Range Fins 1 te Jo Fa Esplesson Bui hia Espresconr Bun Help Select the Wincows printer bo print Ea x Cancel 7 H lp 20 Tools Prints records meeting specified criteria The printed output will match the current browser state column contents positions and sizes will be identical IMPORTANT As you may have noticed Windows is really great at printing pretty fonts and graphics but at a cost of speed When it comes to printing the contents of a database speed is often more important than appearance Luckily there is a solution simply add the Generic Text Only printer to your list of Windows printers see your Windows documentation on how to do this and use it when speed is a concern It is perfectly okay to have two or more Windows printers working with the same physical printer so there s no reason to remove the printer s default driver from
23. ASE syntax can use the Expression Builder e While Records are printed until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax can use the Expression Builder Tools Browse File Control Pack Database Physically and permanently remove records marked for deletion In other words there is no going back after completing this option If you have many records marked for deletion it may be a good idea to make a backup first Before packing you are asked for confirmation 29 Style List Users Guide Tools Browse File Control Concatenate Fields Input Fields Input Field 1 MN uris 0 unes S Input Field 2 2 ImputFieid T Input Field 100 f Input Field 3 A Input Field t A Input Field tf Input Field 2 tF A tF Output Output Field IF data already exists in the output field ppend new data to the end FP Overarite the existing data Separate concatenated fields with Remove leading trailing spaces single space Tnm no spaces Mo spaces Trim leading spaces f This separator Trim trailing spaces Trim leading and trailing spaces K Part of File Recod Range From fi to JO Fo Expiecsion Buide while Expression Buide x Cancel 7 Help Use this screen to join
24. Avon PROCTOR AND GAMBLE Proctor and Gamble Proctor And Gamble CHAIRMAN OF THE BOARD Chairman of the Board Chairman Of The Board Exception Internal lower case characters StyleList keeps an eye peeled for any lower case characters in an otherwise UPPER field If it finds one it makes the bold assumption that you must have meant it that way Incoming StyleList Brand X DellHART DellHart Dellhart DellHART dellHart Dellhart DeANGELO DeAngelo Deangelo deANGELO deAngelo Deangelo de la CHAPPELLE de la Chappelle De La Chappelle NOTE This means that StyleList will not correctly process data that is currently in all lower case unless you have checked Override existing case Exception McNames Names beginning with Mc get the third character capitalized automatically so you get McDonald not Mcdonald 61 Style List Users Guide Exception MacNames Names beginning with Mac do not get the fourth character capitalized automatically since there are so many names like Maclin or Macy Instead they get special treatment using an Irish Last Name Table Exception ist 2nd 3rd 4th Numbers followed by ST ND RD or TH which are followed by a delimiter are lower cased so 1ST becomes Ist not 1St Exception Internal Apostrophes Internal apostrophes are treated with great care so you get results like these Incoming StyleList Brand X O LEARY O Leary O leary DEL HART Del Hart De
25. ENSE Character 1 Editing Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter OZ Tools Tools Lookup Tables State Table This utility allows you to explore edit append new records and delete records in StyleList s State Table Editing State Lookup Table Record 1 of 175 ST Taso ee ee S a A N EE d dies AE Yo E y ARO ek B hL seme mema oo AK ALASKA ALBERTA AMERICAN SAMOJAS Joo ooo o f Append Goto Locate Print Cleanup e OK canes 7 Help Structure of the State Table SLState dbf Field Char Len LOOKUP Character 24 ABBREV Character 24 CASETO Character 24 EXPAND Character 32 INSIG Character 1 INTENSE Character 1 Editing Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter 53
26. ENTER hits OK While traversing StyleLists dialog boxes hitting the ENTER key will immediately hit the OK button This is standard Windows behavior 06 Tools Display Tool Tips Check this box if you want StyleList to display the little yellow tool tips ocreen Saver behavior Don t suppress Screen Saver StyleList will not interfere with any of Window s screen saver operations Suppress Screen Saver during processing If StyleList is processing a database the screen saver will be temporarily disabled This option ensures that no precious processing cycles will be stolen by the screen Saver Suppress Screen Saver whenever running StyleList If StyleList is running the screen saver will not Confirm before exiting StyleList Check this box if you want StyleList to ask you if you really want to exit whenever you select the Exit command Tools User Settings Processing Settings Presa Settings M Endin Ace W Backup Data Slower Faster T r gd r og I ot E T fa Maximum Speed acral A Lode Page edau Whar a database le chooser C Don t open a setup sl with same name f amp Ack to open a setup with same name Automatically load a setup with same name Note that the following settings apply to new setups Already existing setups will keep the settings they had when they were saved End in ASCII Check this box to set the default End in ASCII processing option Backu
27. Go to a physical record number in the table Locate Locate a record by its contents Print P rint all or some of the contents of the table Cleanup Completely reorganizes the lookup table This option permanently removes all records marked for deletion and sorts the table alphabetically Editing Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down 44 Tools Lookup Tables Prefix Table This utility allows you to explore edit append new records and delete records in StyleLists Prefix Table lll Editing Prefix Lookup Table Record 2 of 90 3 JO x _ LOOKUP CASUJAGGH CASETO EXPAND II T TE Bue BROTHER B Er jm wen CAPTA ex CHANCELLOR Em EHANCELOR Em CHANCLLR hne Chancilr Chancellor EHANCLA Chren hanch Chancer CMDR L mdr Commander En j wee COLONEL Col 5 ___ ______ Append Goto Locate Print Cleanup T d OK X Cancel Help Structure of Prefix Lookup Table SLPre dbf Field Type Len Tools LOOKUP Character ABBREV Character CASETO Character EX
28. PAND Character INSIG Character INTENSE Character Editing 24 10 24 24 1 1 Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter 45 Style List Users Guide Tools Lookup Tables Last Name Prefix Table This utility allows you to explore edit append new records and delete records in StyleLists Last Name Prefix Table Delete Append Goto Locate Print Cleanup X Cancel Help Y ou ll notice that all but the first field is empty SLLNPRE is used primarily to recognize name parts However if you do enter data into the other fields StyleList will expand abbreviate change punctuation etc Structure of the Last Name Prefix Table SLLNPre dbf Field Type Len LOOKUP Character 24 ABBREV Character 24 CASETO Character 24 EXPAND Character 32 INSIG Character 1 INTENSE Character 1 Edit Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editin
29. Sea a ados 28 Tools Browse File Control Pack DataDa susto id lacio 29 Tools Browse File Control Concatenate PO ai eds 30 Tools Browse Pile COnuol S Olt File inate ice a A E T E atresia 31 Tools BFOWSe Fe ontrol Search Replace dadas 34 Tools Browse File Control Vertical DISDIGyS uu ined us ettet atraer ii 35 TOOS POW S C5 COMA ias 36 Tools Browse COMA S NOW Coll fifi cs olaa 36 Tools Browse E OUNAE MMS CONAN e bd 36 Tools Browse Column Change Column DISDIGy ni iia 36 TOONS BO WS ODEUOLS de ol 37 Tools Browse OPUS DISDIay TF ODE nr 38 TOOS MOI SU CHING sides restate th ie oes m d oboe tt oca tesa ce dita eode t acc gie distantes alias dede e one didod 38 IMPONAS el Balcon ND P A 39 Tools TASCH CONVE WAS ClO DB estalla 39 FOCIS ASCICONVErSsIion DBF TOAS Carnia Das 40 Tools ASCII Conversion ASCII to DBF Interactive Importe 41 Tools ASCII Conversion ASCII to DBF Interactive Importer Field Information eeeeeen 42 Tools ASCII Conversion ASCII to DBF Interactive Importer File Information o oooooooconnnncnnnnnnnnnnnnonononnnnnnnnos 42 00181 EOOKUD TaD OS auo tee trio P USE A o 43 RUES TOF Edilahg EOOKUD TE DIOS ra 44 Tools LOOKUP ables LP Tet Fableudsssd ene edd eub ender bo at odii ua pti batum unus bd custo vet deba ia nat bat RR 45 Tools Lookup Tables Last Name Prete Table osse aie ede vo a a a 46 Tools LOOKUP Tables Last Name Tablas 47 Fools Lookup T
30. StyleList User s Guide MELISSA DENIM Copyright Information in this document is subject to change without notice Companies names and data used in examples herein are fictitious unless otherwise noted No part of this document may be reproduced or transmitted in any form or by any means electronic or mechanical for any purpose without the express written permission of Melissa Data Corporation This document and the software it describes are furnished under a license agreement and may be used or copied only in accordance with the terms of the license agreement Copyright 2007 by Melissa Data Corporation All rights reserved Information in this document is subject to change without notice Melissa Data Corporation assumes no responsibility or liability for any errors omissions or inaccuracies that may appear in this document Trademarks StyleList is a registered trademark of Melissa Data Corp Windows is a registered trademark of Microsoft Corp The following trademarks are owned by the United States Postal Service amp CASS CASS Certified DMM DPV DSF2 eLOT First Class Mail Intelligent Mail LACS NCOA PAVE Planet Code POSTNET Post Office Postal Service Standard Mail Suite The Postal Service U S Postal Service United States Post Office United States Postal Service USPS ZIP ZIP Code and ZIP 4 DSF2 processing is provided by a nonexclusive licensee of the United States Postal Service Melissa Data is
31. a UT 15 PROCESSING S ChCC I e Oo O A 15 Processing Options StyleLIis t ODGFatiofis socis cue eei salas 15 Processing Sereen PTtocessihg O pUONS usd od avis acca een et cated eia tede daret orem ea tcd on einen RO AEN MU Suc 15 PROCESSING Screen Display Mode t 16 Processing Options Record R angesieestcmesve ais 16 PTR IY Z Secs cas es bp n CCP 17 PREV ERI Z SE CU c X E 17 TOONS drid 19 TODIS lBTOMWSG och upper east tado 19 TOOS Browse Buren um mr cA 20 TOOS BIOWSE RNG CONTON SOU E destin cp d 21 Tools Browse File Conto Processing Mode idad 21 Tools Browse Ene Control Delete RECO d Sirini e aa a 22 Tools Browse iF Ie Conto Recall RECOS nini a a este a ti erm tia i 23 Tools Browse E eC ONTO NeWR eco dirt dado ita 23 TOOS Browse rue E onto GOO Record aiii a a tonal ea Rb a a a et on 23 Tools Browse FIle Control LOCATE RECO vn sostenida dod vr bdo Rex Vider bailo abro 24 TOOLS Browse Fil Contool Locate Again norconia R 24 Tools Browse Eile Control Copy RS CO ROS nanna a E E EAE 24 Tools Browse File Control Append RECO card a A AE 25 TOOIS Browse lec ontrol Sort R eCOFOS eini e da 26 Table Of Contents TOOS BOWS ale 6 ohtrol Replace WIU io aida 27 TOOS Browse Fle Contool HC OUI ROC ORGS td netic attains 28 Tools BROWSE File Oncol PINCR e COTA
32. ables TUS Dept Tale aaa rd Mop babe ede heb ME nected deus Reap codi 48 Fools LOOKUP Tapes COMPA TA es 49 Tools Lookup Tables 4 Letter non Company Table dde 50 Tools EookUp Tables d Street Address Tabla ari aiii 51 Tools LOOKUP Tables Ib tanda ance teal van ariete Ceci tel villa ase tica Fem dead Vat atia o rooms 52 Tools l Eookup Tables TS tale Tables fee a a eren eo Petra foc cbe ovii entem 53 TOOIS I LOOKUP aes Mall DOSE Pack dd M vrkeevpr Oed eat eur oni eril EO a dn rro 54 TOONS LOOKUP Tables Custom Ue ONG tm 54 Altemate Lookup Tal eras is ass 55 Using Syet De LOOKUD TADO iras iS 55 Moditylng LOOKUP Tables outside S D TIe EISE sce m os heb do ia ch 56 lioe SEN CEP 56 Tools User settings General SEUN T vcre ciu idu idas 56 Tools User Settings Processing Seti dl a d Ga MED RUE 57 Tools User settings Fiela NA MUNG 5 ado a 58 plotter T 59 pizjeudHorcjeNpoloa peer rr 59 Help RCV WONG e E REEE EA A A ENSE 59 MeD OW DO Ee rerea a A E a Aa TE A 59 Help USMO He Diea ena E R OEN 59 Help WWW MelssaD ata COM sian a e lord 59 nn o E er eee er cre 59 Style List Users Guide RETT c T 60 t omimanhg Es HOS caste sete cette Sfc rusa a ML Met MM LC M Met t i 60 A NEP 60 WONG Us OM e dieti cud aureas tensa e ren Ur cu ertt E Ls UR Rt e pi E LE n 61 Saa S E ulli pM NEVER ates 62 Fecnnic aA SUPPO Mr ccm 62 OPUNIZINd 3 CCG as etna ek ses TT 63 SIISE RS ac eee eee eae Aree a
33. and that the media on which the Software is furnished will be free from defects in materials and workmanship for a period of ninety 90 days from the date of purchase The remedy for breach of this warranty is limited to replacement or refund at your discretion and shall not encompass any other damages including but not limited to loss of profit special incidental consequential or other similar claims EXCEPT FOR THE LIMITED WARRANTY ABOVE THE SOFTWARE AND USER MANUAL ARE PROVIDED AS IS MELISSA DATA MAKES NO OTHER WARRANTY EXPRESS OR IMPLIED WITH RESPECT TO THE SOFTWARE AND OR USER MANUAL AND SPECIFICALLY DISCLAIMS THE IMPLIED WARRANTIES OF THE MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE MELISSA DATA DOES NOT WARRANT THAT THE SOFTWARE AND OR USER MANUAL WILL MEET YOUR REQUIREMENTS OR EXPECTATIONS OR THAT THE OPERATION OF THE SOFTWARE WILL BE UNINTERRUPTED AND OR ERROR FREE YOU ARE SOLELY RESPONSIBLE FOR THE SELECTION OF THE SOFTWARE TO ACHIEVE YOUR INTENDED RESULTS AND FOR THE RESULTS ACTUALLY OBTAINED IN NO EVENT SHALL MELISSA DATA BE LIABLE FOR ANY 65 Style List Users Guide LOSS OF PROFIT OR ANY OTHER COMMERCIAL DAMAGE INCLUDING BUT NOT LIMITED TO SPECIAL INCIDENTAL CONSEQUENTIAL OR OTHER DAMAGES This Agreement shall be construed interpreted and governed by the laws of the State of California 66 Index A Alternate Lookup Tables eeeeeeee 55 Aia ZAC nata Cocoa Eua aa ros 17 Append
34. arch and Replace Search amp Replace any text in any field Vertical Display Displays all the fields of the currently highlighted record in a vertical window 20 Tools Tools Browse File Control Set Filter MET kd Ei Browse Recors All no filter fe Filter E sores or TT S Builder Display Records Show anl filtered records Show norrhltered records n green Help Type in the filter critena a valid dB ase espressiar x Cancel Yi H lp Allows you to view records that meet certain criteria A filter works just like a for condition except that it remains active until you either change or remove the filter So if you Copy Sort etc once a filter has been set the program will perform those actions only on the records that meet your filter criteria Y ou ll notice that subsequent File Control options will have the current filter condition listed in the for condition box Also when a filter is set the SetFilter tool will have a green background All Removes the current filter Filter Sets the filter to the expression specified to the right Expression The desired filter expression in dBASE syntax or you can use the Expression Builder Show only filtered records When browsing only filtered records will be displayed This can cause the browser to become a bit sluggish especially if your filter expression doesn t encompass many records Show non filtered records When browsing all records w
35. ations in the Casual column of the lookup table s associated with this field These abbreviations conform to the USPS recommended or required standards in Publication 28 for Companies Streets and States Abbreviate Words Aggressively Use the abbreviations in the Aggress column of the lookup table s associated with this field type NOTE This option should only be used if you specify Abbreviate Words Casually higher in the setup Strip Insignificant Words Strip the words that are marked as Insig in the lookup table s associated with this field type Truncate at Even Word Ending If the setup s target length cuts a word in half remove the whole word Strip Embedded Vowels Strip internal vowels but not vowels at the beginning or end of a word To change the abbreviation options use the arrow keys to highlight one of the five options To move the method simply hold Ctrl and use the up and down arrows to put the method under the correct action line and in the preferred order of execution You can also use the mouse to drag and drop NOTE Records that exceed your desired length can be manually edited in Analyze before changing the actual field length For more information see the Analyze section of this manual VERY VERY IMPORTANT NOTE f you need your file to be abbreviated as consistently as possible you will need to strip punctuation While Acct Rec will be abbreviated to A R AR will not have punctuation added to it bec
36. ause to do so would lengthen the data The only way we could have made all abbreviations consistent would have been to strip the punctuation from the lookup tables but that would have left those of you who wanted punctuation in a lurch If anyone has a great suggestion on a better way to solve this problem Give us a call Note also that using IF NECESSARY will produce inconsistencies because certain words phrases will be abbreviated in long fields and left alone in short fields where there isn t enough room to fully expand the data File New Setup Punctuation Options Fur ictu iuri Clive rx f Add Punctuation f Strip Punctuation Don t Touch Existing Punctuation When you choose expand or neither in the Options box StyleList will display Punctuation Options Add Punctuation Adds proper punctuation such as Mr to Mr Itis not available when you elect to abbreviate a field Strip Punctuation Strips all periods and commas from the output Although this makes the line less attractive to the eye the USPS prefers that address and city lines not contain periods and commas Don t Touch Existing Punctuation a k a PIPO Punctuation In Punctuation Out StyleList will leave punctuation untouched 10 File Menu File New Setup Make Use Default When you create settings for a specific field you can save and reuse the Options Punctuation Options and Abbreviation Options settings Make your selections for a speci
37. ch field you want exported and click Add Output File This lists each field to be exported To remove field s from this list simply click on each field to be removed and then click Remove Note that the field sequence of the Output File list always follows the same sequence as the Source Database list The only way to change the Output File sequence is to physically modify the source database s structure See Tools Modify Structure for more information Add Click to add selected fields in the Source Database list to the Output File list Fields already appearing in the Output File list will not be added again Remove Click to remove selected fields from the Output File list All Click to export all of the fields in the Source Database list None Click to remove all of the fields from the Output File list File Type 40 Standard Data Format SDF Often also called fixed field Used with dBASE and many other database systems Fields are of fixed length padded with spaces and each record is delimited with a carriage return and a line feed Flat File A common mainframe format Fields are of fixed length just like SDF but there are no record delimiters of any kind Delimited A common dBASE format Fields are of varied length and delimited with a single character often a comma ora tab Sometimes particularly with character fields fields are surrounded with double quotes Delimiter Delimited File only The field delimiter Everybody
38. condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax can use the Expression Builder e While Records are processed until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax can use the Expression Builder When you press OK you will go to the Processing Mode screen Tools Browse File Control Split File Splits your file into one or more sub files 31 Style List Users Guide apodo ote DX mee even lt neth record file Randomly select zn records from file V Base split on the contents o a fied Splitinto n Recors Byles o Files Wake files having no more than lecorcs each Make tiles with no larger than 0 bue each Make esac o da Select evan zn ih record hom file Randond select on ragade hom Ihe file Randomyselea D records hom the Hie Eae split on the comands ol a badd S pM oin Lise hast o chaactas of heki Output Files isk me eaca time Use the contents od the Bald lo name the oulpall Hes Assigneact tle a number put then herz Directory EDan Browse Record Range
39. cords from another database onto the end of the current database When choosing this option you are prompted for an input folder and file name Y ou are then prompted with the dialog box shown above Note that unlike any of the other file control tools the Record Range settings apply to the input file not the current database IMPORTANT Field names and field lengths should match between the two files All Append all of the records in the input database to the current database Part of File Append only certain records Record Range Append only the records between the from and to range given To append from a specific record to the end of a file specify 0 as the to record For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder While Records are recalled until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder 20 Style List Users Guide Tools Browse File Control Sort Records Sort E xpressior Expressio
40. e of a database containing memo fields Also don t use StyleLists utilities to sort copy append from or pack records in databases containing memo fields This could cause the memo fields to become disconnected from their associated records File Menu File Open Database Opens the database file you want to work on Select the folder that contains the file you want from the Look in list Then select the file from the display box Alternately you can type in the drive subdirectory filename in File name Click Open Look in E a gt Hi File name Files of ype DBeB bg Drive C statistic T otal 4 5 GB Used 40 GE Cancel Help Via Ipon Free F 6 GB View Preview the currently highlighted file see File Viewer Import Pro Series only Import the currently highlighted file see Interactive ASCII Importer Once you open a database you can either create or open an existing setup Style List Users Guide File Viewer Tan gir HUHI fi ul l i Bosta Umdersood aba Emmy Edith O Ben Billy Mitchell Belody Christophe Michmel Curtin 4 L 3 B Dx E ds E o S Yi File Info Click this button to show general information about this file name size access date as well as character frequencies Hex Click this button to display the file in hexadecimal Often characters in ASCII aren t what they appear particularly in Windows This is an excellent way to see exactly whatis i
41. e the Expression Builder Tools Browse Column Hide Column The column at the currently highlighted position will no longer be displayed the browse window Tools Browse Column Change Column Display Fupressine Fido T d OK X Cance 7 Help The column at the currently highlighted position will be modified to display what you specify in the above dialog box Field Click this option if you wantto display a specific field in this column 96 Tools Expression Click this option if you wantto display the result of a dBASE expression in this column Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder Tools Browse Options The user drags the Wetical ScrollBar Thumb Tab The user changes the size of a field When ENTER E pressed curing editing Proceed to the field ar the raht Proceed to the record below l Move Curent Record zo it aras iz displayed Display Appearance Change Display Fort X Cancel elp Update the Browse Display immediately when The user drags the Horizontal Scroll Bar Thumb Tab Check this box if you want the browse display to update while you are dragging the horizontal scroll bar thumb tab For slower computers this option can be quite annoying though it looks pretty cool if your computer can handle it The user drags the Vertical Scroll Bar Thumb Tab Check this box if you wantthe browse
42. ees 55 V A ken eo seen ete as 35 W Fari O E eale tured las 65 WIEN Was roba aaa Ur vob Pide 2 Words T aplausos voco ud Fes it 50
43. en 0 and 8 decimal places Offset SDF and FlatFile only The offset of this field from the beginning of the record This is purely informational Prev Fld Edit to the previous import field Next Fld Edit the next import field Tools ASCII Conversion ASCII to DBF Interactive Importer File Information File Information File nfermatian File Type Dalmiad Delimiter Comma Y Record Size 308 File Type The type of ASCII file being imported SDF Often called fixed field or standard data format Fields are of fixed length padded with spaces and each record is delimited with a carriage return and a line feed SDF Ragged SDF A spin off ofthe SDF format usually made by custom or in house programs The difference is that all trailing blanks at the end of each record are trimmed off 42 Tools Flat File A common mainframe format Fields are of fixed length just like SDF but there are no record delimiters of any kind Delimited Fields are of varied length and delimited with a single character usually a comma or a tab Sometimes particularly with character fields fields are surrounded with double quotes Each record ends with a carriage return and a line feed Delimiter Delimited File only Select which character divides fields within a record if any Record Size SDF and Flat File only The number of bytes used to store each record Remember to count the carriage return
44. es slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder 33 Style List Users Guide Tools Browse File Control Search amp Replace sot dats Phe pe wes 5 creen File Get nput From Y Screen File Enea Fields Search Field Replace Field Daba Saareh lo sting hon Seach Feld Geach amp Replace Search for F Blark Field Replace with Blark Field Search amp Replace Options rm lgnore case Y hole word a Mulliple Cocunences Arn Occurence First occurence Park ei File Read Range Fron 1 to fo Fa Expressions Buider pD whe Expression Buider j Xx Cancel 7 Help Search for a specific string and replace it with another Get Input From Screen Enter the search and replace strings manually on this screen File Get the search and replace strings from a specified file You can click the Browse button to select that file A search and replace file must be a dBASE database with two character fields The first field will be used as the search string the second as the replace string Fields Search Field The field to search for the text entered below Replace Field Use this field to write the replacement text into The default is to write the replacement text in the Search Field but you can opt to write the replacement t
45. ext into different field without overwriting the contents of the Search Field Delete Search for string from Search Field If you chose to Replace into a field other than the Search field you can remove the Search for string from the original field or leave it as is Search and Replace Search for The string to search for If you don t choose to ignore case then be sure to enter the data exactly as desired Blank Field Search for a blank field in the Search Field Replace with The string to replace the text in the Search Field Blank Field Replace the contents of the Search Field with a blank field 34 Tools oearch Options Ignore Case Ignore the upper lower casing while searching Whole Word Any Occurrence When Whole Word is selected IT will not be found in SMITH SMIT or ITH In order to be considered a whole word the search string must a have a space on each side b be at the beginning of the field and followed by a space or c be atthe end of the field preceded by a space When Any Occurrence is selected the string may appear anywhere in the field Multiple Occurrences First Occurrence When Multiple Occurrences is selected each and every occurrence of the Search for string in a field is replaced with the Replace with string With First Occurrence only the first occurrence is replaced Record Range All Process all of the records in the database Part of File Process only certain records e Reco
46. f the default settings File New Setup Abbreviation Options Sbbievialicn C plimr is Target Size ff currentu 48 Style List Users Guide StyleList can abbreviate words to alleviate limited field length problems like cheshire labels If you choose to abbreviate a field the setup screen will allow you to specify how StyleList abbreviates your data Target Size What is the maximum number of characters that you want StyleList to use in this field To the right is the current field length NOTE In this menu you are shortening your data length not changing the length of your field For your convenience there is a button in Modify Structure that will change all of your abbreviated fields to your specified length automatically See Tools Modify Structure ALWAYS Any and all items listed under ALWAYS will be done even if the data starts under the desired length In the illustration above punctuation will ALWAYS be stripped and casual abbreviations will always be substituted for more information on aggressive vs casual abbreviations see Tools Lookup Tables IF NECESSARY Items listed under IF NECESSARY will be done in the order that they appear until the data in that field is under the length you require NEVER Any item under NEVER will not be performed even if the data in the field exceeds the specified length Options Strip Punctuation Remove all punctuation periods and commas Abbreviate Words Casually Use the abbrevi
47. ffset by moving the pointer in the field s heading until it becomes a ap then dragging the field s edge to the desired offset Adjusting Sizes If you would like to import into a larger or smaller field than what is represented you can resize a field by pressing the CTRL key and moving the pointer in the field s heading until it becomes a HM then dragging the field s edge to the desired size The unused portion of a field made smaller is shown in red while the added portion of a field made larger is shown in yellow 41 Style List Users Guide Tools ASCII Conversion ASCII to DBF Interactive Importer Field Information IA A A 43 Field Infarmatian Field Mame MAME Type Chasacter af Size m Decimals o Offset o 4 Fid gt gt Next Fld X Cancel 7 Help Name Like all dBASE field names the name must be between 1 and 10 characters The first character must be alphabetic but the others may be letters numbers or the underscore Embedded spaces are not allowed Type There are four options Character Date Logical and Numeric Size Numeric field sizes must be between 1 and 20 Size adjustments can be also accomplished by CTRL4clicking and dragging a field s edge The program will automatically change the size of Date fields to 8 and Logical fields to 1 Decimals Numeric fields only Decimal places must be between 0 and the field s size minus 2 i e a numeric field of size 10 can have betwe
48. fic field and then use Make Default To use these settings on a different field select Use Default Any new fields set up will use these settings as well Note that the Field Type is not saved as part of the default settings File New Setup Testing a Setup Pas pale iii Before After Content O Frequency 3 Total ever 30 0 Test will show you if the current settings will give you the desired results Ata glance you can see the average length of your processed data and the extent of truncations that will occur In other words you can easily see if you need to make changes to your settings Before Shows how much of your data currently exceeds your target length Each column represents the number of records that have a specific number of characters in a field The far left represents the number of records with no data in them and the far right represents the number of records with 45 characters the starting length of this field of data in them When you move the cursor over a column the Content Frequency and Total over 30 numbers will change to reflect the data in that column After Shows how well your data will be abbreviated using the currently selected methods of abbreviation Here the columns stop because there won t be any records that will exceed the target length after processing See the Before section above for more details The red section of the screen is the portion of your data that you will lose when you modify
49. for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder e While Records are recalled until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder When you press OK you will go to the Processing Mode screen 2l Style List Users Guide Tools Browse File Control Count Records Record Range A E Part of File Reced Range Fia 1 in fo Fe Emesso e Bit thie Expression Buia E x Cancel Yi H lp Count the number of records meeting specified criteria All Count all of the records in the database Not usually a very useful option when counting Part of File Count only certain records e Record Range Count only the records between the from and to range given To count from a specific record to the end of a file specify 0 as the to record e For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar
50. g Lookup Tables at the beginning of this chapter 46 Tools Tools Lookup Tables Last Name Table This utility allows you to explore edit append new records and delete records in StyleList s Last Name Table oacorTa 0 006 LOOKUP CASUAL AGGRESS CASETO EXPAND m TT pars pas Lr ALLINHA ADALT ADAMIC ADDIECO ALPONTE AMANGO ANGELO APONTE APRATO i Delete i 1 Lo O NENNEN NNNM a 0j AGOSTINO DAgostimo O A EN O C o CO C a i Cleanup Append Goto Locate Print DAdarmia iA ddieco DalPonte aPrato X Cancel Help Structure of the Last Name Table SLLN dbf Field Type LOOKUP Character ABBREV Character CASETO Character EXPAND Character INSIG Character INTENSE Character Editing Len 24 24 24 32 1 1 Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter 41 Style List Users Guide Tools Lookup Tables Title Dept Table This utility allows you to explore edit append new records and delete records in StyleList s Title Department Table lil Editing Title Department Lookup Table
51. g in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder 26 Tools Tools Browse File Control Replace With oe eden Tide neal Sort Ezpressior Replace Field Expression E ulder Record Range Y fll Part of File Raced Range Fige 1 tr Jo Fa Espresconr Bua hia Expression Buika Help Type in the replace expression a valid dBase expression x Cancel 7 H lp Replace the contents of a field with a specified expression Replace Field The field you wantto replace with different data Expression The dBASE expression that will determine the new contents of the Replace Field The contents must be the same type of data as the Replace Field For example if the Replace Field is a numeric field then this expression must result in a number Instead of typing a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder to assist you All Replace all of the records in the database Part of File Replace only certain records e Record Range Replace only the records between the from and to range given To replace from a specific record to the end of a file specify 0 as the to record e For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a
52. h and Replace file you can use the original method to denote trailing spaces the degree symbol ASCII character 248 Tools Browse File Control Vertical Display Piao nl a 1 ES ICI Undo Previous P Next Help Display all fields of the currently highlighted record in a vertical screen Close Save changes and end vertical display mode Undo Undo any changes made to the current record Previous Save changes and go back to the previous record Next Save changes and advance to the next record 30 Style List Users Guide Vertical Display Keys PAGEUP PAGEDOWN Move to previous next record CTRL PAGEUP CTRL PAGEDOWN Move to first last record of the database Tools Browse Column Tl T TI Show Column Show a new column in the browse window Hide Column Hide a column from the browse window Change Column Display Changes what data is displayed in this column Tools Browse Column Show Column H E Si lo Column Contains Expressions Buiken Td OK X Cance Help A column will be added to the browse window at the highlighted column position Its contents will be what you specify in the above dialog box Field Click this option if you wantto display a specific field in this column Expression Click this option if you want to display the result of a dBASE expression in this column Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax can us
53. he end of the database You can also use the shortcut CTRL N to perform this task Tools Browse File Control Goto Record a den dda TE Goto Record Roto Record Hunber E DK x Cancel 7 Help Proceed to a particular record number e Go to Record Number Enter the number of the record number you want to go to It doesn t get any simpler 23 Style List Users Guide Tools Browse File Control Locate Record irse dan Locate Hecord C Ary Field Selected Fields EAST LAST STREET am hd Search or M Ignore Case lelp Type in the string to searck Far frcm Start from Here X Cancel 7 Help Locate a record fitting specified search criteria Any Field Search all fields for the desired search string Selected Field s Search only selected fields for the desired search string To select a field click on it You can click as many fields as you desire Search for Enter the string to search for If you haven t checked Ignore Case then be sure to case this entry properly Ignore Case Ignore the upper lower casing while searching from Start Start the search from the beginning of the database from Here Start the search from the current record Tools Browse File Control Locate Again Locate a record fitting a previously specified search criteria Tools Browse File Control Copy Records Record Range amp Al f Part of File Recad Range Fen 1
54. ield Move highlight to the first last field Move up down one record Pan window up down one record Go to the first last record of the database Move up down several records CTRL PAGEUP CTRL PAGEDOWN Pan window up down several records Editing Editing a record s contents is quite simple either double click on the desired field with your left mouse button or Simply start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving either one field right or one record down see Tools Browse Options to set this behavior Resizing a column Move the pointer over the column s edge until it becomes a qP then drag the column s edge to the desired size Style List Users Guide Moving a column Click the column s gray heading area then drag itto a new location Changing a column s display You can change what data is displayed in a column by double clicking its gray heading area Y ou will then have the option to display a specific field or the result of a dBASE expression see Tools Browse Column Change Column Note that the same field can appear as many times as you like Adding new records Select File Control New Record or hit CTRL N You don t have to be at the bottom of the database to add records but the record will always be added to the end Deleting records To mark
55. ill be displayed but records not matching the filter expression will be displayed in green Unlike the Show only filtered records option above this option does not get sluggish Tools Browse File Control Processing Mode For use with Search and Replace Replace With and Concatenate Replace regardless of truncation Verify every replacement The screen will display the current contents of the field and what it will look like after replacement The processor will ask if you want to process the record every time Verify only when replacement will result in a truncation The field is displayed before and after replacement only when processing will result in a truncation If the replacement string is longer than the search string so a truncation would result the processor will pause to verify whether or not to proceed with the replacement Skip replacement if it will result in a truncation In all cases the search string is automatically replaced with the replacement string unless the replacement will cause a truncation No replacements are displayed to the screen Replace regardless of truncation In all cases the field is automatically replaced with the replacement string or as much of the replacement string as will fit no exceptions These replacements are not displayed to the screen 21 Style List Users Guide When you use Verify every replacement or Verify only when replacement will result in a truncation y
56. it DOS Table to Windows uA ac X Cancel 7 Help StyleList allows you to use your own lookup tables When you select an Other button you can enter the path and file name of the lookup table you wantto use or you can use the Browse Your table must have the same field name structure but not the same field lengths as a StyleList for Windows or StyleList for DOS 4 x Lookup Table You can also import StyleList for DOS files for more information Using StyleList 4 x Lookup Tables If you have made significant changes to your lookup tables for StyleList 4 x we have provided an import utility so you can convert them to StyleList for Windows For StyleList to use these lookup tables 1 Enter StyleList 5 0 and go to Tools User Settings and press Lookup Tables 2 Press Convert DOS table to Windows and follow the on screen instructions Y ou will have to repeat this for each of the tables you import 99 Style List Users Guide NOTE You can also elect to have StyleList for Windows use your StyleList for DOS tables just by specifying the table to use in the appropriate box ALSO StyleList for Windows does not update your old table in any way but fully accepts the data warts and all Particularly the Street and Company Tables have been improved dramatically so you may want to think twice before using your old tables Modifying Lookup Tables outside StyleList You can modify StyleList s tables outside of the program Fo
57. l hart GOV MENT Gov ment Gov ment Exception Conjunctive words Finally the words And On Of and The are given special treatment StyleList s Files Windows and runtime support files are not listed here SI32 Exe 32 bit Executable SIRes32 DII Resources Sl Ini Setup Information Cp Translation tables SI Dbf Lookup tables Ps Fon Special Melissa Data font for displaying the entire ASCII character set Sl chm Help Technical Support 1 Please check the manual and or help file first Over half of our calls relate to information already covered here 2 Next check the list of StyleList Errors It may solve your problem immediately Be sure to check our website MelissaData com for the most recent release of our software Updates are free 4 Ifyou still need assistance Sales 800 MELISSA Tech Support 800 MELISSA Fax 781 545 7717 E mail tech melissadata com World Wide Web melissadata com Mail Melissa Data Corp 22382 Avenida Empresa Rancho Santa Margarita CA 92688 2112 62 Reference Optimizing Speed Some tips to help you maximize StyleList s processing speed Equipment It goes without saying that the faster your machine the faster StyleList will process Occasionally single component s will cause a major slowdown For example an old hard drive will slow down even the fastest processor Network Its almost as obvious as equipment slow network topology and or protocol equals po
58. lace part numbers with product descriptions or codes or categories One man even used StyleList to make a very rough translation of S panish to English To add a new custom table go to Tools Lookup Tables Custom New Custom Table Y ou will then be prompted for a name for your custom table These tables are stored in the same directory as your StyleList program 54 Tools Structure of a custom table dbf Field Type Len LOOKUP Character 24 ABBREV Character 24 CASETO Character 24 EXPAND Character 32 INSIG Character 1 INTENSE Character 1 Editing Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER orthe Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter Alternate Lookup Tables ME T able 4 ras nan Lompanu Dieta amp Deau fe Other aibank GiPeaDhf Bowe o Other que e ama refis T able es dros Takle Uefan Degau Other o B ree Othe Enqeeza cde Table City T able Cefan Defan a Other Eres ca C Other quese 5 a T able PN T able Defan Defau Cc Other Browse e Other Biqase tHe Depar ment T able gee Damar T able fe Defau Degau E Other ra E Other Birse ERIT Table Dickow C Other Era Lonve
59. ld type There are four options C Character D Date L Logical and N Numeric Date fields are automatically sized to 8 and Logical fields to 1 Change Field Size Double click on the field size to be changed and enter the new size Logical and Date fields have fixed sizes so you cannot edit these sizes Character field sizes must be between 1 and 254 Numeric field sizes must be between 1 and 20 Remember that if you shorten a field you will lose any data that exceeds the new field width Change Field Decimals Numeric fields only Double click on the decimal place to be changed and enter a new number Decimal places must be between 0 and the field s size minus 2 i e a numeric field of size 10 can have between 0 and 8 decimal places Move Field To move a field click anywhere on that field and drag It to its new location or press CTRL UP or CTRL DOWN Import ASCII Files Go to Tools ASCII Conversion ASCII to DBF OR Select an ASCII file in any of StyleLists setups and you will be taken directly to the ASCII Importer Tools ASCII Conversion ASCII to DBF StyleList can process files in dBASE format without any intervention It can also process files in ASCII delimited fixed field and flat files if you specify a structure If you select an ASCII file when you are in a setup you will specify the structure but you won t actually import the file Wd ns EI ki Es ASCII Import Where will the destination structure come
60. lds sizes by dragging the dividing line to the left or right Join Field SDF and FlatFile only You can join two adjoining fields into a single larger field by clicking this button The highlighted field and its neighbor to the left will be joined Exclude Field Y ou can intentionally exclude a field during importing by clicking this button Of course this field won t be removed from the original ASCII file just the imported database Excluded fields are shown in gray Clear Fields Y ou can wipe out all of the fields so you can start all over by clicking this button Use first record for field names If the ASCII file s first record contains field names as opposed to data then check this box to use that data as field names you can still change them to whatever you like During the import the first record will not be imported as data File Info Click this button if you need to change the ASCII file s type Occasionally the program will incorrectly guess the file s type and or record size Changing an ASCII file s type will cause the importer to reassign fields so any changes made to field names positions etc will be lost Field Info Click this button or double click on the field s heading to change the information about the highlighted field You can change the field s name type size and decimal places Adjusting Offsets SDF and Flat File only If the break between two fields isn t where it is supposed to be you can move the o
61. lts MacNames Using a modifiable lookup table StyleList now knows how to case MacDonald and Macintosh Street Casing The logic used for street casing has been enhanced to handle difficulties encountered when working with street addresses State Expansion Now your wedding and inaugural invitations can have fully spelled out state names ZIP Formatting StyleList un E xcels ZIP fields by fixing ZIP Codes that have lost their leading zeros Standardizes ZIP 4 and Canadian Postal Codes Phone Formatting StyleList can standardize phone numbers into a variety of formats Email Formatting R emoves illegal characters from email addresses and completes truncated domain names i e user 9 aol becomes user aol com System Requirements StyleList for Windows requires e Windows 2000 XP or Vista e 8MB of RAM 32 MB or 64 MB is better e 10 MB of available hard disk space File Requirements StyleList processes files in dbf format dBASE III IV FoxPro and ASCII fixed field delimited and flat formats Visual FoxPro databases can be processed directly by StyleList However do not use StyleList to modify the structure of a Visual FoxPro database The additional header information structure indexes catalogs etc will be stripped StyleList can process name address fields with databases containing memo fields However it cannot process the memo fields themselves Additionally you should never try to modify the structur
62. n a gut Record Range el Part of File Recad Range Fio i lx lo Fo Espiecsn Bute whi Espresso Buttes x Cancel 7 Halp Sort the database by a specified sort expression Important Note that you may specify to sort only part of the file The rest of the file will be effectively removed i e as if you deleted the rest of the records and then packed Expression The dBASE expression to use to sort the current database This must result in a character expression Instead of typing a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder to assist you All Sort all of the records in the database Part of File Sort only certain records e Record Range Sort only the records between the from and to range given To sort from a specific record to the end of a file specify 0 as the to record e For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder e While Records are recalled until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax Instead of typin
63. n 7 8 9 NeW et Alla on 7 O Open Data aS eden aaa 5 OPENS CUD opi E 12 ODumizing S Deeds psit tin laados s 63 P Pack Dalase stessi ii 29 PEI ITOO Pr A T 45 PE ee Ol GO canton tela suse bdo en ee 28 Processing MOOG es ativan sax said tek Vetere sexta ebat ies 21 Processing O DUO INS S aee torta del leone vetas Ec 15 Display MOOG T estesa get rea 16 OID CTA ONS uta tata ue atlanta 15 ROCOI RAIN C menora 16 PROCESSING S CrCl o ebore Pate plebes urna is 15 Punctuation OPUONS sescenti veo End ese eroi ird ains 10 R Recall ecOIdSussun obispos ntastes hls ades tds 23 Rename a Setup File nuria 13 Replace ReCOFUS aksini aa 27 Reuse a OCUP irino aa dice p viuis 13 S e 12 Save SOUP AS il a i 13 Ip AA e earner hmanentenanns 42 SDF iRagged SDEF usina dsd 42 Search e Alo ra APM E A 34 A A e o E CO OA 21 Setup Make Use Default eeeeeee 11 SNOW COUT sedo decet td 36 SOP GCOS quesstistpa retentus eonim R 26 SPICE eR 31 SOE TONE E 53 Street Address Tablet err ub ei 51 67 Style List Users Guide SIVICMIS CETTONS Sape iq iet poser Eq eoo Mode RE 63 StyleLists Fl rotar 62 System Requirements cccccccccccnccnnnccnnnononccnnnnnonccnnnnnnos 3 T Techhicat SUD OM x credo 62 TESES CU estes cc 11 Te DGD Tala oot elt eb yeu bed 48 U U pper Lower Casing ira 61 A e anes 56 08 Default Ricla Name Sano 58 General cunda c de 56 PROCESSING Seting Sinki 57 Using SL 4 x Lookup Tables
64. n conjunction with the Field Names in your database Definitions FOR Condition A True F alse expression determining which records will be affected during a database operation Each record in the database is evaluated for this condition WHILE Condition An operation that will continue only while the expression is True then it will stop SORT Expression A character expression that will be evaluated for each record to be sorted Technically Melissa Data sorts are actually an index operation followed by a copy operation FILTER Condition Similar to a for condition except in its context For and while expressions are always 64 performed in conjunction with another operation whereas filter conditions occur all by themselves and affect any subsequent operations like a for would Reference Types of Expressions There are four types of expressions Character Date Numeric and Logical In this document they look like this Cexp Character expression lt Dexp gt Date expression Nexp Numeric expression lt Lexp gt Logical expression Exp Any type of expression Expressions can consist of a literal Melissa Data an expression SubStr Melissa Data 5 3 a field Name opecifying Literals Literals must be specified in a special way so the program can distinguish between character date numeric or logical literals Character Literals Delimit with double quotes single quotes or square brackets
65. n your data File Viewer File Information File nformation File dame e persstemp sdF File Size 147 582 Lest Updatec 04710097 15 41 20 Piobabe File Type SDF ASCH Frequencies File Name The name of the file being viewed File Size How big the file is Last Updated The last time the file was written to Probable File Type The most likely format of this file this is usually correct ASCII Frequencies Counts of each type of character in the file This extremely useful statistic can be used to determine whether your file has any offensive characters ones under ASCII 32 or over ASCII 127 File New Setup Field Field Toe f Prefi First 4 ame E LastName Sufix Full Name F rveiee Mame F Gov Inverse F Department T ille Company F Street Adcress City only Stake oral amp Zip only City State ip Phone f E Mail Address F General f Custom File Option Mlode F Expand f amp bbreviate 8 Neither T Test Make Def aull Use Default x Cancel 7 Help File New Setup Field Field Punctuation Options Add Punctuation Strip Punctuation t Dont Touch Exist ng Punctuation Cas nig 8 UppeLover Upper F Non Bl Override existing case File Menu All character type fields in your database are listed here other type fields like numeric and date are grayed out Check the fields that you want to convert to the new setup
66. nd or states provinces use City State Zip City State Zip Field should contain all three elements in exact order Phone Phone numbers only The number will be formatted in the format you select E mail Address E mail addresses only The entire address will be automatically lower cased File Menu General Whatever you want If you mark a field as General and upper lower case option is selected its data will only be run through the General Caser With a few exceptions the General Caser will lower case every character in the field Then it capitalizes every character which is not preceded by an alphabetic It also strips any leading spaces and reduces multi space gaps to a single space Override existing case tells the caser to ignore erroneous lower cased characters and process each word as if it started in all upper case For more information see Casing in the Reference Section Custom Whatever you want The data will be run through the General Caser if you have checked upper lower case and then it will be run against the chosen custom lookup table You can create several different custom tables See Custom Tables in the chapter on Lookup Tables File New Setup Option O pliuri Mode Casing Expand Upper Lower f Abbreviate Upper Neither None B Overide existing case This is where you choose how you want your data processed Do you want to expand or abbreviate How should the data be cased For these options to w
67. occurred while accessing the specified file Try the operation again If the situation still persists call Melissa Data technical support Unable to load lookup tables Ensure that all of the Lookup Tables exist If the condition still persists try re installing StyleList dBASE Expression Errors dBASE errors occur when you are entering a dBASE expression as a While For Filter or Sort expression Syntax error The expression is syntactically incorrect A syntax error may be caused by a misspelled function or field name Mismatched parenthesis The expression is missing a right or left parenthesis Remember that you should have a matching number of left and right parenthesis in an expression Mismatched delimiters A literal character string was specified with non matching or missing delimiters Does not evaluate to a expression The expression does not result in the specified data type For example LTrim F irst a character expression is not an appropriate expression for a Filter condition which requires a logical expression Field does not exist The specified field does not exist in the database This is usually the result of a misspelling Function does not exist The specified function is not valid This is usually the result of a misspelling Empty expression No expression was specified although one is required Invalid number of arguments Too many or too few parameters were given for the specified function This
68. of 1 2 3 and 4 letter words 1 Dictionary words abbe 2 Common prefixes and suffixes mega Pre 3 Abbreviations in SLCo dbf above Acr Addr 4 People s first and last names J ohn Because there is an endless variety of first and last names we restricted the list to those which occurred in more than 4 in 100 000 people Structure of the Words Table SLWords dbf Field Type Len LOOKUP Character ABBREV Character CASETO Character EXPAND Character INSIG Character 1 INTENSE Character 4 4 4 4 Editing Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter o0 Tools Tools Lookup Tables Street Address Table This utility allows you to explore edit append new records and delete records in StyleList s Street Address Table lll Editing Street Lookup Table Record 1 of 772 m x Sour xU REDRESS ORE a A mE RN o G ETT M a E Rp fr TO ner Jg 1 LL Wn fr ll RE Ry le fe Tp mev lI LH uv a e TO S e P ie 8 1 h MER hue A
69. or results In general databases process faster on a local hard drive compared to a network hard drive there s less hardware between the application StyleList and the data If you re processing a large file on a regular basis relocating the database on a local drive may save you lots of time Plus you won ttie up the network Also be sure to designate a large fast local drive as your work directory never use a network drive unless it s absolutely necessary when it s the only drive with enough free space Defragmenting Regular defragmenting is highly recommended Hard drives get fragmented the most when you have limited disk space and are loading off loading large files Which is of course what you do every day StyleList Errors General File Errors General file errors are situations that may occur while attempting to access a database setup or ASCII file e No such file or directory The specified file directory does not exist e Permission denied You don t have permission to open the file On a network this usually indicates that you don t have adequate access rights to this file 1 e read write append or create On a non networked computer this usually indicates that the file has been marked as read only e File already exists The specified file directory already exists e Could not create file The specified file directory could not be created On a network this usually indicates that you don t have adequate access
70. ork properly you must make sure you have selected the right Field Type A field could contain differing types of data for example either a name or a company you need to refield the database before using StyleList Melissa Data makes an excellent program called Right Fielder to solve this kind of problem for you Expand Expands abbreviations 2 Main St becomes 2 Main Street Abbreviate Creates abbreviations like 2 Main Street becomes 2 Main St Neither Neither expands nor abbreviates your data However you can case and add remove punctuation if you elect to Upper Lower Properly cases your data see below Upper All characters will be put in upper case see below None Leave casing as it is Override existing case If your data has been badly cased e g by using Excel s or Foxpro s Proper function be sure to check this box Otherwise StyleList will see that the data has already been cased and will leave the current casing unchanged available only when you select Upper Lower NOTE ZIP Phone and E mail only offer formatting choices not the choices above When you create settings for a specific field you can save and reuse the Options Punctuation Options and Abbreviation Options settings Make your selections for a specific field and then use Make Default To use these settings on a different field select Use Default Any new fields setup will use these settings as well Note thatthe Field Type is not saved as part o
71. ou have the option to Yes Do the replace No Don t do the replace Cancel Stop processing Processing Mode Y ou can elect a different processing mode for the remaining records When the operation you selected is complete you will return to the Browse screen Tools Browse File Control Delete Records Record Range 8 l F Part of File Recwd Range Fern to Jo Fa Emassan Eua Tarda Espiesson Eua OT i X Cancel 7 Hslp Marks the records meeting specified criteria for deletion Records marked for deletion can be permanently removed by Packing Applies only to dBASE files All Mark for deletion all of the records in the database Part of File Delete only certain records e Record Range Delete only the records between the from and to range given To delete from a specific record to the end of a file specify 0 as the to record e For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder e While Records are counted until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax
72. p Data Check this box to set the default Backup Data processing option Maximum Speed Click this option to make Maximum S peed the default Processing Mode Adjust the slider to the right to set the default Maximum S peed Mode speed Scroll Click this option to make Scroll the default Processing Mode Adjust the slider to the right to set the default S croll Mode delay Code Page If you work with foreign data you may have to tell StyleList which character code page was used during data entry In North America the 1252 code page is by far the most common page and is the StyleList default It is important that you get this right you may have to talk to your customer because the code page used has a dramatic effect on casing For more information see http www microsoft com globaldev reference WinCP mspx When a database is chosen Don t open a setup sl with same name Click this option if you don t want StyleList to automatically open a setup file with the same name when opening a database Ask to open a setup with same name Click this option if you would like StyleList to ask to open a setup file with the same name when opening a database Automatically open a setup with same name Click this option if you want StyleList to automatically open a setup file with the same name when opening a database no asking D Style List Users Guide Tools User Settings Field Naming dit L escriptions For EN Add De
73. p to a new file name This allows you to slightly modify an existing setup without losing the old setup and without having to completely re enter a new setup Rename a Setup File Use Save Setup As This is a very useful tool if you want to make changes to an existing setup file without losing the original file Reuse a Setup 1 Open a setup file by selecting File Open Setup 2 Select Process 3 When StyleList finishes processing your file click Done to return to the main menu File Exit Exit StyleList If you don t want StyleList to ask you if you really want to quit visit Tools User Settings to turn it off 13 Setup Menu Setup Change Database Look in Er Ao del butant di arbol mamo did roski df File name Files of type Base B rdi Lancel Drive C statistics Total 9 5 GE Used 4 0 GB Free FG GE Allows you to use the currently selected setup on a different database Select the drive and folder that contains the file you want from the Look in list Then select the file from the display box Alternately you can type in the drive subdirectory filename in File name Click Open View Preview the currently highlighted file see File Viewer Import Pro Series only Import the currently highlighted file see ASCII Conversion Process Processing Screen Pira CNE StyleList peradons Praceszing Option Endin AS Til M Backup Data Display Mode HMarimumb5pee
74. pecify the file s path databasefile The name of the database file to use in processing If the database file is not in the working directory you must specify the file s path options P rocessing options S To set up a batch run T To test a batch run R To execute a batch run P To print a log file L To create an sl log file Note that with no options specifying setupfile will only open this file but will not begin processing until you choose to The switches are not case sensitive and can occur in any order can be used instead of Each switch must be separated by a space You can specify command line options in one of two ways 1 Creating a new shortcut Right click on the Desktop select New Shortcut For the command line enter the desired command line It is usually a good idea to specify the full path of the StyleList executable as well as the database and setup paths For example c Ns1Ns132 exe c job285 fallmail sl c job285 fallmail dbf would make StyleList automatically open the fallmail s setup file and the fallmail dbf database 2 Running StyleList from a DOS session From the Start Menu select command line Atthe DOS prompt change to the desired working directory and simply type the desired command line StyleList will be opened in a new window Long file names with spaces For example your setup file is called Monthly List S ust surround it with double quotes When using long file name
75. ppend Goto Locate Print Cleanup e OK X Cancel Help Structure of the Street Address Table SLStr dbf Field Type Len LOOKUP Character 24 ABBREV Character 24 CASETO Character 24 EXPAND Character 32 INSIG Character 1 INTENSE Character 1 Editing Either double click the desired field with your left mouse button or start typing when the desired field is highlighted Hit ENTER or the Arrow Keys to save changes ESC to cancel Note that hitting ENTER will keep you in a continuous editing state with the highlight moving one record down See Rules for Editing Lookup Tables at the beginning of this chapter 91 Style List Users Guide Tools Lookup Tables City Table lll Editing City Lookup Table Record 1 of 368 JO x GGRESS CASETO EXPAND Jin Ab R aLBuQUERd Ree OOO Mo H9 1 Bur eat pame BALTIMORE Bat eame f Bc J c Bc imho B ech Beach BEACH fen een BEND fea ped 1 T BF J ur T Append Goto Locate Prnt Cleanup e OK X Cancel Help This utility allows you to explore edit append new records and delete records in StyleLists City Table Structure of the City Table SLCity dbf Field Type Len LOOKUP Character 24 ABBREV Character 24 CASETO Character 24 EXPAND Character 32 INSIG Character 1 INT
76. r StyleList to use different Lookup Tables the new table must 1 Have the same name as the file it is replacing 2 Have the same field structure as the file it is replacing 3 Be putin the same directory as the file it is replacing Tools User Settings Use this screen to modify your preferences when using S ytleList BNET Nx Processing Settings M Endin ASCII General Settings ICT ves res On ee Cl Er Mts ET M Backup Data Shower Faster MP Display Tool T ips Fou a A Screen Saver behavior Dant suppress Screen Saver Suppress Screen Saver during processing Suppress Screen Saver whenever running StyleList Code Page edain When a database is chosen Dont open a setup Lall with same name Ask to open a setup with same name t Automatically load a setup with same name BM Confirm before exiting StyleList Field Naming Lookup Tables Browse Options A ok x Cancel Help Tools User Settings General Settings General Settiriqs M Display Tool Tips Screen 5 aver behavior Don t suppress Screen Saver Suppress Screen 5 aver during processing f Suppress Screen 5 aver whenever running StyleList ME Confirm before exiting StyleList ENTER Key behavior ENTER moves to next dialog prompt CTRL ENTER hits OK While traversing StyleList s dialog boxes hitting the ENTER key will proceed to the next prompt TAB moves to next dialog prompt
77. rd Range Process only the records between the from and to range given To process from a specific record to the end of a file specify 0 as the to record e For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder e While Records are recalled until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder When you press OK you will go to the Processing Mode screen Melissa Data has gone through several different iterations of methodology to determine leading and trailing spaces DOS users will remember the degree symbol and plaiditer systems With our Windows programs you just need to type in the phrase just as you would like it to be searched or replaced For example if you want to search for and with trailing and leading spaces enter it as and note the leading and trailing spaces The trailing space s won t appear unless you highlight the contents of the entry in the field hit SHIFT END If you are using a Searc
78. rights to this file i e read write append or create On a non networked computer this usually indicates that the file has been marked as read only Alternately this may indicate that you don t have enough disk space to create a file Setup File Errors Setup file errors can occur while attempting to open a setup file e Nota setup file The specified file is not a StyleList setup file e Setup file is corrupt The specified file looks like a StyleList setup file but has been corrupted somehow The only solution to this error is to re create the setup file Database File Errors Database file errors occur while attempting to access a dBASE file e Database is corrupt The specified file looks like a dBASE database but has been corrupted somehow This is usually an indication of a previous incident involving this database such as a computer hang or turning the computer off while the database is open There are some database repair programs available such as Filefix in Norton Utilities which may be able to save the database e Read error An unexpected error occurred while reading the specified file Try the operation again If the situation still persists call Melissa Data technical support e Write error An unexpected error occurred while writing to the specified file Try the operation again If the situation still persists call Melissa Data technical support 63 Style List Users Guide Limit error An unexpected error
79. rocess the records that are between the from and to range To process from a specific record all the way to the end of a file specify 0 as the to record e Filter The filter condition restricts processing to certain records In effect the filter prevents StyleList from seeing records which don t meet the condition Using a filter does slow processing slightly and it must be entered in dBASE syntax Instead of typing in a dBASE expression you can use the Expression Builder 16 Analyze Analyze Edit Before you process your file the Analyze screen enables you to manually check the results of processing before actually committing the changes in order to verify that no crucial data will be lost to truncation Y ou can also verify the results for any records where the data does not necessarily follow standard formatting rules Once you have defined an abbreviation field in Setup you can view that field in Analyze The records will appear in their original condition but you will have the ability to process one record ata time This can be useful if you have only a handful of records that need to be abbreviated The following menu will appear Analyze Field Which Held do you want ta analyze All of the fields that you processed will be listed here To analyze a particular field double click on it which will bring you to the following Curent Record Total Recods Truncaton s ESI ae Vowels n Truncate at
80. s favorite Comma and Tab are listed first First record contains field names Check this box to create a first record that contains field names so your export file will have one extra record Macintosh format CRs no LFs SDF and Delimited files only Check this box to delimit each record with a carriage return only Export records marked for deletion This allows you to export records that are marked for deletion to an ASCII file Of course they will no longer be marked for deletion once exported because there is no such thing in ASCII Tools Tools ASCII Conversion ASCII to DBF Interactive Importer TT a TM BALE ad ASCII Type SDF hania Field Mame Fl Field Size 30 Record Size 106 ie ds Field Type Character Field O Feet 0 Queenie Eserey 544 Edith O Heal 671 Helios Beach 25b Tanglevcod Turzatti Shall Dr Kristina Tearer 768 Rocker Y Enilio Railey _ amp calibogue Ca Chris Bragg 1 1 1 1 11 1 p782 Harimton Grasan 5 2703 Indian Spring Billy Mitoha HBAb Sposted Sandy lody Chrimtopber Jym ar Reaf 4 Smit Field Join Fieds E solude Field Clear Fields F Use first record for field names File Infa Field Info I ce X Cancel 7 Help i Split Field SDF and Flat File only You can split the highlighted field into two smaller fields by clicking this button The field will be split in half and then you can adjust the fie
81. s having spaces applications can get confused as to where one parameter stops and the next one begins Surrounding a parameter with quotes solves this problem This works on any 32 bit Windows program O O O O 0 Batch Processing You can run StyleList completely uninterrupted from a shortcut or DOS command line To let StyleList know that you want this special capability add one of these switches onto the end of the command line S To create the SL setup file T To test that the setup file will run when the time comes R To run the setup file P To print a log file L To create an sl log file As outlined above there are one or two ways to use these switches You can exploit the DOS session method even further by using a batch file just like in regular DOS The only caveat to this method is that you should check the Always Suspend option in the shortcut s property dialog box Why Take the following sample batch GsNdENdES2 Gi NWOEKNVELLe dbE Cr WWOPDKNIIlecdt 7r CGINSINSISZ2 GrINWO ZkNfile dbf GiNWOrDrKNIile sl Jf With Always Suspend checked the second line the StyleList line will not be executed until the first line is complete Without Always Suspend checked the second line executes moments after the first line is started Not a desirable situation when the input of the second line depends entirely on the successful completion of the first line 60 Reference On some systems the Always Suspend setting i
82. s not enough There are many script processing utilities that have addressed this problem and provide a solution For programmers there s another solution If you specify a log file using the L switch StyleList will create a file called s og when done processing You can use the presence of this file as an indication that itis okay to continue For example in Foxpro amp amp erase the log file erase d sl sl log amp amp launch StyleList batch run run drVyslwusl32 09xe6 diXslWNSldemo sl ZLhdi WXslXsl lrlog amp amp Loop until the flag file appears do warre Atile td sl sd Log inkey 1 enddo Wondering what the Inkey is there for Basically it releases control to Windows in 1 second intervals which will make your process run much faster Upper Lower Casing All upper lower case processing starts with what we call the General Caser With a few exceptions the General Caser lower cases every character in the field then capitalizes every character that is not preceded by an alphabetic The General Caser also strips any leading spaces and reduces multiple space gaps to a single space General Caser Examples Incoming StyleList Brand X O HARA O Hara O hara 3M CORP 3M CORP 3m Corp CHOATE SMYTHE Choate Smythe Choate smythe BABE RUTH Babe Ruth babe Ruth MCDONALD McDonald Mcdonald HAZEL ST EMORY BLVD Hazel St Emory Blvd Hazel St emory Blvd STRATFORD ON AVON Stratford on Avon Stratford On
83. scription Ax Existing Descrpeior Fiere Iova to Top Move to Bottom oo x Cancel 7 Heb When you select a field in setup StyleList tries to default to the correct Field Type for you By letting StyleList know about your field naming preferences you can set up a new job significantly faster Edit Descriptions for Select the data type you want to add naming description s to For example if you always name Prefix fields MR MS you ll want to select Prefix in this drop down box Add Description Enter a field name for this type of field You can use wildcards For example if you always name Prefix fields MR MS you ll want to put MR or MR_MS in this box When you have typed the information click Add to put it on the Existing Descriptions list If your database structures are fairly consistent it is usually better to not use wildcards and specify the entire field name For example if you specified CO to catch a field you usually call COMPANY StyleList can mistake CONTACT as a Company field as it fits the wildcard description Existing Descriptions This is a list of field names that indicates the currently selected type of field Remove Click this button to remove a highlighted description from the Existing Descriptions list Move to Top StyleList evaluates the Description List from the top down Therefore you can improve how well StyleList determines field names by putting the most common field descrip
84. tan 63 Gf oy sy maint pp nen rete an rae Ae en ore en tapeo 64 IB FUE WV AU TAI EE IUS 65 e strap ieee tinct A 67 yi Introduction StyleList converts your raw mailing lists into clean personal looking names and addresses Labels envelopes and letters look better more readable and are more apt to be opened Flexibility and Ease To maximize impact use StyleList to upper lower case expand abbreviations and add proper punctuation Or if your fields are too long for your labels StyleList gives you five different tools to shorten fields without truncating them Stylist is a smart program It auto StyleList is a smart program It automatically caps the 3rd letter of Mc names and knows how to deal with names that start with Mac It correctly cases apostrophes like O Hara postal abbreviations like NW and many other casing exceptions Features and Benefits e Makes bulk mail look more personal e Compresses or expands data in mailing list fields e Converts to upper lower case or vice versa e Expands or abbreviates words and phrases e Adds or strips punctuation e Improves deduplication efforts e Fast 10 20 million records hour What s New Company Casing By using a special 4 letter word table StyleList can now tell the difference between a word and an acronym Much Faster 4 times as fastas the DOS version 10 20 million records per hour Faster Setup Simplified setup screens expanded user defined defau
85. tex Jo Few Espesor Guita his Expasson Buiter E x Cancel 7 H lp Copy records fitting specified criteria to a new file When choosing this option you are prompted for an output directory and file name You are then prompted with the dialog box shown above All Copy all of the records in the database 24 Tools Part of File Copy only certain records Record Range Copies only the records between the from and to range given To copy from a specific record to the end of a file specify 0 as the to record For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder While Records are recalled until the while expression is no longer true Using a while expression does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dBASE syntax use the Expression Builder Tools Browse File Control Append Records Record Range 8 l f Part of File Raced Range Fins 1 to Jo Few Emassan Buin whi Espiasson Buitia E X Cancel 7 Halp Add re
86. the list Printer Which Windows printer to print to Consult your Windows documentation on how to add and remove printers or see your system admin Properties Displays the currently selected Printer Setup dialog box From this dialog box you can usually change settings such as Paper Orientation Paper Size and Print Quality This dialog is printer dependent so your mileage may vary Field Structure Print the database s structure Records Print the database s contents Header and Page Numbers P rint each page with a title indicating the name of the database along with a page number Record Numbers P recede each record printed with its record number Field Headings P rint field names at the top of each page Font Click to change the font used to print the records The default printing font is the same font used as the browser s display font All Prints all of the records in the database Part of File P rint only certain records e Record Range Print only the records between the from and to range given To print from a specific record to the end of a file specify 0 as the to record e For Setting a for condition restricts processing to just those records which meet the condition In effect the filter prevents the processor from seeing records which don t meet the condition Using a for condition does slow processing and it must be entered in dBASE syntax Instead of typing in a dBASE expression or if you re unfamiliar with dB
87. the structure of the current database to add new fields delete fields move fields resize fields and rename fields As always before modifying your database make a backup of your data Bytes per record including delete byte 04 Match Sizes in Setup Insert Delete Print Xx Cancel Help Note With the exception of renaming fields all structure changes require enough disk space to make a copy of the current database Match Sizes in Setup StyleList will automatically change the field lengths to match the abbreviated lengths you specified in your setup WHETHER YOU HAVE PROCESSED THE FILE OR NOT Insert Click to add a new field at the highlight s position or press CTRL N A size 10 Character field called NEW FIELD will be inserted which then can be modified as you wish Delete Click to delete an existing field at the highlight s position or press CTRL U Print Click to print the database s structure The structure that is printed is what s currently displayed on the screen which may or may not be the actual structure if you ve made changes 30 Tools Change Field Name Double click on the field name to be changed and type in the new name Field names must be between 1 and 10 characters The first character must be alphabetic but the others may be letters numbers or the underscore Embedded spaces are not allowed Change Field Type Double click on the field type to be changed and enter a new fie
88. tions at the top of the list The Move to Top button will move the highlighted description to the top of the Existing Descriptions list Move to Bottom Click this button to move the highlighted description to the bottom of the Existing Descriptions list 98 Help Help Help Topics This option takes you to StyleList Help s Table of Contents Help Keyword Search This option takes you to StyleList Help s Keyword Search Help How Do I This option takes you to StyleList Help s How Do I topic Help Using Help This option takes you to Windows Help on Help Help www MelissaData com This option takes you to Melissa Data s World Wide Web page This option is only available if you have a web browser installed Help About Clicking the S ystem Info button gives you information about what kind of computer you re using its environment and version information relating to some of the tools used to create StyleList 59 Reference Command Line Options Several of StyleList s options are available only from the command line Most of these options are used in hands off processing what we call batch processing while others can save you the time of selecting the same files every time you run StyleList The syntax for StyleList s command line is S132 setupfile databasefile options setupfile The name of the setup file to use in processing If the setup file is not in the working directory you must s

StyleList Reference Guide

Contents

Download Pdf Manuals

Related Search

Related Contents