Hello, first of all, thank you for your time. This tool is realy good to me and saved my time a lot!

I saw some gaps when we are converting files directly instead of inline convertion:

• Manipulate CSV without a file saved, just for temporary manipulation
• Edit file, not save and then convert it, only saved changes will be converted

I think that we should convert inline but keep file convertion in a separated endpoint.
Or if there is a CSV file stored in hard drive, ask to user what he wants.

What do you think?

Describe the bug
Does not correctly convert CSV with escaped commas, quotes, and newlines. See RFC 4180 and Wikipedia.

The problem is in src/extension.js on line 40:

const arrays = csv.split("\n").map(user => user.split(","));

Recommend you use a CSV reader package like csv-parse.

To Reproduce
Steps to reproduce the behaviour:

1. Open attached
   csvbug.csv.txt. This file contains

id,text
1,some text without commas
2,"some text, with a single comma"
3,"text with a
carriage return"

2. Save as csvbug.csv. Note: GitHub won't allow me to attach a .csv file - hence renaming from the .txt extension.
3. Bring up the command palette using the keyboard shortcut Ctrl+Shift+P on Windows/Linux or Cmd+Shift+P or F1 on macOS.
4. Search for "Convert CSV to JSON" or "Convert JSON to CSV" on the dialog box that comes up, as the case may be, then press Enter.
5. Examine resulting csvbug.json.

Expected behaviour
csvbug.json file should contain something like

[
	{
		"id": "1",
		"text": "some text without commas"
	},
	{
		"id": "2",
		"text": "some text, with a single comma"
	},
	{
		"id": "3",
		"text": "text with a\ncarriage return"
	}
]

Instead it contains

[
	{
		"id": "1",
		"text": "some text without commas"
	},
	{
		"id": "2",
		"text": "\"some text"
	},
	{
		"id": "3",
		"text": "\"text with a"
	},
	{
		"id": "carriage return\""
	},
	{
		"id": ""
	}
]

Notice that

• text for line 2 is truncated and starts with a double quote.
• text for line 3 is truncated and starts with a double quote.
• there is an unexpected record with id == 'carriage return"'.
• there is an unexpected record with id == ''.

Desktop (please complete the following information):

• OS: Windows 10, OSX

Describe the bug
When opening a csv file and using the extension to convert to json, it shows the error "conversion to json failed".Detail: in windows it works normally.

To Reproduce
Steps to reproduce the behaviour:

1. I click F1 to open the palette;
2. I type the command "convert csv to json"
3. Scroll down to '....'
4. the error appears

Expected behaviour
A clear and concise description of what you expected to happen.

Screenshots
Anexado.

Desktop (please complete the following information):

• OS: Monterrey M1

Additional context

Add any other context about the problem here.

Description
After clicking Open Now button nothing happens

To Reproduce

1. open a csv file
2. Execute command: convert CSV to JSON
3. There is a popup with the message "Conversion to JSON successful "
4. Click on the Open Now button
5. Nothing happens, no json file is created in the workspace

Expected behaviour
A json file is created after clicking Open Now ans the JSON file is opened

Desktop :

• OS: Linux Ubuntu 20.04, KDE environment
• VsCode v1.47.2

Content of the csv file I used

"en","nl","fr"
"Save","Bewaren","Sauvegarder"
"Close","Sluiten","Fermer"

Describe the bug
I try to convert a large .csv and get:

Command 'Convert CSV to JSON' resulted in an error (Running the contributed command: 'csv.toJSON' failed.)

I've opened a 256MB file with ~444k lines. I've installed the extension (Ubuntu/WSL) and reloaded
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behaviour:

1. Open my file with ~ 444k lines
2. Press Ctrl-Shift-P to bring up the command pallet
3. Select "Convert CSV to JSON" using arrow keys
4. Press Enter
5. See error message

Expected behaviour
I expected a success message and a new window with the results or a prompt the new filename or something like that.

Screenshots

Desktop (please complete the following information):

• OS: Windows 10 19041.450, WSL 2, Ubuntu 18

Additional context
A sample line from the file:

6983,z100000010#subdomain3.domain3.com#[email protected]#2018-100000000,89501,8bb3c0ff-729e-4ae6-a4c2-12461589501,2019-05-25T00:00:00Z,darkwebbreach,Sandbox Demo Breach 1,"In 2018, this breach was discovered. It was added to the breach database in 2019.",null,2018-100000000,"email, password, password_hash, username, account_id",6983,z100000010,subdomain3.domain3.com,[email protected],158992310,8bb3c0ff-729e-4ae6-a4c2-12461589501,[email protected],6983#b100000010#158992310,158992310,null,null,null,external,12345,827ccb0eea8a706c4c34a16891f84e7b,[email protected],2018