I'm trying to use the Filter in a custom function to only allow alpha numeric characters along with the space character. It works fine for all of the alpha numeric characters but it is still filtering out the spaces (which I want to keep).

This is what I am using:

Filter ( fp_input ; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwzyz0123456789., -" )

Is there something that I am missing?

Edited August 4, 200817 yr by Guest

I see no space in that string. Hmmm, I see:

w zyz0

Is that where the space is? Because space DOES work within Filter().

Edited August 4, 200817 yr by Guest

Hmm, the spot where you thought was a space was actually the letter X and x and the space was found after the -.

I did a direct copy right from the custom functions window. I tried it again after modifying the data in the original field and sure enough the space worked.

What I am doing is taking an existing system that I don't want to disturb and creating new fields that were calculation fields that called the custom function.

I think my problem is solved, thank you.

When I originally set up the custom function, I had missed including the space character in the filter. When I added it, it didn't seem to make a difference. However when I deleted the calculation field that was calling the custom function and recreated it, it worked fine.

Strange but I am now working.

Edited August 5, 200817 yr by Guest

When I added it, it didn't seem to make a difference.

I would suspect you had it set as an indexed calculation and, since the CF changed but no FIELDS within the calculation changed, your calculation didn't know the CF was changed and thus couldn't update.

Well ... at least that's my story and I'm stickin' to it. :grad: