Need script to search and apply style to rows with specific text

Hi @Jeff37144906ge0e I'll add my version as well as @brian_p_dts's excellent script, just because it is more learning for you, and also it is a more general script: for example you can configure it to accept any sort of object, eg. document, selection, or anything.

You can try the script with the attached demo.indd but, to use it yourself, you need to edit the `customizeMe` function. This is where you configure the code to do what you want. There is no error checking here currently so if, for example, a cell style is missing it will throw an error.

In my example cusomizeMe function we search for 'foo' and 'bar' and set the cell styles accordingly, and also search for 'foobar' and set the whole row's cell styles. I'm using strings here for searching, but as @brian_p_dts mentioned, using RegExp can do more complex matching and you can just swap them eg. to find 'foo' at the start of the cell, then instead of 'foo' you can use /^foo/.

Let me know if you want any further explanation or if you try the script and something doesn't work right.

- Mark

/**
 * @file Set Cell Styles.js
 * Searches for text in table cells
 * and sets cell styles accordingly.
 * @author m1b
 * @discussion https://community.adobe.com/t5/indesign-discussions/need-script-to-search-and-apply-style-to-rows-with-specific-text/m-p/14595514
 */
function main() {

    if (0 === app.documents.length)
        return alert('Please open a document and try again.');

    var doc = app.activeDocument,
        counter = 0;

    // apply to whole document
    var target = doc;

    // or, apply to selection only
    // var target = doc.selection;

    // execute customize me for each cell in target
    doSomethingToThings(getCells(target), customizeMe);

    /**
     * Set cell style based on text found in cell contents.
     * Configure this to suit your needs
     * @param {Cell} cell - an Indesign Table Cell.
     */
    function customizeMe(cell) {

        // counter is just for reporting at end
        counter++;

        if (-1 !== cell.contents.search('foobar')) {
            // example to set the whole row style
            cell.parentRow.cells.everyItem().appliedCellStyle = 'My Row Style'
        }

        else if (-1 !== cell.contents.search('foo'))
            cell.appliedCellStyle = 'My Cell Style 1'

        else if (-1 !== cell.contents.search('bar'))
            cell.appliedCellStyle = 'My Cell Style 2'

        else
            counter--;

    };

    // show results
    alert('Set ' + counter + ' cell styles.');

};
app.doScript(main, ScriptLanguage.JAVASCRIPT, undefined, UndoModes.ENTIRE_SCRIPT, 'Set Cell Styles');


/**
 * Performs function `doThisTo` on each element of `things`.
 * @param {Array<*>} things - array of things.
 * @param {Function} doThisTo - the function to execute, given a thing.
 */
function doSomethingToThings(things, doThisTo) {

    for (var i = things.length - 1; i >= 0; i--)
        doThisTo(things[i]);

};

/**
 * Returns a thing with matching property.
 * @param {Array|collection} things - the things to look through, eg. PageItems.
 * @param {String} key - the property name, eg. 'name'.
 * @param {*} value - the value to match.
 * @returns {*} - the thing.
 */
function getThing(things, key, value) {

    for (var i = 0; i < things.length; i++)
        if (things[i][key] == value)
            return things[i];

};

/**
 * Returns array of cells, given an object.
 * @author m1b
 * @version 2024-05-03
 * @param {*} obj - an object, can be an array, eg. a document selection.
 * @returns {Array<Cell>}
 */
function getCells(obj) {

    var cells = [];

    if (obj == undefined)
        return [];

    else if ('Array' === obj.constructor.name)
        for (var i = 0; i < obj.length; i++)
            cells = cells.concat(getCells(obj[i]));

    else if ('Document' === obj.constructor.name)
        cells = getCells(getThingsFromDocument(obj, 'stories'));

    else if (
        obj.hasOwnProperty('cells')
        && obj.cells.length > 0
    )
        cells = obj.cells.everyItem().getElements();

    else if (
        obj.hasOwnProperty('tables')
        && obj.tables.length > 0
    )
        cells = getCells(obj.tables.everyItem().cells.everyItem().getElements())

    else if ('Cell' === obj.constructor.name)
        cells = [obj];

    else if (
        obj.hasOwnProperty('parent')
        && 'Cell' === obj.parent.constructor.name
    )
        cells = getCells(obj.parent.parent);

    else if ('Table' === obj.constructor.name)
        cells = obj.cells.everyItem().getElements();

    return cells;

};

/**
 * Returns array of things found in `doc`.
 * `thingPlural` is a Document property name,
 * for example 'formFields' or 'swatches'.
 * @author m1b
 * @version 2024-05-03
 * @param {Document} doc - an Indesign Document.
 * @param {String} thingPlural - collective property of Document eg. 'checkBoxes'.
 * @returns {?Array<*>} - the things.
 */
function getThingsFromDocument(doc, thingPlural) {

    if (
        !doc.hasOwnProperty(thingPlural)
        || 'function' !== typeof doc[thingPlural].everyItem
    )
        return;

    var things = doc[thingPlural].everyItem().getElements();

    if (
        doc.hasOwnProperty('groups')
        && doc.groups.length > 0
        && doc.groups[0].hasOwnProperty(thingPlural)
    )
        // also collect things in groups
        things = things.concat(doc.groups.everyItem()[thingPlural].everyItem().getElements());

    if (
        doc.hasOwnProperty('stories')
        && doc.stories.length > 0
        && doc.stories[0].hasOwnProperty(thingPlural)
    ) {

        // also collect any anchored things
        things = things.concat(doc.stories.everyItem()[thingPlural].everyItem().getElements());

        if (doc.stories.everyItem().tables.length > 0)
            // also collect any thing in tables
            things = things.concat(doc.stories.everyItem().tables.everyItem().cells.everyItem()[thingPlural].everyItem().getElements());
    }

    return things;

};