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
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.
Thank you so much.
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.
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.