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

    • Access Log .csv column delimiter issue

    in EPM Platform and Freeform 2 comments

    Summary:

    I have an EPM Automate script that downloads Access Log files from the app (I followed an Oracle provided example), and this works great. A problem arises when some fields within the file contain quotes and commas. Excel, python, etc don't parse the columns correctly, and, instead of 11 columns, there are up to 14+ columns, in some cases, because the content of the field contains quotes and commas.

    Example row in the file:

    2024-mm-dd,hh:mm:ss,"/HyperionPlanning/efsuirest/v3/internal/applications/appname/objects/?q={objectType:{$in:["Folder","Report"]},"parentId":""}&limit=5000",200,0.123,123,123.123.123.123,"userid","Planning","Objects: Retrieve",""

    In the example the URI field (column 3) contains ["Folder","Report"],"parentId":""} and this value is split into Folder and Report and parentId because of the quote and comma delimiter.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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