Why is the search some digit of number when exporting to CSV?

[chakuttha]

Dear All,

  Please help to recommend  when i export  result to CSV  field work id if number start with 0
it not show when open in csv files   as capture screen below,

If i would like to change format before export to csv it possible? 

Best Regards,

CR

[chakuttha]

Thank you so much.

[FrankVl · Accepted solution]

That's not a Splunk problem, that's an excel problem. If you open the csv in a text editor you should see the leading 0's are included in the csv as exported by Splunk. Forcing the value to be wrapped in double quotes also won't fix this behavior (I just tested this).

You need to handle this in your excel import, to treat that column as text rather than number.

[richgalloway]

If you put quotation marks around the WORK_ID field the leading zeroes will be preserved in the CSV.  So, too, will the quotation marks so you will need to remove those.