Flat file import stripping backslash characters

[anthonydresser]

Azure Data Studio Version: Version: 1.22.0 (user setup) Commit: 77b9a708df3679c26a89ba24a070b3f7a078a510 Date: 2020-09-21T20:23:13.120Z VS Code: 1.49.0 Electron: 9.2.1 Chrome: 83.0.4103.122 Node.js: 12.14.1 V8: 8.3.110.13-electron.0 OS: Windows_NT x64 10.0.18363

Steps to Reproduce:

1. Prepare simple CSV file (UTF-8, CRLF) including file paths for import (or any other column containing backslash characters. (See attached "ads_import_test.txt" (renamed from .csv to allow for upload)).
2. Invoke flat file import wizard (i.e. right-click on target database, select Import Wizard)
3. Select import file and import database name and click Next to data preview.
4. Preview of column originally containing backslash characters contains no backslash characters
5. If import is completed, column is imported without backslashes.

Imports I am attempting to perform in this version are highly similar to previous import work performed successfully with previous versions. This is the first such import attempted on the current version of ADS, and the first time I have experienced this issue.

ads_import_test.txt

[adstestbot[bot]]

Thanks for submitting this issue. Please also check if it is already covered by an existing one, like:

• Azure Studio Import Wizard Not Importing Column Names (#8866)
• import data to a table (#8912)
• File File Import Wizard fails when column count is inconsistent (#3654)
• Import Flat File Wizard Fails on Single Column File (#3000)