Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
Received-SPF: pass (athena.apache.org: domain of claus.ibsen@gmail.com
 designates 209.85.215.47 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKaKsvGif3O=nLP5205QSf3RY5=XnbGgZdgUU7HpG=TBw+J-Sg@mail.gmail.com>
References: 
 <CAKaKsvGif3O=nLP5205QSf3RY5=XnbGgZdgUU7HpG=TBw+J-Sg@mail.gmail.com>
From: Claus Ibsen <claus.ibsen@gmail.com>
Date: Sun, 6 Jan 2013 11:30:28 +0100
Message-ID: 
 <CAGB5yNkgHzpqRFObDftu1NWcB_spY85EpiveN-hNm84-x-7N5A@mail.gmail.com>
Subject: Re: unmarshall csv problem with bindy
To: users@camel.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hi

Yeah I think bindy has some issues with parsing data that has optional quotes.

We recently fixed an issue and improved the quote parsing. But there
was an incompatible change so it was only applied on trunk, eg Camel
2.11.

I suggest if you got a bit of time, to try your code against Camel
trunk and see if that fixed your use-case as well.
If not, then feel free to log a JIRA ticket. So we can get it fixed in 2.11.


On Thu, Jan 3, 2013 at 4:14 AM, Ramiro <ramirobot@gmail.com> wrote:
> Im working with Karaf 2.2.10 and Camel 2.10.1. I receive a file, parse the
> csv to a pojo, and do some other suff. My problem is that if a field in a
> record on the csv ends with a coma like the third field here:
>
> someFieldValue,someOtherFieldValue,"aaaa ,",moreStuff
>
> It puts together aaaa , with moreStuff in a single field(ignoring the
> second quote). But if i add something like:
>
> someFieldValue,someOtherFieldValue,"aaaa , bbb",moreStuff
>
> It gets processed without a problem(aaaa , bbb in a field, moreStuff in
> another). Seems like Camel is interpreting the ," pair like something to
> escape.
>
> Im using comma as the separator, and i've tried with other separators and
> setting the quote attribute of the @CsvRecord to single and double quotes.
>
>
> Is this expected behaviour, or some known bug? Any workarounds?


-- 
Claus Ibsen
-----------------
Red Hat, Inc.
FuseSource is now part of Red Hat
Email: cibsen@redhat.com
Web: http://fusesource.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen