Since it seems your file has a well defined structure, why not map it to bindy or csv dataformat first.
Then you will have a list of rows which you can filter out in some way. But do you know in advance how many type of collections you are interested in? On Wed, Apr 26, 2017 at 6:58 PM, Gary [via Camel] < ml+s465427n5798339...@n5.nabble.com> wrote: > hello, thanks in advance, just looking for advice with camel, pondering > ideal approach. > > I have big data files, that need to be split in to their own iostreams or > files based on a field in the inbound message. > > example: message: > 9VXI1148,2/15/2016 9:55,Hydraulic Brake Temperature,0 > 9VXI1148,2/15/2016 9:55,HP Feedback,262.7061768 <(262)%20706-1768> > 8TI999,2/15/2016 12:36,Hydraulic Brake Temperature,0 > 8TI999,2/15/2016 12:36,HP Feedback,762.9597778 <(762)%20959-7778> > TE1430B,2/15/2016 12:36,Hydraulic Brake Temperature,0 > TE1430B,2/15/2016 12:36,HP Feedback,5.79165554 > 9TI1151,2/15/2016 12:25,Hydraulic Brake Temperature,0 > 9TI1151,2/15/2016 12:25,HP Feedback,1952.955078 > ... > > I need to split the message based on the first field/column in the csv. so > the output would be separate collections lists on the exchange such as > > split 1 ( all records holding 9VXI1148 ) > split 2 ( all records holding 8TI999 ) > split 3 ( all records holding TE1430B ) > etc... > > is there an easy approach for camel to do this? I somehow, need to get > ahold of field 1 of each record and build a collection and send it out when > done. what is an approach to get the pivot field from the message and then > form out bound collections? > > thank you > Gary Lee Mills > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > http://camel.465427.n5.nabble.com/camel-splitter-tp5798339.html > To start a new topic under Camel - Users, email ml+s465427n465428h31@n5. > nabble.com > To unsubscribe from Camel - Users, click here > <http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=465428&code=c291Y2lhbmNlLmVxZGFtLnJhc2h0aUBnbWFpbC5jb218NDY1NDI4fDE1MzI5MTE2NTY=> > . > NAML > <http://camel.465427.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://camel.465427.n5.nabble.com/camel-splitter-tp5798339p5798358.html Sent from the Camel - Users mailing list archive at Nabble.com.
