RexEx in Methods

[Justin Drury]

Hello everyone, here is what i'm trying to do.

I have a string field 'FieldName' that contains string like
'test_string'
'test.string'

I want to create a method field that is indexed by words but it appears that the characters _ and . (and others) aren't used as word breaks.

So i thought I'd create a regex expression for the method text

FieldName regex '[_.@]' and perhaps replace all occurrences with a space.

This doesn't seem possible

short of doing
replace(replace(replace(FieldName,'_',' '),'.',' '),'@',' ') for every character I want to replace, is there any other way of doing what i'm trying to accomplish?

Thanks!

Justin