Calculation help needed

[deego55]

hi-

I have an urgent need for some calculation help. I have a book title field in my records. I need to create a calulation field that removes all the spaces and puncuation in the titles and combines all the words. For instance, I have a title of:

U.S. Communication services market : overview and future outlook.

NEED CONVERTED TO:

USCommunicationservicesmarketoverviewandfutureoutlook

Is this possible? I need it to function the same no matter what the title or punctuation.

[-Queue-]

How about Filter( titlefield; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789" ) ?

[deego55]

Hmm... Ive never used the filter method. I'll try that.

I did do the following calculation and it worked well. Is this an ugly solution?

Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(TI;

"("; ""); ")"; ""); "."; ""); "-"; ""); " "; ""); "/"; ""); ":" ; ""); "^A" ; ""); "?" ; ""); ";" ; ""); "," ; "")

[-Queue-]

In version 7, yes. Substitutes can be combined in 7.

Substitute( TI; ["("; ""]; [")"; ""]; ["."; ""]; ["-"; ""]; [" "; ""]; ["/"; ""]; [":"; ""]; ["^A"; ""]; ["?"; ""]; [";"; ""]; [","; ""] )

I think Filter would still be faster.

What is the ^A for though?