I am saving the output of my program in .csv file.
I need to save a variable's value in one column, but the value may contain comma.
When the program encounters a comma it places half of the variable's value in
the next column.

Is there any way through which I can avoid the placement of value in the next column..

9 Years
Discussion Span
Last Post by Alex Edwards

Put the thing in quotes
1,"hello, world",2
would be 3 columns.

Use excel to save a simple csv format file with a field containing a comma.


If double quotes are used it prints the variable name instead of value...


Interesting that you want to use a format specifically meant for separating individual values with commas, but need to retain information with commas inside it.

A good way of doing this would be to make your own tokenizer and only parse information when a stack is empty.

When you encounter quotes, push it onto the stack and read characters contiguously, even if it is a comma.

When you encounter quotes again, pop the original quote off of the stack and let your custom tokenizer do its thing, like normal.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.