How to modify the results in required format?

[pavanae]

I have a lookup query as follows

| inputlookup hosts.csv | rename hostname as my_hostname | table my_hostname

the results are follows

abcd
abcf.sjs.com
GHK
ghli.sjd.com

How can I modify my query to display the results in the below format for the above results

abcd
abcf
GHK
ghli

I want to remove the letters after dot in the results and just want to display the words like above

[cmerriman · Accepted solution]

try adding this to the end:

|rex mode=sed field=my_hostname "s/\..*//g"