Wednesday, May 7, 2008

Insert New Line Character in BPEL Payload

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 
.

20 comments:

Marinus Snyman said...

Thanks for this post! You saved me a day before my presentation!

Unknown said...

This has been very helpful. Thanks.

Thiago Lechuga said...

Nice.
I had da same problem with ESB BPEL.
You just saved a lot of time here.
Thanks :)

Unknown said...

Thanks a lot it worked for me also.

Unknown said...

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

Unknown said...

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

Anonymous said...

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

Ramya Krishnan said...

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

sakthi said...

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

gowsalya said...

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

Unknown said...

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




sheela said...

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

riya said...

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

eTechno Soft Solutions said...

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.

aarthi said...

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

Data Science Course in Bhilai - 360DigiTMG said...

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

KITS Technologies said...

Thank you ever so for you article.Much thanks again. Want more.
sccm training
sccm online training

360DigiTMG said...

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

Unknown said...

Thanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post with people.. business analytics course in mysore

Unknown said...

I have read your article, it is very informative and helpful for me.I admire the valuable information you offer in your articles. Thanks for posting it.. data science training in kanpur