Removal of unnecessary fields

[kumar518g]

Hi ,
I have to remove some chars from the extracted field "UserName" values like below

ValidateCcoId - svorma1
ValidateCcoId - pauschool
i have to remove those "ValidateCcoId - " from those values please help me.

Regards
Ravi

[MHibbin]

You should look at the rex command... something like this should do it...

<yoursearch> | rex field="UserName" "\w+\s+\-\s+(?P<UserName>\w+)"

Hope this helps

[yannK]

same thing with a sed

<yoursearch> | rex mode=sed field="UserName" "s/ValidateCcoId - //g"