Export from Excel for Stock Code Import

millennium.atrex

Thread Starter: John Lange Started: 8/25/2010 8:27 PM UTC

Replies: 2

8/25/2010 8:27 PM UTC

Export from Excel for Stock Code Import

Reply Quote Delete

John Lange

Trying to imprt 18,000+ Stock Codes that I get in an Excel spreadsheet. When I export to Tab Delineated I get extra " on various fields. Don't have them in the spreadsheet, but the export has them.

The only instance I can see that is consistant is if the feild has a " in it somewhere.

HOWEVER

I get them in the text file for unknown reasons too, straight text no punctuation.

hmmmmm anyone have a clue?

8/25/2010 8:50 PM UTC

Re: Export from Excel for Stock Code Import

Reply Quote Delete

Terry Swiers

John,

Trying to imprt 18,000+ Stock Codes that I get in an Excel spreadsheet. When I export to Tab Delineated I get extra " on various fields. Don't have them in the spreadsheet, but the export has them.

That doesn't sound like a Tab Delimited file, but rather a comma delimited file format. Tab delimited shouldn't add the wrapping " characters during the save.

--

---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com

Now shipping Atrex 13. For more information go to
http://www.atrex.com/news.asp

Atrex Electronic Support Options:
Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
Email: mailto:support@atrex.com
Newsgroup: news://news.1000years.com/millennium.atrex
Fax: 1-925-829-1851
Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
---------------------------------------

8/29/2010 4:25 AM UTC

Re: Export from Excel for Stock Code Import

Reply Quote Delete

Todd Patterson

Trying to imprt 18,000+ Stock Codes that I get in an Excel spreadsheet. When I export to Tab Delineated I get extra " on various fields. Don't have them in the spreadsheet, but the export has them.

The only instance I can see that is consistant is if the feild has a " in it somewhere.

HOWEVER

I get them in the text file for unknown reasons too, straight text no punctuation.

hmmmmm anyone have a clue?

Yup, we have the same issue.

In your file that you are saving to text Excel adds the " to anything that has got a comma in it. What we have found is that once we save the file we open it in Notepad and do a Search and Replace. Then we just replace all of the quote characters with a blank.

Then it will import the right way.