Substitute function with multiple (nesting) substitutions

[pdbe]

I have a calculated field which I want to be the field 'Title' with all occurrences of some characters (spaces, apostrophes, commas etc.) removed.

This has worked fine when only substituting one character but I cannot make it work when I want to remove more than one character.

I have tried:

Lower ( Substitute ( LeftWords( Title ; 3 ) ; [" ";"_"] ; ["'";""] ))

>ERROR: 'Field cannot be found'

and nesting:

Lower( Substitute ( Substitute( LeftWords( Title , 3 ) , "_" , "" ) ) , "'" , "" )

> ERROR 'Too few seperators'

Neither works. What am I doing wrong?

Thanks for your help

[Søren Dyhr]

I can se you're using FM7'ish syntax but your profile talks of server 5?

--sd

[pdbe]

I am using FM6 with Server 5.5

[comment]

Try

Lower (

Substitute ( Substitute (

LeftWords ( Title , 3 ) ,

"_" , "" ) ,

"'" , "" )

)

[pdbe]

Thanks that's it