Home Concordance-U

Concordance®/Opticon HELP!


CPL FAQs CPL Admin CPL Editing CPL Searching CPL Import Export CPL Printing CPL Opticon CPL Depositions CPL 3rd Party CPL Misc Master CPL List


Follow concordancehelp on Twitter

CPL Editing Programs


Update: As of Concordance 2007, and especially Concordance 10, some CPLs listed here may not work correctly. Especially any CPLs involving working with Tags. Also, please be aware LexisNexis Concordance has released a new set of CPLs specifically geared towards working with Concordance 10. I hope to get those posted soon. - 05/31/2009 Bob Meyers


address_conversion.cpl Removes internal routing information from TO and FROM address lines in an e-mail database; such routing address information displays as "". This CPL removes all information between angle brackets.

ALPHATIZ.CPL Sorts all line entries in any multi-entry database field, in alpha-numeric order. User selects the field.

AppendOneFieldToAnother.cpl Easily copy contents of Field A into Field B, before or after any data already in Field B.

AppendOneFieldToAnother_no_semicolon.cpl Same as above, but this version does not insert the semi-colon between new and existing data; perfect for populating an empty field.

AppendTextToField.CPL Easily append or prepend new data to existing data in a field. Sort of like Global Edit, except no "target" is required.

AUTONMBR.CPL Assigns unique alphanumeric serial numbers to user-specified field. For more control over format, use Renumber.CPL.

BLANKFLD.CPL Sets the specified field to blank. The name of the field you want to blank must be specified on line 8 of the CPL. Use Concordance CPL Editor ("File | Edit") to update the CPL. Note: This CPL is destructive. Please back up your database before use.

Capitalize.cpl Captalizes text in a user-specified field. CPL must be edited to include your fieldname. (See Upper.cpl and Lower.cpl)

capitalizep&t.cpl Capitalizes text (initial caps) in all paragraph and text fields. (See Upperp&t.cpl and Lowerp&t.cpl)

capital_p.cpl Capitalizes text in all paragraph fields, leaving text fields unaffected.

DateValidation.cpl This program checks the current query for valid dates. (Dates with all zeros for either the year, month, or day are considered valid.) Any invalid dates, such as February 30th, are tagged with the phrase "Invalid date in FIELD".

Delete.cpl Delete.cpl has been superceded by the "Delete/Undelete" function in v6.5 and higher. To mark an extended range of documents for deletion. The 16-bit Concordance interface allowed only one document at a time to be marked for deletion from Edit mode.

Delete_text_between_brackets. cpl Removes internal routing information from TO and FROM address lines in an e-mail database; such routing address information displays as "". This CPL removes all information between angle brackets.

Display file names only.cpl Trims path and UUID strings from E-mail attachment field, retaining original filename and link. Make for a much more compact and easy-to-read attachment link.

Field2Tag.cpl Creates tag from the entries in a user-selectable field. Multiple values are supported. This CPL must be manually edited to specify the field name and the delimiter.

Find duplicate names in a field.cpl Tags documents with duplicate names within a specifield field. The CPL assumes the names are separated by a semi-colons, but the punctuation can be changed in the script.

Find-duplicate-names-between-two-fields.cpl Tags documents with duplicate names between two specifield fields. The CPL assumes the names are separated by a semi-colons, but the punctuation can be changed in the script.

Issue2Field.cpl Writes issue tag names to a user-selectable field in the database. Multiple issue tags are supported.

issue2tag.cpl Converts issue tags to document level tags. Helpful when users have attempted to add document tags while text was highlighted in "Browse" mode.

lower.cpl Lowercases text in a user-specified field. CPL must be edited to include your fieldname. (See Upper.cpl and Capitalize.cpl)

Lowerp&t.cpl Lowercases text in all paragraph and text fields. (See Upperp&t.cpl and Capitalizep&t.cpl)

Note2Field.cpl Writes notes created with the Concordance "Annotation Editor" to a field in the database.

Pages_per_doc.CPL Writes the number of pages to a text field in every record in the current query. User selects the begin document number and end document number fields.

Renumber.cpl Handy renumbering utility. Assigns sequential alphanumeric serial numbers in user-specified field, in current query. This CPL lets the user specify the alpha-prefix and starting number of the serial number.

reset formatting(all paragraphs).CPL Removes Rich Text formatting (font sizes, color, bolding, etc) from all paragraph fields for all records in the current query.

Reset formatting(specific field).cpl Removes Rich Text formatting (font sizes, color, bolding, etc) from a specific paragraph field for all records in the current query. The fieldname must be specified on lines 10-11 of the CPL.

Spell(noquery).cpl Like the standard SPELL.CPL program, but this "no query" version always checks the entire database regardless of the current query.

Spell.cpl Spell-checker utility. Zipped with required Mark.CPL sub-program. Spell.CPL checks words in your database against known correct spellings in the Words.LST file, a dictionary of US English words. Unknown new words which are spelled correctly but not found in Words.LST (such as names) are appended to a DATABASE.SPL file (where DATABASE is the name of the current database you're are spell-checking). This database.SPL file of new approved words can later be merged back into the Words.LST file or other database.SPL files through use of List File Management ("Tools | List File Management"). That way each new database doesn't hang up on words you've already OK'ed.

Srchrepl.cpl This program executes multiple searches and replaces at one time in Concordance. Requires an input file where the search terms and replacement terms are separated by commas. In other words, your input file should look like this: A,X B,Y C,Z and srchrepl.cpl will replace all "A"'s with "X"'s, all "B"'s with "Y"'s, and all "C"'s with "Z"'s.

Tag docs with issues.cpl Converts issue tags to document tags. Used when documents have been inadvertently issue tagged and users intended to apply document tags.

Tag2Field.cpl Writes tag names to a user-selectable field in the database. Multiple tags are supported.

Text_Date_to_Date_Field.cpl Copies text-string dates formatted as MM/DD/YYYY out of a Text/Paragraph field and into a Date field. See also Txt2date.cpl

Trim.cpl Trims all leading/trailing blank spaces (spaces, tabs, carriage returns) in all Paragraph fields.

Txt2date.cpl Copies text-string dates formatted as MM/DD/YYYY out of a Text/Paragraph field and into a Date field.

Upper.cpl Uppercases text in a user-specified field. CPL must be edited to include your fieldname. (See Lower.cpl and Capitalize.cpl)

Upperp&t.cpl Uppercases text in all paragraph and text fields. (See Lowerp&t.cpl and Capitalizep&t.cpl)

Upper_p.cpl Upper cases text in all paragraph fields, leaving text fields unaffected.

Zerofill.cpl Zero-pads Bates numbers. E.g., ABC0123 can be padded to ABC000123, etc.

Copyright © 2010 Bob Meyers

Any questions on anything at all, please feel free to contact me directly: bobmeyers@concordancehelp.com

Or give me a call: +1 (424) 35-HELPU (424-354-3578)

Back Home Up Next