importing date and time

Dieses Thema hat 4 Antworten sowie 2 Teilnehmer und wurde zuletzt vor vor 18 Jahren, 10 Monaten von dena ponech aktualisiert.

Anzeigen von 5-Stellen - 1 bis 5 (von insgesamt 5)

Autor

Beiträge
19.07.2006 um 02:40 Uhr #34056

dena ponech
Teilnehmer

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 um 02:40 Uhr #34060

dena ponech
Teilnehmer

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 um 03:03 Uhr #34057

Bernhard Kantz
Teilnehmer

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 um 03:13 Uhr #34058

dena ponech
Teilnehmer

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 um 21:33 Uhr #34059

Bernhard Kantz
Teilnehmer

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
Autor

Beiträge

Anzeigen von 5-Stellen - 1 bis 5 (von insgesamt 5)

Du musst angemeldet sein, um auf dieses Thema antworten zu können.