.Csv Export Issue
adi26Jan 13 2010 — edited Mar 1 2010One 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.