Text field in table visualization - need to wrap text in double quotes upon export

[ianmonat]

Hello,

Looking to do a seemingly simple task that has proven difficult.

I have a table vizualization with some fields (see below). I need to export this data table to a .csv, and then convert it to a .txt file. (i do this by just renaming the .csv file extension after the export)

I need the values below, to be wrapped in quotes in the .txt file, so for example, the first Cust No. value should read "102" in the text file.  

table visualization screenshot - need these fields wrapped in quotes

I can wrap these values in quotes using the following formula: QuotesCustNo = """" & ShipTable[Customer] & """"

(note: Cust No. is an alias for ShipTable[Customer]) 

This works, but unfortunately, it works in Power BI only. When I export to .csv and then convert to .txt, the output looks like this:

I've tried to create a column that contains all double quotes and use the CONCATENATE formula with the Cust No. column, but no luck there either. 

I've also tried combining 2 single quotes in the folrmula above thinking I could trick Power BI into displaying a double quote, but it still looks like two, distinct single quotes.

I've seen other threads that are similar but they are not trying to accomplish this specific objective so I thought I'd create a new thread. 

Help please! @MattAllington are you around? -Ian 

[v-yulgu-msft · Accepted solution]

Hi @ianmonat,

I was able to reproduce this problem, when using the Export to CSV feature on the visuals, they get all the extra """" characters in csv file. Oneworkaround is to open CSV file in notepad, then replace all """ with "".

Regards,
Yuliana Gu