Find all instances of .0%

[foxtrot]

I'm trying to find all instances of .0%, ignoring anything in front of the decimal, from a mix of numbers that might look like this:



7.0%
.0%
0.0%
94.0%

In the above list, it should only find one instance: the .0%

Any suggestions for how to wildcard the find expression?

I started with [!0.].0% which effectively ignores the 0.0%, but catches everything else. I tried something like [!0.-9.].0% but that ignores everything.

Ideas?

[macropod]

You could use:
Find = [!0-9].[0-9]%
Note that this finds the non-numeric character before the .0% as well. So, if the aim is to delete the .0%, you'd use:
Find = ([!0-9]).[0-9]%
Replace = \1

[foxtrot]

Originally Posted by macropod

You could use:
Find = [!0-9].[0-9]%
Note that this finds the non-numeric character before the .0% as well. So, if the aim is to delete the .0%, you'd use:
Find = ([!0-9]).[0-9]%
Replace = \1

That doesn't find anything. For example, if you list in Word those four sample values I provided and do a find for [!0-9].[0-9]% it says "... The search item was not found."

[macropod]

Did you check the 'Use wildcards' option?

[foxtrot]

Originally Posted by macropod

Did you check the 'Use wildcards' option?

Yes.

I'm using Word 2010.

[macropod]

And are these numbers just in the ordinary text of the document, or are they in table cells?

[foxtrot]

Originally Posted by macropod

And are these numbers just in the ordinary text of the document, or are they in table cells?

They are in table cells, but I also tested the find logic on a blank word document with just these four plain text values (no formatting, no table, etc.) and it didn't find any of them:

7.0%
.0%
0.0%
94.0%

[macropod]

Originally Posted by foxtrot

They are in table cells

It would have been helpful if you'd said so at the outset. On its own, the process won't work in tables. You could, however, use a series of wildcard Find/Replace expressions, where:
Find = .[0-9]%
Replace = ^s^&
Find = ([0-9])^s(.[0-9]%)
Replace = \1\2
This will now leave you with the .0%s with a non-breaking space before them, so you can then do a wildcard Find for just those, with:
Find = ^s.[0-9]%

I also tested the find logic on a blank word document with just these four plain text values (no formatting, no table, etc.) and it didn't find any of them

I tested the [!0-9].[0-9]% wildcard Find expression in an ordinary document before I posted it. It worked then and it still does.

[foxtrot]

Originally Posted by macropod

It would have been helpful if you'd said so at the outset. On its own, the process won't work in tables. You could, however, use a series of wildcard Find/Replace expressions, where:
Find = .[0-9]%
Replace = ^s^&
Find = ([0-9])^s(.[0-9]%)
Replace = \1\2
This will now leave you with the .0%s with a non-breaking space before them, so you can then do a wildcard Find for just those, with:
Find = ^s.[0-9]%

I tested the [!0-9].[0-9]% wildcard Find expression in an ordinary document before I posted it. It worked then and it still does.

Just wanted to follow up and say both approaches worked and thank you. I didn't point out the table issue because I thought I ruled that out as an issue. For some reason, the [!0-9].[0-9]% wildcard for non-table data didn't work on my PC at work but did work on my PC at home, even though both PCs use Word 2010. Still can't figure out what's causing that.

But thank you again for your help.