Select to view content in your preferred language

Public Notification Widget - string data type exported to CSV as float

402
1
10-21-2019 12:41 PM
KetanDoshi
Occasional Contributor
  • I am having an issue -  when data is exported as CSV from PublicNotification widget, string data is exported as float data type
  • We have 17 digit Parcel ID which is a string data type,  but when exported to CSV it is interpreted as float
  • I am aware of adding an apostrophe at the end or the start to avoid interpretation as float, but if i do that apostrophe shows up in exported data as well as on PDF labels and i don't want that to show up that way.
  • I have checked the layer that has the PARID data and it is showing PARID as String Type
  • Any help will be appreciated.

layer showing PARID as string data type

CSV sheet showing PARID as float data type

0 Kudos
1 Reply
shaylavi
Esri Contributor

CSV format is very primitive, as it should be. I'm still not sure what you're trying to achieve but from the sound of it, your problem is with Excel showing you the wrong data type. The exported data itself however should be fine.

Shay
0 Kudos