How to remove special characters from field values

[iamsplunker]

Hi Splunkers, 

1) I wanted to remove all special characters from my field called "Test" other than "."(dot) and "-"(dash)
2) return the values in lower case.

example field values for Test
i4455.mango.com
qa (qa_a_ai_bi1_integration_d01)
app-9999-bee-mysql-prod

please help

[PickleRick]

There might be a better idea, but for example - like this (run-anywhere example).

| makeresults 
| eval test="qa (qa_a_ai_bi1_integra.tio-n_d01)"
| table test
| rex mode=sed field=test "s/[^-A-Za-z0-9.]//g"

[ITWhisperer]

Try something like this

| rex mode=sed field=Test "s/[^0-9a-zA-Z\.\-]//g"
| eval Test=lower(Test)