LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Output delimited file (.csv) automatically changing CCYY-MM-DD format to DD/MM/YYYY

    Employee
    Posted 01-09-2014 22:41

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: vTaylor

    I am outputting a field BUSINESS_DAY as a string with the format CCYY-MM-DD using the output delimited node. The file name is DAY.csv.
    BUSINESS_DAY
    2013-10-11
    2014-01-08
    2014-01-07
    2014-01-06
    2013-12-30


    When I open the saved .csv file the format has changed to DD/MM/YYYY.
    BUSINESS_DAY
    11/10/2013
    08/01/2014
    07/01/2014
    06/01/2014

    Is there a way to force the output file to maintain the format input?


  • 2.  RE: Output delimited file (.csv) automatically changing CCYY-MM-DD format to DD/MM/YYYY

    Employee
    Posted 01-10-2014 06:21

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ejones

    The change in format may be something that is being done by the program you are using to view the CSV file. MicrosoftExcel will usually change the date format and display it in the format the Windows operating system is configured to use by default. It does other things that can be maddening or helpful depending on the context like removing zeroes from the beginning of numbers and changing numbers with many digits to scientific notation.

    The best way to be sure that the format is being written to the CSV file in the format you want is to view the file in a text editor. In Windows you could use Notepad or the old "type" command at the Dos prompt, in Unix/Linux I often use vi but there are other ways to view text files. And I often use WinSCP to connect to Linux/Unix servers which has a good text editor.