Zero value is not visible when export report to CSV format
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2024 07:03 PM
Hi community, currently we want to do export set to drop file to mid server. We have case where employee number initial with number 0. When the system export the file as CSV to mid server, the 0 is missing from the file. As I know, we need to put apostrophe in front of the number. How to write a script to cater this and where do I need to put the scripting at ?
Please help. Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2024 07:00 AM
may be it's considering it as integer and hence stripping the zero
you can try to use export set pre-export script and handle the csv file manipulation
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2024 06:13 PM - edited ‎08-06-2024 02:42 AM
Hi Ankur,
Actually the Export Definition from Export Set is coming from Database View which join 3 tables (refer attachment). The header in the excel is display as table_name.field_name. Kindly refer to the script below and I'm not able to append the apostrophe. Kindly help to provide with your script/ solutions.