Writing table variables with quotations marks ("Placeholder variable name")

13 views (last 30 days)
Hi.
When loading, manipulating and subsequently writing a table (readtable, writetable) my column/variable names are saved to .csv files with no quotation marks surround them.
E.g.:
Reading variable names like: ["id","frame","x","y","sigma","intensity"]
and subsequently saving them as: [id,frame,x,y,sigma,intensity]
This causes issue with my further use of the tables. I could manually edit, but would prefer to be able to bulk process.
Cheers.

Answers (1)

Stephen23
Stephen23 on 15 Aug 2019
Edited: Stephen23 on 15 Aug 2019
'QuoteStrings',true
Otherwise it is likely not difficult to write your own file using fprintf.
  1 Comment
Aske Ejdrup
Aske Ejdrup on 15 Aug 2019
Edited: Aske Ejdrup on 15 Aug 2019
'QuoteStrings',true
That only seems works for cells of the table, not the variable names themselves.
I'm not familiar with writing to .txt or .csv with fprintf but will give it a shot if no "quick fix" is possible.
Thanks

Sign in to comment.

Categories

Find more on Tables in Help Center and File Exchange

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!