Brad Perkins writes:

>I've been asked to provide an export from a legacy 4D system delivered as an 
>.xlsx file.

>The challenge I'm facing is that this table contains a number of text fields 
>and
>the customer requires the imported column cells to retain the returns or line 
>feeds
>in the original text fields. If I do a straight tab-delimited export with 
>carriage returns
>as the end of line marker, the imported result does not preserve the original 
>row
>because any returns encountered in the text fields are interpreted as end of 
>row.

>My other challenge is that I need to do this with out-of-box end user 
>capabilities
>from a client (v15.4 remote) against a compiled server. I can't install 
>plugins, create new methods, etc.
>It has been many years since I've had to do this type of thing in 4D.

>Can I replace the carriage returns in the text fields with a special marker 
>during export?
>I could replace the Excel cells containing the any carriage return markers 
>with actual returns after import.

Use the Quick Report Editor. You can put formulas in the columns which include 
a call to Replace string.

There are some limitation which I've encountered:


-          The Quick Report Editor is 32bit (evidently) which limits the size 
of the output file to 4GB. Hopefully you don't run in to that limit. (I did 
recently).

-          Any given cell in Excel can only hold 32,767 characters. If you have 
more than that you'll have to do some fancy segmenting into another column in 
the output.

HTH, let me know if you have further questions. I have very recent experience 
doing just this.

Tom Benedict
Optum

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to