Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

.Csv Export Issue

adi26Jan 13 2010 — edited Mar 1 2010
One of my exports to Hyperion Planning require me to send a CSV exports which is fine but there is a problem. Some of the nodes have formulas associated with it and have commas in them because of which the Csv file becomes really bad. For every comma, the string after that is put into another field.

I had this issue where multiple UDAs were present in one field and were separated by commas but I used the pivot feature for it where it basically divided the UDAs into two separate rows.

However, this is a formula and needs to come in one row. I have tried to check the quote strings option but it does not help.

Is there anyway to resolve this issue? Thanks a lot.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2010
Added on Jan 13 2010
7 comments
2,821 views