MathGroup Archive 2012

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Export Data and Decimal Separator

  • To: mathgroup at smc.vnet.net
  • Subject: [mg125554] Re: Export Data and Decimal Separator
  • From: Murray Eisenberg <murray at math.umass.edu>
  • Date: Sun, 18 Mar 2012 02:47:02 -0500 (EST)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • References: <jjrvbg$9h3$1@smc.vnet.net> <jjv8gt$phc$1@smc.vnet.net> <201203170752.CAA05132@smc.vnet.net>
  • Reply-to: murray at math.umass.edu

How about using NumberForm and its option NumberPoint?

(Sorry, I don't have the original post).

On 3/17/12 3:52 AM, Norbert Marxer 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
>
>

-- 
Murray Eisenberg                     murray at math.umass.edu
Mathematics & Statistics Dept.
Lederle Graduate Research Tower      phone 413 549-1020 (H)
University of Massachusetts                413 545-2859 (W)
710 North Pleasant Street            fax   413 545-1801
Amherst, MA 01003-9305



  • Prev by Date: Re: How to remove unwanted, garbage plotmarkers
  • Next by Date: Mathematica results different on different computers !
  • Previous by thread: Re: Export Data and Decimal Separator
  • Next by thread: Re: Export Data and Decimal Separator