[SOLVED] Macro/Wildcard to remove only numbers excluding text with numbers

[indianhp]

Hi Team,

I am stuck with one wild card

There is one wild card which removes numbers from document ^# but it removes numbers also which have text with it.

I want wildcard or macro which removes only standalone numbers not numbers with text

Ex:

if its number like 1.00.111 or 1,00,000 then it should be removed

but if numbers are like interest 10% then it should not be removed.

I have added an example doc for the same

[István Hirsch]

Insert this code into a module, at Tools/References check Microsoft VBScript Regular Expressions 5.5, and use this in the next column as a User Defined Function:

Please Login or Register  to view this content.

[indianhp]

Hi Istvan,

Can i have same functionalty for word also?... or can i use it in word also...

[István Hirsch]

Hi indianhp,

In Word I would do this:

Select the table, go to Table/Convert/Convert Table to Text, choose paragraph marks as the delimiter.
Then go to Edit/Find and Replace, check Wildcard (or sth like this) checkbox and:

Find: (^13[0-9.,]{1;})
Replace with: ^p

Because of the different country settings, in the Find box you may have to use comma, instead of semicolon in the curly brackets.

Select the text, go to Table/Convert/Convert Table to Text, choose 1 (number of columns) and paragraph marks (delimiter).

Hope this works for you too.

[indianhp]

Hi Istvan,

Its working great on text part but most of the time i have data in tables. Which needs to be processed in such way... So can it updated to use it on tables and text portion both..???

Other wise its works great for me. But if its works on table it will be much greater for me.

[István Hirsch]

Hi indianhp,

If the table in Word should be processed as table, I do not know a way to delete selectively the number-only lines. That is why I suggested a workaround where the table is converted to text > the necessary changes performed > then the changed text is converted back to table, with the goal achieved. This link proposes similar method to process tables in Word with a regex:

http://office.microsoft.com/en-us/wo...001087304.aspx

[indianhp]

Hi Istvan,

Anyways its working fine in running text... Its good for me. Thanks for support.