Topic

importing date and time

Ce sujet contient 4 réponses, 2 participants et a été mis à jour pour la dernière fois par dena ponech, le il y a 18 années et 10 mois.

Voir les messages de 5 - 1 à 5 (sur un total de 5)

Auteur

Messages
19.07.2006 à 02:40 #34056

dena ponech
Participant

Hello all,

I am just trying out FlexPro 6 demo version and practiceing importing files. My x column contains a date and time, but it is in a different format than expected by the import wizzard. the string in the data looks like
‘ 22-Jun-2006 21:10:05 ‘
Is there a way to change the string format of the import wizzard??

Thanks

19.07.2006 à 02:40 #34060

dena ponech
Participant

Hello all,

I am just trying out FlexPro 6 demo version and practiceing importing files. My x column contains a date and time, but it is in a different format than expected by the import wizzard. the string in the data looks like
‘ 22-Jun-2006 21:10:05 ‘
Is there a way to change the string format of the import wizzard??

Thanks

19.07.2006 à 03:03 #34057

Bernhard Kantz
Participant

After the import you have the possibility to change the calendar time format.

Select the dataset and open the [b]Properties Window[/b] in the Context Menu.
Choose the tab [b]Formatting[/b].
Click the [b]Change…[/b] button and choose the tab [b]Calendar Time Value.[/b]

In this dialog you can choose your Calendar Time format.

support@weisang.com

19.07.2006 à 03:13 #34058

dena ponech
Participant

Thanks for the reply,

I have tried that, but it is not working, just get ?’s in the column.

When I import, I am choosing D M Y h m s for the format, should I choose something else? I only get ?’s in my x column when I do this.

Thanks
Dena

19.07.2006 à 21:33 #34059

Bernhard Kantz
Participant

the Ascii Import filter cannot import your data correctly (because of the language specific month format).
But there is a workaraound:
– Import the the column with the time values as strings. In this case you have to import the column as y-values.
– After the import you can convert the dataset with the strings to the data type Calendar time. (Context Menu|Properties|Data Types)

But this conversion is dependent on the OS local settings. For example the conversion of ‘Mar’ only works with an English OS.

support@weisang.com
Auteur

Messages

Voir les messages de 5 - 1 à 5 (sur un total de 5)

Vous devez être connecté pour répondre à ce sujet.