[prev in list] [next in list] [prev in thread] [next in thread] 

List:       applixware-redhat
Subject:    Re: spreadsheet import from ASCII (bug?)
From:       Hugo van der Kooij <Hugo.van.der.Kooij () caiw ! nl>
Date:       1997-07-13 23:30:15
[Download RAW message or body]

On Sun, 13 Jul 1997, Michael Eyrich wrote:

> On Sun, 13 Jul 1997, Hugo van der Kooij wrote:
> 
> | On Sun, 13 Jul 1997, Michael Eyrich wrote:
> |
> | > I am trying to convert some lists containing numbers and
> | > dates. The import-filter does not import dates in the
> | > format dd.mm.yy, if the decimal dot is set to ','. It
> | > shows up as '##########'.
> | >
> | > What can I do?
> |
> | Does another date type work? such as dd/mm/yy or dd-mm-yy?
> |
> | If so, the best way would be to do a find and replace operation on the
> | files. If needed you can do so almost autmagically by using sed.
> 
> Ok, I've converted the dates, but no luck, it seems to be a bug, not a
> feature :-(
> 
> Original input lines are: (of about 450)
> 
> 
> 00-415	07.10.86	2	22.11.86	404,74	401,59	15.11.88
> 3,15
> 00-723	12.12.86	1	12.01.87	166,06	0,00	15.11.88
> 166,06
> 
> It should read as:
> string	date		num	date		number 	number	date
> number
> 
> 
> 
> All dates converted to dd/mm/yy does not work (NaN, ########).
> 
> 00-415	07.10.86	2	22/11/86	404,74	401,59	15.11.88
> 3,15
> 00-723	12.12.86	1	12/01/87	166,06	0,00	15.11.88
> 166,06

Why is the fourth column changes but not the second? Both are date types!
(Same for the seventh column.)

And are you sure it should not be mm/dd/yy instead of dd/mm/yy?

And are the strings recognized properly?

Hugo.

	+---------------------------------------------------------------+
	| Hugo van der Kooij	+31-10-599.9237				|
	|	email:		hvdkooij@caiw.nl			|
	|	homepage:	http://www.caiw.nl/~hvdkooij		|
	|	pgpkey:		http://www.caiw.nl/~hvdkooij/pgpkey	|
	+---------------------------------------------------------------+

--
To unsubscribe:
mail -s unsubscribe applixware-list-request@redhat.com < /dev/null

[prev in list] [next in list] [prev in thread] [next in thread]