2 Replies Latest reply on Jan 16, 2014 7:04 AM by richard.holmes

    How can you handle a comma in a users name when outputting CMR in CSV format?

      A customer has raised a case concerning a user that has a comma that appears in their name.

       

      This is apparently causing issues with the output of their CMR report in the CSV format as the extra comma is being read a column separator.

       

      Is there any way around this?

      Is there any way to modify the way this is handled when setting up CMR (possibly via the admin console)?

       

      Case: Comma in user's name treated as escaping in CSV export

       

      Example: comma_name.PNG.png

       

      Any and all thoughts on this would be appreciated.

      (My initial thinking was to simply remove the comma from the name, but I need to ask if there is any way of already handling this)

       

      Cheers

       

      Richard