Can me make changes in csv file which is in splunk

[vrmandadi]

Hello,

I have a csv file and I am comparing that csv file with my search and get unique results but the problem with the csv file is that it has extensions

example:

my csv file has hostname with .abc.int or .auther.inc ,i just want to remove these extensions in the csv ,can we do that.that will make easy to compare with my search which has hostname

example

host_name(csv)

s4000cawv.abc.int
achaesdb01.auther.inc

host_name

s4000cawv
achaesdb01

[woodcock]

Like this (as I said in other answer):

... | rex field=Host_Name mode=sed "s/\.[^.]*$//"