What Dougie said :)
PB
On Mon, 6 Aug 2018 at 17:08, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> Brad,
>
> My stock answer to questions like this is. Get yourself a copy of :
> http://www.pluggers.nl/product/xl-plugin/
>
> If you are doing anything serious with excel files this is
t to 32767 characters doesn't
solve the problem.
Thanks,
Brad
From: Bradley Perkins
Date: Monday, August 6, 2018 at 2:07 PM
To: "Benedict, Tom" , "4d_tech@lists.4d.com"
<4d_tech@lists.4d.com>
Subject: Re: Export text columns containing carriage returns to Excel?
My ini
ing([table]text_field;Char(34);Char(34)+Char(34))
Thanks,
Brad
From: "Benedict, Tom"
Date: Monday, August 6, 2018 at 1:50 PM
To: Bradley Perkins , "4d_tech@lists.4d.com"
<4d_tech@lists.4d.com>
Subject: RE: Export text columns containing carriage returns to Excel?
I didn’
: Perkins, Bradley D [mailto:bperk...@lanl.gov]
Sent: Monday, August 06, 2018 12:34 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?
Tom,
That sounds extremely useful. In addition to "" any "s in the text do I also
Benedict, Tom"
Date: Monday, August 6, 2018 at 1:26 PM
To: Bradley Perkins , "4d_tech@lists.4d.com"
<4d_tech@lists.4d.com>
Subject: RE: Export text columns containing carriage returns to Excel?
Brad,
Here’s a hint that you may (or may not) find useful.
I used a single column
018 1:26 PM
To: Benedict, Tom; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?
Hi Tom,
I've been working this with the QR Editor with some success. Another challenge
I've found is that the 4D text fields have carriage returns, carriage
return/new l
Brad,
My stock answer to questions like this is. Get yourself a copy of :
http://www.pluggers.nl/product/xl-plugin/
If you are doing anything serious with excel files this is the easiest and best
solution and well worth the outlay.
Regards, Dougie
e output file size will not be an
> issue.
>
> Best,
>
> Brad
>
>
> From: Benedict, Tom
> Sent: Friday, August 3, 2018 2:19:44 PM
> To: Perkins, Bradley D; 4d_tech@lists.4d.com
> Subject: Re: Export text columns containing carriage returns to Ex
From: Keith Goebel
Sent: Sunday, August 5, 2018 2:53 PM
To: 4D Tech Mailing List Technical; Perkins, Bradley D
Subject: Re: Export text columns containing carriage returns to Excel?
Brad,
I don’t know - I rarely use 4D’s export and when I do it’s only for a quick
text file (tab delimited) export
Brad,
I don’t know - I rarely use 4D’s export and when I do it’s only for a quick
text file (tab delimited) export.
I do my main exports using code and the csv version follows the cvs rules and
it works great.
Sorry I can’t share the code - it is buried in a contracted project.
I suspect there
Sent: Friday, August 3, 2018 2:19:44 PM
To: Perkins, Bradley D; 4d_tech@lists.4d.com
Subject: Re: Export text columns containing carriage returns to Excel?
Brad Perkins writes:
>I've been asked to provide an export from a legacy 4D system delivered as an
>.xlsx file.
>The challenge I
that would be wonderful.
Thanks,
Brad
From: Keith Goebel
Sent: Saturday, August 4, 2018 7:58:56 PM
To: 4D Tech Mailing List Technical
Cc: Perkins, Bradley D
Subject: Re: Export text columns containing carriage returns to Excel?
Brad,
There have been a couple
Brad,
There have been a couple of “export data” related threads lately that seem to
be having problems with embedded CRs.
Where I have CRs in the data, I save the exported data as csv and that has
always solved that problem for me.
Perhaps there is some reason that is not suitable for you...
if you create a spreadsheet in Excel,
enter a carriage return inside a cell (Alt/option+Enter)
save as TSV, you see CSV-like escape in the resulting file.
e.g.
"A
B"
4D's import dialog or Quick Report doesn't offer this option,
but it is not that difficult to implement.
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
; <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:
Content-Type: text/plain; charset="utf-8"
Brad
Can I replace the carr
What are you using to do the export?, 4D export functionality, quick report or
something else?
If you are using 4D export, just change the EOL char to something else, the use
that char as the line delimiter when you open it in Excel. Another option is
to export it in DBF format, then import
Some ideas:
I would question the desirability of an excel file for these data, getting the
data back out of excel will be more than a little fun.
A text file with the LFs replaced with some unique code would be better for
most purposes. Alternatively, you could pick some high ascii codes as
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
19 matches
Mail list logo