Remove numbers form a word

[Nils van de Loo]

Hello all

Can somebody help me to make a script that removes numbers form a word.

I have a database with news articles and a field that contends the news category. The problem is that add the category word there is number.

For example:Spo12 ski127 wee89

There is no pattern in the numbers some times there are

2 numbers and than it have 3 or 4 numbers.

So is it possible to make a script that deletes the numbers for the words.

Configuration: Filemaker 7.0 Macos X 10.3

Suggestions or help would be greatly appreciated.

Thanks,

Nils

[DanBrill]

Use the substitute function and substitute "" for 0, "" for 1, ... "" for 9. That should do it.

[MoonShadow]

You can also use Filter(yourfield; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz ")

Even though it appears a bit longer, I think it is more efficient than Substitute(); even though you no longer need to nest Substitute() in 7. Filter is in vs. 7 only.