How to delete unwanted special characters in alphanumeric string?

[ravimmm]

I have a string as below, I need to delete the below special character and make the below as a single value.

123asdsd-123j;123gasds-1234iujh  , with this create a new field value as 123asdsd123j123gasds1234iujh ( no special characters)

Thanks
RK

[wmyersas]

The simplest route I know is:

| eval field=replace(field,"[^[:word:]]","")

This will replace all non-word characters (ie [0-9a-zA-Z]) with blank ("")

Or:

| eval field=replace(field,"\W","")

\W is any non-word character, too

[jacobpevans]

Definitely simpler!

Also, I didn't know about /W somehow! Thank you!

[wmyersas]

you're welcome 🙂

[jacobpevans · Accepted solution]

Greetings @ravimmm,

This is the laziest way I can think to do it. I'm sure there's a slightly better way.

| makeresults
| eval test = "123asdsd-123j;123gasds-1234iujh"
| rex field=test max_match=0 "(?<test>\w+)"
| eval test = mvjoin (test, "")

If that doesn't work perfectly for you, you can change \w to be whatever characters you don't want, e.g. [^-;_]

Cheers,
Jacob

[wmyersas]

There is an easier way 🙂

https://answers.splunk.com/answering/776189/view.html

[ravimmm]

Thank you that works , I was looking to regex using [^-;] the whole string without using MAX_MATCH .