On Dec 12, 2019, at 2:00 PM, Kirk wrote: > (Environment: All Windows, 4D server/client 16R4) > > Just curious if anyone has found a way to automatically transform Excel > documents to text-tab delimited documents? > > The issue I am attempting to solved: We have several system which produce > document that need to be imported into a 4D application. Some of these > systems produce Excel documents. To standardize I would like to > automatically transform these Excel docs into a Text-Tab delimited doc. This > would need to be logic triggered by 4D. (e.g. 4D identifies the doc as Excel > and "does something" to transform to text-tab before import.) > > Any thoughts? > > Thanks in advance for the consideration and help!
I forgot the wonderful world of AppleScript on macOS and Visual Basic on Windows for controlling Excel and have it do the work for you. Of course you will need a copy of Excel installed on the machine for this to work. Tim ***************************************** Tim Nevels Innovative Solutions 785-749-3444 [email protected] ***************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
