Hello. I have a feature class stored in a SDE geodatabase. The database is sql server 2008. I am using ArcGIS 10. The feature class contains a text field with 8000 character limit. I have to do some editing of this text field and find it very difficult to do so in ArcGIS where the text is presented in a single line. My text is too long to edit in this format.
So, I can think of two ways that I could edit efficiently, but I don't know how to accomplish either.
1) Find a way to edit within ArcMap that presents the text in a wrapped, paragraph format. Is this possible? Anyone know how to do this? Something like a HTML popup format would be perfect, if I could edit in it.
2) Export the attribute in another format (such as Excel), make the edits, then join back to the original feature class and update the text field. This was the approach I initially took. However, I ran into a problem. When I export to Excel, the longest fields show up as "########". I can fix this by changing the field formatting to General in Excel. Then I can view the text and make my edits. The major problem comes when I try to view the Excel in ArcMap. The entire field shows up as a BLOB, and then I can't update the text in the feature class. In fact, none of the records show up; it displays as an empty table. I then tried importing the revised Excel as a GDB table first, but when I do that the records do show but the long text field is a BLOB. Anyone know a way around this?
Thank you!