How to save data with Double quotes in Azure cosmos DB

1k Views Asked by At

I am reading data from csv file . Part of the data contains quotation marks as <"1", "02/12/2018", "How to save "Quotation" marks">. After I read the data from csv I need to save it to a Azure CosmosDb collection using .Net code. The string -> How to save "Quotation" marks - gets retrieved in my code as:

How to save \" Quotation\" marks.

I think that is how double quotes is persisted in .net as (\") , so that should be okay. However , when I am saving this data in azure cosmos db using bulk Import, the data is saved in Cosmos db in the same format as:

How to save \"Quotation\" marks.

I want it to save it as:

How to save "Quotation" marks.

How is this possible as Power BI report will be generated again from this data, so string should be properly formatted.

0

There are 0 best solutions below