https://community.esri.com/t5/arcgis-pro-ideas/importing-and-loading-data-convert-text-values-to/idi-p/1552265 <P><EM>ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:</EM></P><P>When importing or loading a CSV into an enterprise geodatabase standalone table:</P><P>There are dates stored as text like this in the CSV (8 date fields): <EM>[edited]</EM></P><UL><LI>Nov 7, 2023, 9:55 AM</LI><LI>Sep 23, 2022, 1:11 PM</LI><LI>May 9, 2023, 6:56 AM</LI></UL><P>Right now, my current workflow to get the text into proper date fields is:</P><OL><LI>Load the values into temporary text fields.</LI><LI>Create blank date fields.</LI><LI>Use a Python or Arcade field calculation to convert the text into dates; populate the date fields.</LI><LI>Delete the temporary text fields.</LI></OL><P>That's cumbersome. Parsing dates using code is difficult and risky for non-experts. Instead of needing to convert text to dates using code, I'm wondering if GP tools like Table to Geodatabase could do the conversion, possibly using AI/machine learning. Right in the Table to Geodatabase or Append GP tool as a single step, not in a separate GP tool after the fact. And without explicitly defining the date format with MMM DD, YYYY, T:TT TT.</P><P>I'm inexperienced with AI/machine learning, but if systems like ChatGPT can <A href="https://connor-mcdonald.com/2023/12/08/using-ai-for-test-data/" target="_self">convert a textual table to SQL INSERT statements</A>, then I'm wondering if a similar AI mechanism in Pro could convert text to dates, too. Or maybe AI isn't needed, but it could be done automatically with functions or regular expressions within the GP tool instead.</P> Fri, 24 Jan 2025 02:13:47 GMT Bud 2025-01-24T02:13:47Z https://community.esri.com/t5/arcgis-pro-ideas/importing-and-loading-data-convert-text-values-to/idi-p/1552265 <P><EM>ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:</EM></P><P>When importing or loading a CSV into an enterprise geodatabase standalone table:</P><P>There are dates stored as text like this in the CSV (8 date fields): <EM>[edited]</EM></P><UL><LI>Nov 7, 2023, 9:55 AM</LI><LI>Sep 23, 2022, 1:11 PM</LI><LI>May 9, 2023, 6:56 AM</LI></UL><P>Right now, my current workflow to get the text into proper date fields is:</P><OL><LI>Load the values into temporary text fields.</LI><LI>Create blank date fields.</LI><LI>Use a Python or Arcade field calculation to convert the text into dates; populate the date fields.</LI><LI>Delete the temporary text fields.</LI></OL><P>That's cumbersome. Parsing dates using code is difficult and risky for non-experts. Instead of needing to convert text to dates using code, I'm wondering if GP tools like Table to Geodatabase could do the conversion, possibly using AI/machine learning. Right in the Table to Geodatabase or Append GP tool as a single step, not in a separate GP tool after the fact. And without explicitly defining the date format with MMM DD, YYYY, T:TT TT.</P><P>I'm inexperienced with AI/machine learning, but if systems like ChatGPT can <A href="https://connor-mcdonald.com/2023/12/08/using-ai-for-test-data/" target="_self">convert a textual table to SQL INSERT statements</A>, then I'm wondering if a similar AI mechanism in Pro could convert text to dates, too. Or maybe AI isn't needed, but it could be done automatically with functions or regular expressions within the GP tool instead.</P> Fri, 24 Jan 2025 02:13:47 GMT https://community.esri.com/t5/arcgis-pro-ideas/importing-and-loading-data-convert-text-values-to/idi-p/1552265 Bud 2025-01-24T02:13:47Z https://community.esri.com/t5/arcgis-pro-ideas/importing-and-loading-data-convert-text-values-to/idc-p/1578497#M33572 <P>What tool are you using to transfer your data from the CSV to a standalone table?</P> Thu, 23 Jan 2025 23:43:53 GMT https://community.esri.com/t5/arcgis-pro-ideas/importing-and-loading-data-convert-text-values-to/idc-p/1578497#M33572 SSWoodward 2025-01-23T23:43:53Z https://community.esri.com/t5/arcgis-pro-ideas/importing-and-loading-data-convert-text-values-to/idc-p/1578501#M33573 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/604859">@SSWoodward</a>&nbsp; Table to Geodatabase or Append&nbsp;</P> Fri, 24 Jan 2025 00:16:23 GMT https://community.esri.com/t5/arcgis-pro-ideas/importing-and-loading-data-convert-text-values-to/idc-p/1578501#M33573 Bud 2025-01-24T00:16:23Z https://community.esri.com/t5/arcgis-pro-ideas/importing-and-loading-data-convert-text-values-to/idc-p/1578510#M33575 Fri, 24 Jan 2025 00:52:27 GMT https://community.esri.com/t5/arcgis-pro-ideas/importing-and-loading-data-convert-text-values-to/idc-p/1578510#M33575 SSWoodward 2025-01-24T00:52:27Z