Getting Data In

Why is Inputlookup CSV truncating my data?

shealerner
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

vnravikumar
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

vnravikumar
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

shealerner
New Member

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

0 Karma

vnravikumar
Champion

Welcome. Please accept my answer.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...