Data with embedded seperators #1
Description
When the data contains the character that is used as a seperator (a comma by default), it adds unwanted extra column(s) in that row, messing up subsequent columns.
Example: if you replace "John Smith" with "Smith, John" in example3.txt, the name column will contain just Smith.
The State wille be John, and the telephone number wil be WA.
{
"Name": "Smith",
"STATE": "John",
"TELEPHONE": "WA"
}