Hi Kirk, Converting Excel to Text is a problem that others have tackled, so I would rely on their work rather than trying to build it yourself. Plugger’s XL Plugin is probably something you should look at, if you haven’t already. There are components and libraries that do similar things with Excel docs, but Rob’s stuff is very solid.
HTH, Tom Benedict > On Dec 12, 2019, at 11:59, rooftop99--- via 4D_Tech <[email protected]> > wrote: > > Hi 4D folks, > > (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! > > Kirk > > > ********************************************************************** > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************
