none
How save Strings without ' " ' chars using Text outputter?

    Question

  • Hi!

    When i try save my rowset using Text outputter, all my strings are saved in file between characters  '"' (e.g. "Text in file"). How save Strings without those characters?

    Sunday, April 17, 2016 8:27 PM

Answers

  • The default outputters support a bool parameter called quoting that controls whether fields are quoted. The default is set to true, but you can override the value to disable the quoting behavior as the example below demonstrates:

    OUTPUT @rowset
        TO @"/output.tsv"
        USING Outputters.Tsv( quoting: false );

    Sunday, April 17, 2016 8:54 PM
    Moderator

All replies

  • The default outputters support a bool parameter called quoting that controls whether fields are quoted. The default is set to true, but you can override the value to disable the quoting behavior as the example below demonstrates:

    OUTPUT @rowset
        TO @"/output.tsv"
        USING Outputters.Tsv( quoting: false );

    Sunday, April 17, 2016 8:54 PM
    Moderator
  • Please note that if you turn quoting off, you may not be able to roundtrip your column delimiters, unless you specify an escapeCharacter to escape the delimiter.

    See https://msdn.microsoft.com/en-us/library/azure/mt621366.aspx


    Michael Rys

    Monday, April 18, 2016 6:44 AM
    Moderator