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!
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.
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.
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.
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.
yes most likely my MS Excel converted some of the values into scientific notation.
You should click Accept
to close this question.