Forum Discussion
Double quotations appearing in an Excel .txt delimited file
I am attempting to upload a delimited .txt file to a website. The website has very specific instructions as to how that file should be formatted. Part of that formatting is that every entry should be separated by a single quotation ("), then the entry, followed by another quotation (") then a comma (,), and then the next entry begins and so on. When I open my file in text import wizard, step 1, shows, opening double quotations ("") entry, then closing double quotations ("") and a single comma (,). Step 2 of 3 then shows Delimiters with the tab box checked, and the text qualifier box showing a single quotation ("). The entries in the view box appear as I want them (") entry (") (,) Step 3 of 3 shows the same highlighted in black, with column data format set to General, and date set to mdy. Again, at this stage, just single quotations (") on either side of each entry. When I hit finish, it opens up the excel file, again, showing the quotations as required ("), and the comma (,).
I then upload this to website, and it is rejected. The website provides an error log, which shows double quotations ("") on either side of all entries, and a single comma (,). Does anybody know what I am doing wrong to cause this, please? Thank you in advance!
1 Reply
What do you see if you open the text file in Notepad? If you see ""..."",""..."", then you can use Notepad to replace "" with ". After saving the file, it should upload to the website.