CSV inconsistent field value

[lloydknight]

Hello Splunkers,

So I have this csv file that a certain field contains 10+ numbers.
Please see sample image below:

Tried changing its format from General to Text in csv before indexing it but I still get this scientific numbers.

Thoughts?

Thanks!

[sduff_splunk · Accepted solution]

Can you confirm in the source file that it is using exponential notation? You can check by using the "Show Source" Event Action, or look at the original event.

I expect that the original file will have both decimal and exponential notation, which is causing this.

[lloydknight]

Hello sduff, this was solved by not opening the downloaded csv and indexed it directly on Splunk. Not sure what's the explanation for this though. Thanks.

[sduff_splunk]

The problem was likely that your editor (Excel?) converted some of the values in the CSV into scientific notation. As you said, going directly into Splunk didn't have that issue.

[lloydknight]

yes most likely my MS Excel converted some of the values into scientific notation.

[woodcock]

You should click Accept to close this question.