The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Date formatting (csv file)

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
LazareskiK Posted - 10/15/2018 : 09:09:47 AM
Hi everyone,

I am having hard time formatting the date column. First, i have imported a csv file, in which (checked in notepad++) the date format is dd.mm.yyyy. Then, i saw that the date column format is text & numeric (for example, 2,2062E7) and when i try to change it to date, the column cells change to --. Can you please help me out?

Thanks
4   L A T E S T    R E P L I E S    (Newest First)
LazareskiK Posted - 10/16/2018 : 04:45:39 AM
Hi Castiel,

Now it works perfectly.

Thanks
Castiel Posted - 10/16/2018 : 04:25:05 AM
quote:
Originally posted by LazareskiK

Hi James,

Still the same result. I tried every possible way, using the dialog as well as using the column options.

Regards


Seems to be caused by dot(.) as 1000 separator. Just check "Keep target column format" in Import Options of impCSV.




     #####
    #### _\_  ________
    ##=-[.].]| \      
    #(    _\ |  |------|
     #   __| |  ||||||||
      \  _/  |  ||||||||
   .--'--'-. |  | ____ |
  / __      `|__|[o__o]|
_(____nm_______ /____\____
LazareskiK Posted - 10/16/2018 : 02:05:42 AM
Hi James,

Still the same result. I tried every possible way, using the dialog as well as using the column options.

Regards
YimingChen Posted - 10/15/2018 : 10:01:07 AM
Hi,

Can you try define the custom format of your date values in import ASCII dialog? Thanks.


James

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000