IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only

  • 1.  handling csv files

    Posted 07/15/05 09:44 AM

    Originally posted by: SystemAdmin


    Has anyone successfully parsed a csv file prior to processing, especially one that contains double quotes as part of the data element? Knowledge base article T701 answers the question when there is a comma as part of the data element, but this will not work for fields that contain double quotes and are therefore surrounded by double quotes and the embedded double quotes are represented by a pair of double quotes. If the delimiter is included in the initiator and/or terminator there is a problem with identifying the first and last data element.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: handling csv files

    Posted 07/15/05 09:59 AM

    Originally posted by: SystemAdmin


    yes i have...i have developed a process that takes a xls file...runs a batch file that runs a .NET executable that saves the xls file as a comma delimited. Then i have map that takes the csv file and converts that to a proper comma delimited file with quotation's around every field. Its quite a neat process. I can give you some pointers if you wish...just email me at kporter@globalcare.net

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


Related Content