Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2013

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

Search the Archive

Re: small string issue

  • To: mathgroup at smc.vnet.net
  • Subject: [mg131794] Re: small string issue
  • From: David Bailey <dave at removedbailey.co.uk>
  • Date: Mon, 7 Oct 2013 08:23:01 -0400 (EDT)
  • Delivered-to: l-mathgroup@mail-archive0.wolfram.com
  • Delivered-to: l-mathgroup@wolfram.com
  • Delivered-to: mathgroup-outx@smc.vnet.net
  • Delivered-to: mathgroup-newsendx@smc.vnet.net
  • References: <l2iq4j$qmj$1@smc.vnet.net>

On 03/10/2013 05:00, Francisco Gutierrez wrote:
> Dear group:
>
> I am importing into Mathematica a big number of dates. For example:
>
>
> unasfechas = {11/06/1998, 21/01/2010, 12/10/2001, 20/07/2009,
>    02/02/2002, 02/01/2004, 19/11/2001, 14/02/2010, 26/12/2009,
>    20/10/1996, 09/07/2006, 01/01/1997, 30/08/1998, 15/02/2006,
>    13/12/2009, 25/09/2002, 29/06/2009, 02/04/2010, 22/02/2001,
>    01/04/2010}
>
>
> These dates come from Excel files, and are brought into Mathematica not as strings but as numbers. I want to transform them into strings to
> be able to apply functions like DateList, etc.
>
> In principle, this should be easy. This example, taken from the documentation, is simple and clear:
> ToString[x^2, InputForm]
>
>

>
I wonder what exactly you mean by "are brought into Mathematica"?

If you mean that you have used cut and paste (the way you phrase your 
question suggests that), the solution is fairly easy - because you still 
have the date digits available.

Instead of pasting the dates inside {}, paste them inside quotes (or add 
the quotes afterwards:

dates = "11/06/1998,21/01/2010,12/10/2001,20/07/2009,02/02/2002,02/01/\
2004,19/11/2001,14/02/2010,26/12/2009,20/10/1996,09/07/2006,01/01/\
1997,30/08/1998,15/02/2006,13/12/2009,25/09/2002,29/06/2009,02/04/\
2010,22/02/2001,01/04/2010"

Now you can split the dates up using the comma delimiters:

In[14]:= StringSplit[dates, ","]

Out[14]= {"11/06/1998", "21/01/2010", "12/10/2001", "20/07/2009", \
"02/02/2002", "02/01/2004", "19/11/2001", "14/02/2010", "26/12/2009", \
"20/10/1996", "09/07/2006", "01/01/1997", "30/08/1998", "15/02/2006", \
"13/12/2009", "25/09/2002", "29/06/2009", "02/04/2010", "22/02/2001", \
"01/04/2010"}

If that doesn't help, please explain exactly how you brought those 
numbers into Mathematica.

David Bailey
http://www.dbaileyconsultancy.co.uk




  • Prev by Date: Re: Mathematica does not recognize C Compiler
  • Next by Date: Re: plotting complex functions in (x,y,t) space
  • Previous by thread: Re: small string issue
  • Next by thread: Dynamically setting {min, max} in Angular Gauge[] & speed it up.