How to find exact match for Table Filter's Free Text search

[Casey Maynard]

I found a page that lists some options, but I do not see a way to match exact

http://www.javascriptkit.com/javatutors/redev2.shtml

I have cells that have

One

OneTwo

One Three

And I only want the cell that has 'One' to be displayed.

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hi Casey,

Try this one:

^one$

Character '^' - is the start of string, '$' - is the end of string. 

[Casey Maynard]

Hmm what about "In R&D"? ^In R&D$ does not seem to find only the ones that say 'In R&D' only,  it displays zero results, (and I do have some that have In R&D as a value

Thanks

[Casey Maynard]

This issue may be related to the fact that my filter is trying to filter a row of cells excerpted another page.

Note: it seems any of those cells (even if they are not displayed on my current page will still produce results.

Here is the scenario I have a page1 with

Version - Release Date - Status - Project Code - Project Summary columns

One page2 I have filtering each one of those row/columns into their matching column with the same header (so that only 1 of the 5 cells displays in page2's corresponding cell

Frustrating complicated to use just so that I can map cells to another cell on a different page, but it is what I have to do without buying another add-on

[Andrey Khaneev _StiltSoft_]

Do you use Page Properties Report macro with pagination?

[Casey Maynard]

No.  I am not familiar with that macro.

[Casey Maynard]

That works.