Why when opening a txt file, you loose the ',' character

Question

If the file says Jerry, David, Joy

When you read it in it translates it to

Jerry David Joy

This is related to working with csv files by renaming it from csv to txt

A work around is once it is opened, cut and paste the file with the ",' characters

Answer 1

CSV means comma-separated values. So your file containing "Jerry, David, Joy" means for a CSV file that you have 3 values there "Jerry", "David" and "Joy". The comma is not part of the values, it is the separator.

If you want to have the commas to be part of the value, you can change how you parse your file and instead of a comma, you could use a different separator, e.g. semicolon (;) or TAB, etc.

I hope this helps.

Good luck!