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

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

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.