homepage Welcome to WebmasterWorld Guest from 54.226.136.179
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
Excel/text file problem. Any ideas?
dickbaker

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 4616283 posted 8:06 am on Oct 12, 2013 (gmt 0)

I have a large text file of product descriptions by part number that I got from my distributor. I need to bring it into Excel and save it as a csv file.

After the first try, I discovered that Excel had cut short the descriptions on a lot of products. It didn't have to do with the length of the description, as some products had many sentences, and others got cut off after one or two. It must have something to do with the formatting of the text file.

I looked at the text file, and the full descriptions are there. I tried using an existing csv file with long descriptions, eliminating all but three or four rows just to make it manageable, and then importing the product description text file. It still cut off the descriptions, and on the same products. It's the same ones each time.

Does anyone have any idea as to what the problem might be, and if there's a way to solve it?

 

lucy24

WebmasterWorld Senior Member lucy24 us a WebmasterWorld Top Contributor of All Time Top Contributors Of The Month



 
Msg#: 4616283 posted 8:52 am on Oct 12, 2013 (gmt 0)

Does anyone have any idea

File encoding or unauthorized characters.

That's my generic diagnosis of all mysterious text problems ;) Sometimes it really does turn out to be something as embarrassingly simple as a hard line break in the wrong place.

When it cuts off, is it always in the same place? For example: you feed in records 3 through 10, and something in #7 gets cut off. If instead you try records 6 through 16, does #7 still get cut at the same point?

dickbaker

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 4616283 posted 5:38 pm on Oct 12, 2013 (gmt 0)

The rows with cut sentences are random. There's no discernible pattern I can see.

You may be right about hard line breaks. With 53,000 rows, it would be difficult to find all of them. I need to get the text into some program that will strip out any previous coding.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved