cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

exporttable() truncates strings longer than 1000 characters

exporttable() truncates strings longer than 1000 characters

When using exporttable(), string values whose length is higher than 1000 characters get truncated. Is it intended?
Please find attached a model that recreates this behavior.

5 Comments
logan_gold
Community Manager

Hi @pasichpDVP72, exporttable() only exports up to 1000 characters from an individual cell in a Table because that is how it was initially created and there hasn't been a reason to change it.  If you are using bundle data for your table, then the limit goes to 4096.  Or if use the Excel Interface to export a table, you can export more than 1000 character in a cell.  I'm not sure what the limit may be for this one, but I suspect it is determined by Excel, so more like 10's of thousands.

 

Are you wanting to do something where the 1000-character limit is a roadblock?  If these other options are not feasible for what you are trying to do, then I can put in a software improvement request to the development team.

logan_gold
Community Manager
Status changed to: Under Review
 
pasichpDVP72
Explorer

Hi Logan, I already got around this limitation using fileopen() + fpt().
So changing those limits is more of a nice-to-have as far as I'm concerned at this point.

logan_gold
Community Manager
Status changed to: Gathering Support

Thanks for letting us know.  I have added something to the development list so the developers are aware and can make changes if needed. (FLEXSIM-12559)

logan_gold
Community Manager
Status changed to: Under Review
 

Can't find what you're looking for? Ask the community or share your knowledge.

Submit Idea