Results 1 to 21 of 21
  1. #1
    Member
    Join Date
    January 18th, 2005
    Posts
    145
    I am having problems with excel - when there is a large amount of text in a cell, it is truncated to a maximum of 256 characters - so I am losing some of the descriptive text in datafeeds.

    Anyone else figured out how to beat this problem?

  2. #2
    ABW Ambassador Radegast's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,978
    Is it an old version of Excel?
    Excel 2000 upped the limit for text in a cell to more than 32,000.

  3. #3
    Member
    Join Date
    January 18th, 2005
    Posts
    145
    No - it was bundled in with Office2000 - so I assume it is Excel2000

  4. #4
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    Same thing happens here. I have 2000.

    Mr.Merchant, if you do business in any way what-so-ever with parasites, your products will not be sold on my sites!!

    Farewell, CJ! I loved you when you were young and pure. I will try to remember you that way. Disclaimer: Comments are to be interpreted as opinion unless otherwise noted.

  5. #5
    ABW Ambassador
    Join Date
    January 18th, 2005
    Posts
    804
    Excel 2002 has the limits of 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. This apparently began with Excel 97.

    Try turning Wrap text on using the Format...Cells...Alignment menu item. You should then be able to see 1024 characters displaying in the cell.

  6. #6
    ABW Ambassador Radegast's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,978
    Found this on the Microsoft Knowledgebase - hope it helps:

    XL2000: Importing Text File Truncates Fields Longer Than 911 Characters

    SYMPTOMS
    When you import a text file, Microsoft Excel may truncate some of the text fields to 255 characters.
    CAUSE
    This behavior occurs when all of the following conditions are true:
    You use the Text Import Wizard to import the file.
    The field is longer than 911 characters.
    You do not use step 3 of the Text Import Wizard to set the data type of the field to Text.
    RESOLUTION
    To work around this issue, make sure that you set the data type of long text fields to Text. After being imported, the data may appear as number signs (###). To work around this behavior, change the format of the affected columns to General.

  7. #7
    Member
    Join Date
    January 18th, 2005
    Posts
    145
    Ahh ..

    The column of mine that was being truncted was from an imported text file

    I'll investigate what Radegast suggests - thanks

  8. #8
    ABW Ambassador FFoc's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,015
    Alternatively, you could download OpenOffice.org -- the OOo Calc import wizard worked correctly 100% of the time on all of the datafeeds I've chunked at it..

    --
    "The greatest good you can do for another is not just to share your riches, but to reveal to him his own." – Benjamin Disraeli
    --
    Ford Fox-body Owners Club -- http://www.ford-fox.org

  9. #9
    Affiliate Manager
    Join Date
    January 18th, 2005
    Location
    Los Angeles, California
    Posts
    1,913
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by FFoc:
    Alternatively, you could download http://openoffice.org -- the OOo Calc import wizard worked correctly 100% of the time on all of the datafeeds I've chunked at it..<HR></BLOCKQUOTE>

    Yes, OpenOffice is a great package, and you can't beat the price.

    Question: What are you using spreadsheets for with datafeeds? Anything I might add into WebMerge directly?

    --
    Richard Gaskin
    Fourth World Media Corporation
    Developer of WebMerge: Publish any database on any site
    ___________________________________________________________
    Ambassador@FourthWorld.com http://www.FourthWorld.com
    Tel: 323-225-3717 AIM: FourthWorldInc

  10. #10
    ABW Ambassador FFoc's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,015
    I'll guarantee they're using it for either cleaning up fubar'd lines, or mangling the url to add their ID to it..

    I use sed for url mangling, myself..

    Only thing I personally use a spreadsheet input for is help when visualizing the structure of the data when I'm building my site code.

    --
    "The greatest good you can do for another is not just to share your riches, but to reveal to him his own." – Benjamin Disraeli
    --
    Ford Fox-body Owners Club -- http://www.ford-fox.org

  11. #11
    Member
    Join Date
    January 18th, 2005
    Posts
    145
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by Radegast:
    Found this on the Microsoft Knowledgebase - hope it helps:

    XL2000: Importing Text File Truncates Fields Longer Than 911 Characters

    SYMPTOMS
    When you import a text file, Microsoft Excel may truncate some of the text fields to 255 characters.
    CAUSE
    This behavior occurs when all of the following conditions are true:
    You use the Text Import Wizard to import the file.
    The field is longer than 911 characters.
    You do not use step 3 of the Text Import Wizard to set the data type of the field to Text.
    RESOLUTION
    To work around this issue, make sure that you set the data type of long text fields to Text. After being imported, the data may appear as number signs (###). To work around this behavior, change the format of the affected columns to General.<HR></BLOCKQUOTE>

    I've been experimenting with this, but I'm still getting no joy

    If there are any other simple methods of merging together data from two different feeds, I'd appreciate it if someone can let me in on the secret!

  12. #12
    Affiliate Manager
    Join Date
    January 18th, 2005
    Location
    Los Angeles, California
    Posts
    1,913
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by Tiebreaker:
    If there are any other simple methods of merging together data from two different feeds, I'd appreciate it if someone can let me in on the secret!<HR></BLOCKQUOTE>

    Spreadsheets are ideal for calculation, but fall short as a database. Have you considered FileMaker Pro or Excel?

    --
    Richard Gaskin
    Fourth World Media Corporation
    Developer of WebMerge: Publish any database on any site
    ___________________________________________________________
    Ambassador@FourthWorld.com http://www.FourthWorld.com
    Tel: 323-225-3717 AIM: FourthWorldInc

  13. #13
    Affiliate Manager
    Join Date
    January 18th, 2005
    Location
    Los Angeles, California
    Posts
    1,913
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by Fourth World:
    Have you considered FileMaker Pro or Excel?
    <HR></BLOCKQUOTE>

    Whoops - I meant Access, not Excel.

    --
    Richard Gaskin
    Fourth World Media Corporation
    Developer of WebMerge: Publish any database on any site
    ___________________________________________________________
    Ambassador@FourthWorld.com http://www.FourthWorld.com
    Tel: 323-225-3717 AIM: FourthWorldInc

  14. #14
    Member
    Join Date
    January 18th, 2005
    Posts
    145
    Access is truncating the text too - must be a microsoft issue - it's driving me %^&*£$ crazy!

    I haven't tried FileMaker Pro yet

  15. #15
    ABW Ambassador FFoc's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,015
    Are you certain the truncation is on your end?

    Have you hand tested a single entry?

    --
    "The greatest good you can do for another is not just to share your riches, but to reveal to him his own." – Benjamin Disraeli
    --
    Ford Fox-body Owners Club -- http://www.ford-fox.org

  16. #16
    Member
    Join Date
    January 18th, 2005
    Posts
    145
    Sorry to sound dumb - but what do you mean by hand tested?

  17. #17
    Affiliate Manager
    Join Date
    January 18th, 2005
    Location
    Los Angeles, California
    Posts
    1,913
    I've decided to go ahead and build a database viewer/editor for v2.4, but I have a question about feeds and truncation:

    The text library I'm using will far exceed Excel's limit, but will still have a limit: no single record in the file can exceed 65,535 characters (64k). WebMerge can handle larger records, but to display or sort them they must be shorter than 64k. This limit applies only to single records; the number of records is only limited by available memory (rarely a problem except with really large feeds on older Mac systems).

    Now, that's a _lot_ of text (roughly 28 pages' worth), and thus far in three years of shipping the product I've only seen one instance where records were longer than 64k, a highly specialized case where the developer was publishing a collection of short stories and one of the stories was more of a novella. The addition of the WM-Include tag took care of that case and added new flexibility to the program, and it hasn't been an issue since, at least not that I know of.

    So I'm just double-checking: do any of you work with feeds where one or more records is larger than 64k?

    --
    Richard Gaskin
    Fourth World Media Corporation
    Developer of WebMerge: Publish any database on any site
    ___________________________________________________________
    Ambassador@FourthWorld.com http://www.FourthWorld.com
    Tel: 323-225-3717 AIM: FourthWorldInc

  18. #18
    ABW Ambassador Mike O's Avatar
    Join Date
    January 18th, 2005
    Location
    Los Angeles area
    Posts
    843
    Nope. Can't imagine ever needing more than that, either.

    -- Mike

  19. #19
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    I agree with your example Richard - it would be rare. 64k would be cool.

    Fred

    You might just be a Redneck if - Birds are attracted to your beard...

  20. #20
    Member
    Join Date
    January 18th, 2005
    Posts
    145
    Just an update for people experiencing this truncated text problem - Radegasts post was correct - see below

    I had been working with a text file that had not been imported into Excel properly - when I went back to the original zip file and extracted a new text file - this time it imported correctly.

    I think that once the file has been imported incorrectly - and the text therefore is truncated - once that file has been saved it can not be imported correctly in the future - the original non-truncated text is lost.



    SYMPTOMS
    When you import a text file, Microsoft Excel may truncate some of the text fields to 255 characters.
    CAUSE
    This behavior occurs when all of the following conditions are true:
    You use the Text Import Wizard to import the file.
    The field is longer than 911 characters.
    You do not use step 3 of the Text Import Wizard to set the data type of the field to Text.
    RESOLUTION
    To work around this issue, make sure that you set the data type of long text fields to Text. After being imported, the data may appear as number signs (###). To work around this behavior, change the format of the affected columns to General.

  21. #21
    ABW Ambassador Radegast's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,978
    Glad the info helped, and glad you sorted the problem.

    I don't find Microsoft's products at all user friendly - for preference I would much rather sit in front of a Mac.

  22. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Multiple cells in same Table?
    By Happy100 in forum WebMerge (Fourthworld.com)
    Replies: 1
    Last Post: June 6th, 2007, 05:06 AM
  2. Blank Table Cells
    By squidnunc in forum WebMerge (Fourthworld.com)
    Replies: 11
    Last Post: August 25th, 2004, 09:22 PM
  3. ftp truncating to 2000 matches
    By ahugedeal in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: January 22nd, 2004, 05:37 AM
  4. truncating a link to a script
    By imageproject in forum Programming / Datafeeds / Tools
    Replies: 7
    Last Post: October 2nd, 2002, 10:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •