this is a Windows limitation, I don't know if we can bypass that. (I think we can but it's not recommended).
Thank you for the reply. Weird how the users of this data haven't had an issue with the character length until now. In the last 2 days, 2 different people have identified this issue. How have any others addressed this issue, if at all?
Any idea how this could be bypassed? Thanks!
I have some idea. But firstly - how do you create the Excel spreadsheet? I hope that you could use two additional fields in the datacard and input formula string function (2018 SOLIDWORKS PDM Help - Input Formula Functions). The first additional field will be stored first 250 signs and the second one from 251 sign to the end. Then you can migrate each fields to two coulmns in Excel.
Thank you for the suggestion. Sorry for the delayed reply. The Excel file is created after the user populates the datacard - using a template in PDM. So you're thinking of concatenation?
If that data use text always is 255...In Office can you choose a data as memo, on PDM maybe will be the same.
Use to display
Short, alphanumeric values, such as a last name or a street address. Note, beginning in Access 2013, Text data types have been renamed to Short Text.
Number, Large Number
Numeric values, such as distances. Note that there is a separate data type for currency.
Yes and No values and fields that contain only one of two values.
Date and Time values for the years 100 through 9999.
Text or combinations of text and numbers that can be formatted using color and font controls.
Results of a calculation. The calculation must refer to other fields in the same table. You would use the Expression Builder to create the calculation. Note, Calculated fields were first introduced in Access 2010.
Attached images, spreadsheet files, documents, charts, and other types of supported files to the records in your database, similar to attaching files to e-mail messages.
Text or combinations of text and numbers stored as text and used as a hyperlink address.
Long blocks of text. A typical use of a Memo field would be a detailed product description. Note, beginning in Access 2013, Memo data types have been renamed to Long Text.
Displays either a list of values that is retrieved from a table or query, or a set of values that you specified when you created the field. The Lookup Wizard starts and you can create a Lookup field. The data type of a Lookup field is either Text or Number, depending on the choices that you make in the wizard.
Lookup fields have an additional set of field properties, which are located on the Lookuptab in the Field Properties pane.
Purpose Use to store up to 255 characters of text. Note, beginning in Access 2013 the Text data type has been renamed to Short Text.
Purpose Use to store a block of text that is more than 255 characters long and is formatted text. Note, beginning in Access 2013 Memo data type has been renamed to Long Text.
I think PDM has same rules....I will try to find it if is available...
Try mapping to 'comment' in the summary tab. I had an issue with word and it seemed to work. We only had the issue for a single variable, so I never checked any of the other properties in the summary tab.
Thank you for the reply. I'll test with the comment field...