Regex to remove all the special charater from date and convert it as a string

[JyotiP]

I have a variable temp = 2019/19/09_04:02:49:344 and I want to remove all the special character from it like 20191909040249344.

[jpolvino · Accepted solution]

Rather than list every possible special character, another way is to exclude characters that are non-digits:

| makeresults 
| eval temp="2019/19/09_04:02:49:344"
| rex mode=sed field=temp "s/[\D]+//g"

[harsmarvania57]

Hi,

If you want to remove special character during search time, you can try below search. In below example I am assuming that you have time in temp field

<yourBaseSearch>
| rex mode=sed field=temp "s/[_!@#$%^&*(),.?\":{}|<>\/\\\\]//g"

[xaratos]

Like every special character? So that you have 20191909040249344?

[JyotiP]

@xaratos yeah, every special character

[xaratos]

https://stackoverflow.com/questions/3303420/regex-to-remove-all-special-characters-from-string
Would that help you?