You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to surround double quotes when using data management to export data to file?

Hello everyone,

I am using data management to export data from the OFS cube to a CSV file.

I am setting up my data file's column delimiter is ",".

However, when I checked the exported file, I found that if the member name includes a comma, the data was not enclosed in double quotes :

For example:

In the exported file, it showed Depreciation -Land, Building and Building Improvements instead of "Depreciation -Land, Building and Building Improvements".

It makes it difficult to parse this file.

What should I do to surround the double quotes?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!