Hi

I would not think so. You can check the commons csv what is supports.
Otherwise you can also just do a search replace on the first line to
change the | to , in the header line so they use the same delimiter

On Fri, Feb 24, 2017 at 7:00 AM, Juno <[email protected]> wrote:
> Is it possible to set the delimiter of the header and the delimiter of the
> csv file contents differently when storing it in the message queue with csv?
>
> For example, I want to set the delimiter of the header to '|' and the
> delimiter of the body to ','.
>
> Header1 | Header2 | Header3 | Header 4 | Header5
> Row1-1, row1-2, row1-3, row1-4, row1-5
> Row2-1, row2-2, row2-3, row2-4, row2-5
> Row3-1, row3-2, row3-3, row3-4, row3-5
> .
> .
> .
>
>
> The camel route configuration is shown below.
>
> <route id="route_DB2CSV">
>         <from uri="timer:case_002?period=30s" />
>         <to
> uri="mybatis:com.test.SampleMapper.selectList?statementType=SelectList&amp;consumer.useIterator=false"
> />
>         <marshal>
>                 <csv delimiter="|">
>                         <header>CHARGE_ID</header>
>                         <header>AUTHPOLICY_SEQ</header>
>                         <header>UPMU_CD</header>
>                         <header>CHARGE_NM</header>
>                         <header>HTEL</header>
>                         <header>EMAIL</header>
>                 </csv>
>         </marshal>
>         <marshal ref="testCrypto" />
>         <to uri="activemq:queue:OUT_BOUND_DB2CSV" />
> </route>
>
>
> With this setting, both the header and delimiter of the body are '|' .
>
> Thank you for your kind comments.
> Thank you.
>
>
>
> --
> View this message in context: 
> http://camel.465427.n5.nabble.com/Is-it-possible-to-set-the-delimiter-of-header-and-body-of-csv-file-differently-tp5794375.html
> Sent from the Camel - Users mailing list archive at Nabble.com.



-- 
Claus Ibsen
-----------------
http://davsclaus.com @davsclaus
Camel in Action 2: https://www.manning.com/ibsen2

Reply via email to