Thanks Randy,
It looks like I can do this with a quick report.
I need to add a custom column with a formula like:
Replace string([proposals]proposal_text;Char(13)+Char(10);"[[crlf]]")
As to the other question about using Excel, they are working with a cloud-based
SAAS that processes uploaded excel files for data imports. It works much nicer
than you'd expect!
The other import options involve REST or SQL. Since this is a legacy 4D system
that is behind a firewall I can't provide those.
I will be exporting these to a text file first and will have to massage the
data once it is in Excel.
Best,
Brad Perkins
On 8/3/18, 11:44 AM, "4D_Tech on behalf of 4d_tech-requ...@lists.4d.com"
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech-requ...@lists.4d.com> wrote:
Message: 8
Date: Fri, 3 Aug 2018 10:43:47 -0700
From: "Randy Engle" <4d.l...@xc2.us>
To: "'4D iNug Technical'" <4d_tech@lists.4d.com>
Subject: RE: Export text columns containing carriage returns to Excel?
Message-ID:
<!&!AAAAAAAAAAAYAAAAAAAAALE/4razmVBBs4IIVut9wYjCgAAAEAAAAFkpv2DicIpJtXfz+L7rx/YBAAAAAA==@xc2.us>
Content-Type: text/plain; charset="utf-8"
Brad
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.
This is frequently what I need to do:
Replace the CR (13), (10), (11) with "///" or somesuch.
Then put the CR back after import.
Randy Engle
-----Original Message-----
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Perkins, Bradley
D via 4D_Tech
Sent: Friday, August 3, 2018 10:22 AM
To: 4d_tech@lists.4d.com
Cc: Perkins, Bradley D <bperk...@lanl.gov>
Subject: Export text columns containing carriage returns to Excel?
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.
Thanks,
Brad Perkins
**********************************************************************
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
**********************************************************************
