Hi, Mark. A previous thread linked to here discusses this. There is no documented max string length.
The problem you pose is interesting and there could be some interesting suggestions or solutions.
Please reply and include more information about the architecture that you are working with. If you are consuming the data from a server, please list the type of server. Other members of the community might request more detail. Any other specifics you can provide will help motivate suggestions or solutions.
Thanks I guess I'm going to have to load this into a SQL server to deal with the issue.