Getting Data In

Why is Inputlookup CSV truncating my data?

New Member

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

How do I get it to input CSV data exactly as it is?

0 Karma
1 Solution

Champion

Hi @shealerner

There could be one reason that if you are editing csv file with MS-Excel, you may get the above problem.

alt text

alt text

alt text

View solution in original post

Champion

Hi @shealerner

There could be one reason that if you are editing csv file with MS-Excel, you may get the above problem.

alt text

alt text

alt text

View solution in original post

New Member

Thank you, I was opening the file in Microsoft Excel which was truncating the values.

0 Karma

Champion

Welcome. Please accept my answer.

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!