topic Re: Public Notification Widget - string data type exported to CSV as float in Web AppBuilder Custom Widgets Questions https://community.esri.com/t5/web-appbuilder-custom-widgets-questions/public-notification-widget-string-data-type/m-p/831854#M8351 <HTML><HEAD></HEAD><BODY><P>CSV format is very primitive, as it should be.&nbsp;I'm still not sure what you're trying to achieve&nbsp;but from the sound of it, your problem is with Excel showing you the wrong data type. The exported data itself however&nbsp;should be fine.</P></BODY></HTML> Sun, 27 Oct 2019 23:17:12 GMT shaylavi 2019-10-27T23:17:12Z Public Notification Widget - string data type exported to CSV as float https://community.esri.com/t5/web-appbuilder-custom-widgets-questions/public-notification-widget-string-data-type/m-p/831853#M8350 <HTML><HEAD></HEAD><BODY><UL><LI>I am having an issue -&nbsp; when data is exported as CSV from PublicNotification widget, string data is exported as float data type</LI><LI>We have 17 digit Parcel ID which is a string data type,&nbsp; but when exported to CSV it is interpreted as float</LI><LI>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.</LI><LI>I have checked the layer that has the PARID data and it is showing PARID as String Type</LI><LI>Any help will be appreciated.</LI></UL><P></P><P><IMG alt="layer showing PARID as string data type" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/465505_PublicNotification_ExportData_Issue_1.jpg" /></P><P><IMG alt="CSV sheet showing PARID as float data type" class="jive-emoji jive-image image-2 j-img-original" src="https://community.esri.com/legacyfs/online/465509_PublicNotification_ExportData_Issue_2.jpg" /></P></BODY></HTML> Mon, 21 Oct 2019 19:41:30 GMT https://community.esri.com/t5/web-appbuilder-custom-widgets-questions/public-notification-widget-string-data-type/m-p/831853#M8350 KetanDoshi 2019-10-21T19:41:30Z Re: Public Notification Widget - string data type exported to CSV as float https://community.esri.com/t5/web-appbuilder-custom-widgets-questions/public-notification-widget-string-data-type/m-p/831854#M8351 <HTML><HEAD></HEAD><BODY><P>CSV format is very primitive, as it should be.&nbsp;I'm still not sure what you're trying to achieve&nbsp;but from the sound of it, your problem is with Excel showing you the wrong data type. The exported data itself however&nbsp;should be fine.</P></BODY></HTML> Sun, 27 Oct 2019 23:17:12 GMT https://community.esri.com/t5/web-appbuilder-custom-widgets-questions/public-notification-widget-string-data-type/m-p/831854#M8351 shaylavi 2019-10-27T23:17:12Z