Home | Tips | Library | Other Authors | Other WP Sites | Writer's Links | Contact | Site Map | Donate

Barry MacDonnell's
Toolbox for WordPerfect
 

Macros, tips, and templates for Corel® WordPerfect® for Windows®
© Copyright 1996-2017 by Barry MacDonnell. All Rights Reserved.

Page updated Feb 10, 2017

Column searcher (for WordPerfect tables)

Download COLSRCHR.ZIP (Rev. 02/10/17; 17,700 bytes)

Compatible with WordPerfect 9 and later versions

WordPerfect 11 users: See important information about using macros in the first release of WP11 (11.0.0.233) at the top of this page.

Downloading, Documentation, Modifications, and Support


Other pages on this site related to WordPerfect tables:

•  Using WordPerfect tables (many tips and links)

•  Table gridlines, table borders, table guidelines - what they do and how they work. Why you might not see borders around cells on your screen, or see "reverse text" (white text on a dark cell background) in a table, etc.

•  Rotate table cell contents either 90, 180, or 270 degrees (or "skew" the contents at an angle).

Other macros:

•  Brackets - A macro that creates an "outdented" table -- i.e., a table that extends slightly outside page margins -- with a large, full-height left and/or right border that simulates a large square bracket ("[" and/or "]"); the result can also be "indented"
 
•  Calendars
- Macros to create monthly or annual calendars using tables

•  DeleteRC - Deletes empty rows and/or columns in the current table

•  QwikFill - A macro that adds incrementing numbers (1..n) in the current table column from the current cell to the bottom of the column, in a manner similar to WordPerfect's QuickFill feature -- but easier and with more options

•  RowLines - Adds underlines and/or fills (shading) to every Nth row in a table for added readability or improved appearance

•  TableSrchr - Similar to the Column search - color rows macro but searches the entire table from the first cell to the last cell.





Contains two macros:

Column searcher.wcm (v1.02) - A macro that finds text or symbols in just the current column of a table -- it will skip searching any other table columns. You can also replace any items found from a small pop up dialog.
Tips etc.

☼  To search and/or replace anywhere in a table, you don't need a macro: Just use WordPerfect's Edit, Find and Replace. This macro searches just the column the cursor is in.

☼  You can force the macro to start searching at the top of a specific column (rather than the current column) by replacing the PosTableColumnTop command at about line 46 with, for example, PosTableCell ("B1"). The latter command would force the macro to search the second column of the current table. (Macros can be opened like any other WordPerfect document. Make your changes and click the Save & Compile button on the macro toolbar.
The code or technique might be useful in other macros.

☼ 
See TableSrchr for a similar macro -- but that searches in the entire table rather than just in the current column.

Column search - color rows.wcm (v1.01, for WordPerfect 9 and later versions) - Based on code in the above macro, this macro finds user-specified text in just the current column of a WordPerfect table (it will skip searching any other column). It then colors any row that contains the item specified in a pop-up dialog with a specified color "fill" (the default is light green, but this can be changed).

See the redlined User Modification Area at the top of the macro's code to set your preferences. (Macros can be opened like any other WordPerfect document. Make your changes and click the Save & Compile button on the macro toolbar.)

Tips
etc.

☼  You can make several copies of this macro, each with a slightly different name and different default values for color, etc. See the User Modification Area.

☼  You can redact (i.e., black out) rows for printing purposes (the underlying data is unaffected) by setting all three RGB color values to 0 (zero) and the shade to 100 percent, in the User Modification Area.


Related tip

A macro posted by Roy "lemoto" Lewis on WordPerfect Universe removes any row which does not contain a specified string of characters (here, for example, the string is "DAB"). Perhaps the code will be useful to use as a starting point for similar tasks.

BE SURE to also indicate the specific table and cell in your own document in the PosTableCell() command below, which is set (for this example) for Table C, Cell C1.

// Macro begins here)

vCheckText = "DAB"
PosTableCell("Table C.C1")
While(NOT ?TableLastCell)
    SelectWord
    RowOut
    PosTableCellDown ()
EndWhile

SelectWord

RowOut:
If(StrPos(?SelectedText; vCheckText) =0)
TableDeleteRow
PosTableCellUp
EndIf
SelectMode(Off!)
Return

// Macro ends here