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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Handling data field containing a comma while generating CSV files using etext templates in BI Publis

    edited Jun 23, 2018 1:23PM in Reporting and Analytics for HCM 3 comments

    Summary

    Handling data field containing a comma while generating CSV files using etext templates in BI Publisher

    Content

    Hi,

    I have an etext template to create a .csv (comma seperated values) file.
    Now say I have 2 fields DEPT_NAME and DEPT_CODE.

    Now if I have a DEPT_NAME like say - "Finance Department,US" and when my CSV file is opened in MS Excel, the DEPT_NAME breaks to appear in 2 Columns since the seperator is ",".

    Although I think such naming conventions wouldn't be used in PRODUCTION and an hyphen (-) would be used instead, can you please tell me if any work around exists?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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