locked
Saving as CSV question RRS feed

  • Question

  • User-2060727494 posted

    I have a report with a blank column.  I have nothing defined for this column.  No field name or constant defined.  When I save as a csv file, I want a comma to appear for this field.  But presently, it does not do this by instead has the next field displaying.  I tried making the field value as ="," but then it literally displays it just like this with the double quotes.  I hope this makes sense.  So how can I force in a comma for a field with no value?

    Friday, September 26, 2014 7:45 AM

Answers

  • User-2060727494 posted

    I figured out a way to do this.  I created a column in my SELECT statement like: NULL AS DurLab.  I then add DurLab to my report layout and when I save it as CSV, the comma now exists for this blank column.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, September 26, 2014 1:06 PM

All replies

  • User-2060727494 posted

    I figured out a way to do this.  I created a column in my SELECT statement like: NULL AS DurLab.  I then add DurLab to my report layout and when I save it as CSV, the comma now exists for this blank column.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, September 26, 2014 1:06 PM
  • User260886948 posted

    Hi bobh0526,

    Well Done!

    It is very kind of you to share the solution to us.

    Best Regards,
    Amy Peng

    Saturday, September 27, 2014 12:51 AM