You might be able to adapt something like the following:
search-goes-here | eval OSGroup=case(match(OSName,"Microsoft Windows 7(.*)"),"Windows Client", match(OSName,"Microsoft Windows 8(.*)"),"Windows Client",match(OSName,"Microsoft Windows Server(.*)"),"Windows Server")
The second argument to each match function is a regex, and the case statement lets you line up your matches with your output values.
While you can't put these in CSV files, you can turn the eval clause into a macro (add it to macros.conf ) and refer to it wherever you need it.
... View more