topic using UTF-8 files for CSV lookup in Splunk Search https://community.splunk.com/t5/Splunk-Search/using-UTF-8-files-for-CSV-lookup/m-p/47027#M11232 <P>I need to use a .CSV file for a lookup which has accented characters in the field values</P> <P>If I save the file in ANSI mode, Splunk will complain it is not UTF:</P> <PRE><CODE>[SimpleResultsTable module] Input is not proper UTF-8, indicate encoding ! </CODE></PRE> <P>If I save the file in UTF-8 mode or UNICODE, the lookup will not work:</P> <PRE><CODE># Error 'Could not find all of the specified lookup fields in the lookup table </CODE></PRE> <P>These edits are being done in Notepad / Windows <span class="lia-unicode-emoji" title=":face_with_tongue:">😛</span></P> Fri, 22 Jul 2011 14:09:34 GMT ruiaires 2011-07-22T14:09:34Z using UTF-8 files for CSV lookup https://community.splunk.com/t5/Splunk-Search/using-UTF-8-files-for-CSV-lookup/m-p/47027#M11232 <P>I need to use a .CSV file for a lookup which has accented characters in the field values</P> <P>If I save the file in ANSI mode, Splunk will complain it is not UTF:</P> <PRE><CODE>[SimpleResultsTable module] Input is not proper UTF-8, indicate encoding ! </CODE></PRE> <P>If I save the file in UTF-8 mode or UNICODE, the lookup will not work:</P> <PRE><CODE># Error 'Could not find all of the specified lookup fields in the lookup table </CODE></PRE> <P>These edits are being done in Notepad / Windows <span class="lia-unicode-emoji" title=":face_with_tongue:">😛</span></P> Fri, 22 Jul 2011 14:09:34 GMT https://community.splunk.com/t5/Splunk-Search/using-UTF-8-files-for-CSV-lookup/m-p/47027#M11232 ruiaires 2011-07-22T14:09:34Z Re: using UTF-8 files for CSV lookup https://community.splunk.com/t5/Splunk-Search/using-UTF-8-files-for-CSV-lookup/m-p/47028#M11233 <P>Convert your lookup to not have accented characters.</P> <P>Is the splunk machine nix based? If so, try using dosutils.... dos2unix [filename] to convert to proper format.</P> <P>Also try using notepad++ not notepad... never use notepad for ETL.</P> Mon, 14 Dec 2015 13:10:20 GMT https://community.splunk.com/t5/Splunk-Search/using-UTF-8-files-for-CSV-lookup/m-p/47028#M11233 jkat54 2015-12-14T13:10:20Z