Forum Discussion

eniX's avatar
eniX
Helper III
8 years ago
Solved

QuoteStyle.None doesn't work

  Sample data look like following:   column_1;column_2;column_3; A;1;1 B;2;2 C;"3;3 D;4;4   I would like to load this data and ignore quotes, beause quotes are in the data, it's not a field qu...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi eniX,

     

    I have reported this issue to the Product Team: CRI 78250455. I will update the latest news here.

     

    Best Regards,

    Dale

  • Ehren's avatar
    Ehren
    8 years ago

    Hi eniX. If you look at the latest documentation in the product (by creating a new blank query and typing = Csv.Document), you should see an updated description for QuoteStyle. The MSDN documentation hasn't yet been corrected, but I'm following up on this.

     

    Despite its name, the QuoteStyle option in Csv.Document controls how linebreaks within quotes are handled, not whether or not quote characters are supported.

     

    To ignore quotes altogether, you'll need to use the Split Column approach suggested by v-jiascu-msft.

    Ehren

Ehren's avatar
Ehren
Microsoft Employee
8 years ago

Hi eniX. If you look at the latest documentation in the product (by creating a new blank query and typing = Csv.Document), you should see an updated description for QuoteStyle. The MSDN documentation hasn't yet been corrected, but I'm following up on this.

 

Despite its name, the QuoteStyle option in Csv.Document controls how linebreaks within quotes are handled, not whether or not quote characters are supported.

 

To ignore quotes altogether, you'll need to use the Split Column approach suggested by v-jiascu-msft.

Ehren

eniX's avatar
eniX
Helper III
8 years ago

Thank you for clarification & the trick!