Today my colleague has an interesting requirement. He need to interact with a legacy application which accepts input in CSV format. In the input first row should contain operation name, second row should contain all the column names and the next row is the data row. He was using Oracle BPEL to integrate legacy application with new application infrastructure. He was having data in a canonical business object and want to generate the required input CSV format.
The major challenge for him was to transform the business object into the input CSV which is having three rows. As he was a Java developer in the past, he tried using \n to insert new line character with no luck. Then he tried which is the correct one to insert a new line character in an XML payload but when he executed the BPEL flow, 
 was inserted rather than the line break.
The trick to insert the new line character in XML payload from Oracle BPEL is to append in the from expression of assign activity, then check your .bpel file it would have 
 rather than because Jdeveloper replaces & with its equivalent escape character &. You need to replace & with & so it would become the correct new line character .
18 comments:
Thanks for this post! You saved me a day before my presentation!
This has been very helpful. Thanks.
Nice.
I had da same problem with ESB BPEL.
You just saved a lot of time here.
Thanks :)
Thanks a lot it worked for me also.
Hi .. Very Urgent Please :
I am using a concat() funtcion with append in Bpel , and i need to insert a new line character after a string .
Eg: concat('String1','String2', '\n').
I couldnt insert new line using the &13#; i have tried it witha nd without quotes
There are 2 things to keep in mind while inserting new line character:-
-use a transformation file
- go to source in transformation file to enter the value '
' and dont go to design view after editing the newline feed as the design view alters the value of newline feed and you will have to correct it again
Excellent blog post! Stimulates me to read much more of your work. I’ll bookmark your page so I can go back here.
www.n8fan.net
i went through your blog, thanks for your technical information. really useful for me.
once again thanks for your valuable info and time.
Java Training in chennai
Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information.
rpa training in chennai
rpa training in bangalore
rpa course in bangalore
best rpa training in bangalore
rpa online training
Really you have done great job,There are may person searching about that now they will find enough resources by your post
Devops Training courses
Devops Training in Bangalore
Best Devops Training in pune
Devops interview questions and answers
Thanks a lot for sharing us about this update. Hope you will not get tired on making posts as informative as this.
Data Science course in Indira nagar
Data Science course in marathahalli
Data Science Interview questions and answers
Data science training in tambaram | Data Science Course in Chennai
Data Science course in btm layout | Data Science training in Bangalore
Data science course in kalyan nagar | Data Science Course in Bangalore
A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.
Best Devops training in sholinganallur
Devops training in velachery
Devops training in annanagar
Devops training in tambaram
All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.
Data Science Training in Chennai
Data Science training in kalyan nagar
Data science training in Bangalore
Data Science training in marathahalli
Data Science interview questions and answers
Data science training in bangalore
Really very nice blog information for this one and more technical skills are improving, I like that kind of post.
Best SAP Training in Bangalore for SAP, we provide the sap training project with trainers having more than 5 Years of sap training experience, we also provide 100% placement support.
cool stuff you have and you keep overhaul every one of us
Java training in chennai | Java training in bangalore | Java training in hyderabad | Java training in coimbatore | Java training in online
Highly appreciable regarding the uniqueness of the content. This perhaps makes the readers feels excited to get stick to the subject. Certainly, the learners would thank the blogger to come up with the innovative content which keeps the readers to be up to date to stand by the competition. Once again nice blog keep it up and keep sharing the content as always.
Data Science training
Thank you ever so for you article.Much thanks again. Want more.
sccm training
sccm online training
I want you to thank for your time of this wonderful read!!! I definately enjoy every little bit of it and I have you bookmarked to check out new stuff of your blog a must read blog!
data analytics courses in hyderabad
Post a Comment