Keith - if you export from Excel to csv, you still have the problem with embedded Return characters.
Pat On 7 March 2018 at 20:48, Keith Goebel via 4D_Tech <[email protected]> wrote: > Ferdinando , > If you convert the Excel file to csv, you shouldn't have any problems with > cells containing carriage returns/line feeds when you import into 4D. > I assume 4D’s built-in import can handle csv files - I haven’t checked - > we use special import and export code to handle csv so we don’t use 4D’s > built-in stuff. > > Sometimes an Excel csv export doesn’t comply completely with the cvs > rules, but mostly it does. > HTH, Keith > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** > -- ************************************************* CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
