You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by "raghavender.anthwar@gmail.com" <ra...@gmail.com> on 2016/10/14 12:07:57 UTC

Re: Need help in processing comma seperated text file

Can someone guide me on this?

Thank you.



--
View this message in context: http://camel.465427.n5.nabble.com/Need-help-in-processing-comma-seperated-text-file-tp5787930p5788783.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Need help in processing comma seperated text file

Posted by "raghavender.anthwar@gmail.com" <ra...@gmail.com>.
Thanks a lot for the response. Initially I thought of using BeanIO itself but
my data format is not exactly delimited format. As per my understanding, to
use BeanIO we should specify the format in the mapping xml.

Since I've the below elements in my text file, am not sure which one to go
with. Also am not sure how to read the elements: Runtime, Task, Data
dynamically as they are interrelated with index.

[Runtime] 
Date=ASAP 
Time= 
AllowErrors=FALSE 

[Task.1] 
Server=Item Master 
Module=ItemPOSIdentity 
Operation=addupdate

[Data.1] 
ItemPOSIdentity,100001108,,400000087320,UPC 
ItemPOSIdentity,100001108,,400000087337,UPC 
temPOSIdentity,100001111,,400000087325,UPC 
ItemPOSIdentity,100001111,,400000087335,UPC 

[Task.2] 
Server=Item Master 
Module=ItemPOSIdentity 
Operation=delete

[Data.2] 
ItemPOSIdentity,100001108,,, 
ItemPOSIdentity,100001111,,, 



--
View this message in context: http://camel.465427.n5.nabble.com/Need-help-in-processing-comma-seperated-text-file-tp5787930p5788947.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Need help in processing comma seperated text file

Posted by Ranx <br...@gmail.com>.
You can use Bindy though I've had better luck with the mapping in Beanio. 
Start with that first and then look at using a splitter/tokenizer to process
your files or write them out in the new format you require.

Just create a mapping file and a sample with a few records in it and run a
unit test to write the results out.



--
View this message in context: http://camel.465427.n5.nabble.com/Need-help-in-processing-comma-seperated-text-file-tp5787930p5788812.html
Sent from the Camel - Users mailing list archive at Nabble.com.