Re: Export Data and Decimal Separator
- To: mathgroup at smc.vnet.net
- Subject: [mg125577] Re: Export Data and Decimal Separator
- From: Rodrigo Murta <murta at rodrigomurta.com>
- Date: Mon, 19 Mar 2012 05:00:25 -0500 (EST)
- Delivered-to: l-mathgroup@mail-archive0.wolfram.com
- References: <jjrvbg$9h3$1@smc.vnet.net> <jjv8gt$phc$1@smc.vnet.net> <jk1g11$51n$1@smc.vnet.net>
Hi Norbert
Tks for your suggestion. I'll use it.
best regards
Murta
On Mar 17, 4:55 am, Norbert Marxer <mar... at mec.li> wrote:
> On 16 Mrz., 12:34, Murta <rodrigomur... at gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> > Hi Bill, tks for your reply.
> > I need comma for number decimal separator(10,1 instead of 10.1), your
> > sugestion is for field separator.
> > For Import command it works nice.
> > Some idea?
>
> > On Mar 15, 2:40 am, Bill Rowe <readn... at sbcglobal.net> wrote:
>
> > > On 3/14/12 at 12:36 AM, rodrigomur... at gmail.com (Murta) wrote:
>
> > > >I would like to know how could I export some data using comma as
> > > >decimal separator.
> > > >I tried this: data={{1.3,2.3},{3.2,4.3}} Export["file.txt", data,
> > > >"TSV", {NumberPoint -> ","}]
> > > >But didn't worked. Some idea?
>
> > > "TSV" = tab separated values
> > > "CSV" = comma separated values
>
> > > Try that instead. That is
>
> > > Export["file.txt", data, "CSV"]
>
> Hello
>
> You could define a function which converts your number to a string,
> replaces the points with a comma, and maps this to all the numbers of
> your table:
>
> mod := Map[StringReplace[ToString[ #], "." -> ","] &, #, {2}] &;
>
> You can test this with:
>
> data = {{1.3, 2.3}, {3.2, 4.3}};
> ExportString [mod[data], "TSV"] (*or*)
> Export["test.txt", mod[data], "TSV"]
>
> Best Regards
> Norbert Marxer