https://community.splunk.com/t5/Getting-Data-In/Why-is-Inputlookup-CSV-truncating-my-data/m-p/417727#M73730 <P>Welcome. Please accept my answer.</P> Thu, 24 Jan 2019 01:29:13 GMT vnravikumar 2019-01-24T01:29:13Z https://community.splunk.com/t5/Getting-Data-In/Why-is-Inputlookup-CSV-truncating-my-data/m-p/417724#M73727 <P>I use the inputlookup file.csv and the zeros on numbers are deleted ex. 00075 to 75, it also truncates some numbers ex. 20170505.00002 to 20170505</P> <P>How do I get it to input CSV data exactly as it is?</P> Tue, 22 Jan 2019 19:18:06 GMT https://community.splunk.com/t5/Getting-Data-In/Why-is-Inputlookup-CSV-truncating-my-data/m-p/417724#M73727 shealerner 2019-01-22T19:18:06Z https://community.splunk.com/t5/Getting-Data-In/Why-is-Inputlookup-CSV-truncating-my-data/m-p/417725#M73728 <P>Hi @shealerner</P> <P>There could be one reason that if you are editing csv file with MS-Excel, you may get the above problem.</P> <P><IMG src="https://i.ibb.co/W5m9NxF/lookup1.png" alt="alt text" /></P> <P><IMG src="https://i.ibb.co/L1xP8HQ/lookup2.png" alt="alt text" /></P> <P><IMG src="https://i.ibb.co/tLmHMDM/lookup3.png" alt="alt text" /></P> Wed, 23 Jan 2019 11:29:30 GMT https://community.splunk.com/t5/Getting-Data-In/Why-is-Inputlookup-CSV-truncating-my-data/m-p/417725#M73728 vnravikumar 2019-01-23T11:29:30Z https://community.splunk.com/t5/Getting-Data-In/Why-is-Inputlookup-CSV-truncating-my-data/m-p/417726#M73729 <P>Thank you, I was opening the file in Microsoft Excel which was truncating the values.</P> Wed, 23 Jan 2019 14:51:20 GMT https://community.splunk.com/t5/Getting-Data-In/Why-is-Inputlookup-CSV-truncating-my-data/m-p/417726#M73729 shealerner 2019-01-23T14:51:20Z https://community.splunk.com/t5/Getting-Data-In/Why-is-Inputlookup-CSV-truncating-my-data/m-p/417727#M73730 <P>Welcome. Please accept my answer.</P> Thu, 24 Jan 2019 01:29:13 GMT https://community.splunk.com/t5/Getting-Data-In/Why-is-Inputlookup-CSV-truncating-my-data/m-p/417727#M73730 vnravikumar 2019-01-24T01:29:13Z