I need to use a .CSV file for a lookup which has accented characters in the field values
If I save the file in ANSI mode, Splunk will complain it is not UTF:
[SimpleResultsTable module] Input is not proper UTF-8, indicate encoding !
If I save the file in UTF-8 mode or UNICODE, the lookup will not work:
# Error 'Could not find all of the specified lookup fields in the lookup table
These edits are being done in Notepad / Windows 😛
Convert your lookup to not have accented characters.
Is the splunk machine nix based? If so, try using dosutils.... dos2unix [filename] to convert to proper format.
Also try using notepad++ not notepad... never use notepad for ETL.