Unless the "rule" you want is based on a regex, which given the DW->DWnet requirement, it seems unlikely, then as you have found, an eval to create the desired domain name is simplest, but you can use a case statement | eval domain=case(domain="DW", "DWnet",
domain="WIC/UPnet", "WIC, UPnet",
domain="WIC/DWnet", "WIC, DWnet"
true(), domain) or if you have a lot of these, then a different solution is to create a lookup with all the possible variants and the form you want to see in the form domain_in, domain_out
DW,DWnet
WIC/UPnet,"WIC, UPnet"
WIC/DWnet,"WIC, DWnet" and then in the SPL do | lookup my_lookup domain_in as domain OUTPUT domain_out
| eval domain=coalesce(domain_out, domain) which means you only have to put the different variants in the lookup, as the coalesce will then take the found form in the lookup (domain_out) and use that if present. Note that if using a CSV, make sure you use quotes for the values that have commas in them
... View more