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
Like this (as I said in other answer):
... | rex field=Host_Name mode=sed "s/\.[^.]*$//"