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.