8 Replies Latest reply on Mar 10, 2017 1:38 PM by Cheng Fang

    No extra quotes in data

    sunitha N Newbie

      This is my jsl  .I kept an option to remove extra quotes on data STRICT_CHECK_FOR_QUOTING=true

      <writer ref="jacksonCsvItemWriter">

        <properties>

        <property name="resource" value="#{jobProperties['deliveryFilename']}" />

        <property name="writeMode" value="overwrite" />

        <property name="columnSeparator" value="|" />

        <property name="beanType" value="java.util.Map" />

        <property name="useHeader" value="false" />

        <property name="csvGeneratorFeatures" value="ALWAYS_QUOTE_STRINGS=false, STRICT_CHECK_FOR_QUOTING=true"/>

        <property name="columns" value="

        NAP004_FACL STRING,

        NAP004_FACL_NAME STRING,

        NAP004_ITEM STRING,

        NAP004_ITEM_DESC STRING,

        NAP004_VENDOR STRING,

        NAP004_VENDOR_NAME STRING,

        NAP004_EFF_DATE STRING,

        NAP004_END_DATE STRING,

        NAP004_AMOUNT STRING,

        NAP004_PERCENT STRING,

        NAP004_PROMO_ID STRING,

        NAP004_VENDOR_DEAL_NUM STRING,

        NAP004_SOURCE STRING,

        NAP004_FILLER STRING

        "/>

        </properties>

        </writer>

       

       

      output data  which is there in  extra quotes need to be removed