Remove from string all latters

[Alvarion_Israel]

Hello,

How do i remove all letters from a string and leave only the numbers and dots.

for exsample:

if i have " SIZE(321..5666)siz " I only want (321..5666).

The letters will apear randomly so i can not use a splitter.

Thanks.

[TiTou]

Hello,

First, in the example string you gave : "SIZE(321..5666)siz" the string you want to extract is between "(" and ")", is it alwasy the case ? you can search for these tokens.

Otherwise, there are different thing you can do, I suggest you have a look at the detailed help for "match pattern" :



Another idea, use the ASCII table to separate numbers (48 to 57 plus 46 for the point) from other characters.

Hope this helps


Message Edited by TiTou on 12-17-2007 08:46 AM

[Rod42]

In the text you say that you want to remove everything that is a letter, leaving only numbers and dots, but your example leaves a pair of brackets () in too.

However both cases can be dealt with by using "Search and replace string" which you should right click and configure for regular expression.

Wire a true constant to "Replace all" and your input to "input string". Set the replace string to the empty string.

Now you need to set the search string to match everything you want to REMOVE

To remove everything that isn't a number, or a dot or a bracket use "[^\d.()]"

To remove all letters, keeping everything else, use "[A-Za-z]"

Foe full details, see the search and replace string help message, and follow the link to regular expressions.

Rod.

[Alvarion_Israel]

Thank !