Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Issue with export from sys_choice table

Ap_1
Tera Contributor

When exporting data from sys_choice table on excel or CSV, if the Value of a record is -5

 

Then on export is is taking as '-5. The same is happening on PDI instance as well. Anyone have any idea on this.

2 REPLIES 2

Hemanth M1
Giga Sage
Giga Sage

Hi @Ap_1 ,

 

Yes, i have noticed this,  I think it considering "-" has a special character and appending extra ' for string type field however works fine for sequence field (field type integer).

 

Either use script to remove this or export as Excel

 

HemanthM1_0-1725469343299.png

 

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Ap_1
Tera Contributor

Hi @Hemanth M1 
Export on excel also giving the same.

Do you have any idea why this is happening.