s<
>
> 060 6f 6d 65 20 74 65 78 74 20 22 22 71 75 6f 74 65 >ome text ""quote<
>
> 100 64 22 22 2e 22 0d 0a >d""."..<
>
>
>
> HTH
>
> Regards Lutz
>
>
>
>
>
>> -----Original
nal Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Tim Nevels
> via
> 4D_Tech
> Sent: Wednesday, March 15, 2017 8:39 PM
> To: 4d_tech@lists.4d.com
> Cc: Tim Nevels <timnev...@mac.com>
> Subject: Re: tab seperated tex
e specific
> than "Re: Contents of 4D_Tech digest..."
>
>
> Today's Topics:
>
> 1. Re: tab seperated text - what to use for Cr (Arnaud de Montard)
> 2. Re: tab seperated text - what to use for Cr (Chip Scheide)
> 3. Re: tab seperated text - what to use fo
to be pedantic, you need to do more than double quote the values,
in case the value themselves contain a double quote.
and then,
importing gets even more messy,
since the values may or may not be quoted.
anyway, I've published the component here:
https://github.com/miyako/4d-component-csv
>
> I tried that -
> it too creates a new row in excel when opened/imported.
csv format will do the job, if that format is permitted for your purpose.
You’ll need to enclose text fields with “ to keep contained CRs safe.
**
4D
not sure if Excel supports it, (FileMaker does)
but the formal way to include multiple lines in a TSV field is to use the
vertical tab character Char(11).
(side-note: Char(11) shows up as \v in the debugger, although you can't it in
literal text)
if you are interested I can share a set of
We normally export CRs as some kind of unique escape sequence (like "#13" or
so) that can be easily replaced by CRs in Excel.
That way the export data can be handled without problems in all systems that
allow for global search
Cheers,
Tilman
extragroup GmbH
Pottkamp 19
48149 Münster
On Mar 15, 2017, at 2:00 PM,Chip Scheide wrote:
> I am trying to export some data to tab separated format.
> it is possible that there are carriage returns in the data.
> Is there a character (or combination) that I can use to replace the
> return to get excel to automatically wrap the text into
I tried that -
it too creates a new row in excel when opened/imported.
On Wed, 15 Mar 2017 20:15:34 +0100, Arnaud de Montard via 4D_Tech wrote:
>
>> Le 15 mars 2017 à 19:46, Chip Scheide via 4D_Tech
>> <4d_tech@lists.4d.com> a écrit :
>>
>> I am trying to export some data to tab separated
> Le 15 mars 2017 à 19:46, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> I am trying to export some data to tab separated format.
> it is possible that there are carriage returns in the data.
> Is there a character (or combination) that I can use to replace the
> return to
10 matches
Mail list logo
