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
ield output 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
"
> 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’t have to escape the embedded commas. I think the quotes
e string([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
: 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
quot;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 co
Sunday, August 05, 2018 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 r
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
system that started life in v3. The 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 column
Excel.
Best,
Brad
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 (t
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 ar
: 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 Excel?
Brad Perkins writes:
>I've been asked to provide an export from a legacy 4D system delivered as an
>.xlsx file.
&g
ting into Excel 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 b
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...
Exc
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.
https://github.com/miyak
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 origi
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:
Content-Type: text/plain; charset="utf-8"
Brad
Ca
;4d_tech-boun...@lists.4d.com> On Behalf Of Perkins, Bradley D
via 4D_Tech
Sent: Friday, August 3, 2018 11:22 AM
To: 4d_tech@lists.4d.com
Cc: Perkins, Bradley D
Subject: Export text columns containing carriage returns to Excel?
I've been asked to provide an export from a legacy 4D system d
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 your
/" 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
Subject: Export text co
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 st
21 matches
Mail list logo