IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Excel CSV delimiter

    Posted Thu November 02, 2017 01:43 PM

    Originally posted by: maddysam


    Can someone help if there is any specific/dedicated terminator defined for group that has imported from Excel CSV file.


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  Re: Excel CSV delimiter

    Posted Fri November 03, 2017 05:47 AM
      |   view attached

    Originally posted by: PaulBrett


    An Excel file exported as CSV gets a line delimiter of <CR><LF>.  That delimiter is also included at the end of the file, and so could be defined as a row terminator.  My preference would be to use it as a delimiter / postfix, as per attached example.

    Thank you.

    Paul

    Follow me on Twitter


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender

    Attachment(s)

    zip
    Book1.zip   1 KB 1 version