Thanks David

I’ll take a look at that and see if it will work with what I’m trying to achieve.

Hey that’s great. I’ve tweak the GREP a little so what is selected is more exact.

var
textInCell=[‘Corporate’, ‘Scotland’, ‘South West’, ‘London South & South East’, ‘Powered Access’, ‘Rail’, ‘Traffic’, ‘Leada Acrow’, ‘PSS Hire’, ‘FLG Services’, ‘Health & Safety & Training’];
var myRegEx = new RegExp(“^(“+textInCell.join(“|”)+”)$”);
for (i=0; i<table.cells.length; i++)
{
if (table.cells[i].texts[0].contents.match(myRegEx))
table.cells[i].appliedCellStyle = “District Cell”;
}

I’ve got one other element to add in to my table formatting. I want to find a cell with the word ‘Budget’ (but this may be written as ‘Budget:’ or ‘Budget: (E)’ – but without the speech marks) and apply the Cell Style – SponsorCellStyle – to the whole row. I’ve currently got this going on, but it isn’t working:

//Find Text in Cell and apply Cell Style to Row
for (i=0; i<table.cells.length; i++)
{
if (table.cells[i].texts[0].contents == “Budget:”)
table.rows.everyItem().appliedCellStyle= “Sponsor/Owner Cells”;
}

Could you possibly help with this last bit?

I’ve kind of solved this. 2 lines of code, that could perhaps be written a little better, i’m not the best at writting code.

app.activeDocument.links.everyItem().unlink()
app.activeDocument.links.everyItem().unembed()

The first line of the above will unlink every item. This removes the ‘Place and Link’ content but it embedding other images. The second line will then unembed these images returning them to how they were.

Just to add, the “Z” part does actually have 2 backslashes in my txt file, the forum post has remove 1 backslash.