locked
CSV Render format with no FieldDelimiter or TXT Render format? RRS feed

  • Question

  • I have created a report that contains the spaces to make it fixed width. I need to tweak the CSV extension render to export to a txt or csv but without using a delimiter. Is that possible? A space or tab messes it up so I actually need NO FieldDelimiter. Can I do this with CSV or is there a TXT render extension?

     

    Wednesday, May 25, 2011 9:48 PM

Answers

  • Hi,

    Based on your description, I tried to change the FieldDelimiter in the device information settings of CSV rendering to (NULL)

    <FieldDelimiter xml:space="preserve">&#00;</FieldDelimiter>.

    However, it still uses a space as field delimiter when exporting the Report to CSV.

    So, this behavior might be by design since generally the purpose of a delimited render is to enable other products to import that data.

    Currently, I’m afraid you need to modify the fields contains spaces in the report. If there is a better solution available, I will let you know at first.

    Thanks,
    Tony Chain


    Tony Chain [MSFT CSG] | Microsoft Community Support
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Marked as answer by Tony Chain Friday, June 3, 2011 9:17 AM
    Friday, May 27, 2011 1:53 AM