Issue with export from sys_choice table

Ap_1
Tera Contributor

‎09-04-2024 07:50 AM

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.

sys_choice (2).csv
0 Helpfuls
  • 1,192 Views
2 REPLIES 2

Hemanth M
Tera Sage

‎09-04-2024 10:02 AM

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

 

 

 

0 Helpfuls

Ap_1
Tera Contributor
In response to Hemanth M

‎09-09-2024 05:09 AM - edited ‎09-09-2024 05:09 AM

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

Do you have any idea why this is happening.

0 Helpfuls