Jump to content

Attribute table string cell size limit


Recommended Posts


Guys, i need some help. I have a shapefile and an excel spreadsheet. I joined the xls, and opened the attrib table. The joined text type cell sizes reduced from the original to 254 char. I used google, and i've found, that a shapefile string cell can contain only 254 char. Ok, i thought, i make a geodatabase, and i will join the table to the shape with a "relationship class".

I opened the shape in the ArcMap and used identify tool, and i saw the related data. BUT, the string cells only showing 254 chars...

The second thing, the identify tool isn't kool, i can't see the full contain of the cell, can't resize. Anyone know plugin to open attrib table with options, resize, on!off cells etc.

Link to comment
Share on other sites

  • 1 month later...

Esri "Ask a cartographer" wrote to my question:

You can create text fields greater than 255 characters using file geodatabases.

1. First, create a new file geodatabase then create a new feature class.

2. Add a text field as part of the creation of the new feature class and specify the length of text strings should be 400 (or whatever the maximum is that you require).

3. Then, using your original layer, convert labels to annotation and choose to append them to an existing feature class (the one created above). 

4. Export the attribute table of the feature class and you can then copy the labels from your spreadsheet into the text field of your attribute table in Excel, save the resulting table and then Join back to the feature class.

This confused meh. I have a source spreadsheet, and i wanted to join that to a feature class. I tested that: created an FGDB, new feature class with text ffield, 1500 char , and joined the excel spreadsheet.  With field calculator copied the one field of the joined data to the 1500 char long field. The joined field shows only 255 char max., and the copied shows that 255 too. I thought, maybe the joined data is longer than 255 char, only showing 255, but no, the join command cut the input fields to 255....

seriously, it's not good..

ps.: 3dbu > xtools identifier only showing data. I have problem with joining data over 255 char. (f.e.: join a long description to a geological unit). That xtools command isnt good for meh.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.



If you enjoy our contents, support us by Disable ads Blocker or add GIS-area to your ads blocker whitelist