Summarize Tool - Concatenate String Maximum Length

pringleb

I have found other posts similar to this one, but none of them have resolved my issue.  I have a database table that contains comments (mostly the body of email messages) and each comment (message) is broken into chunks of 1024 characters per record.  So, if an email message is 3200 characters long, it will be split into 4 records. 

Each of these strings a V_WString set to a size of 1024.

I am using the Summarize tool to concatenate those strings back together into one field.  After concatenating them, the Browse tool shows that the fields are truncated to 5192 characters, but it says that the longest value is 26079 characters. 

However, no matter how I try to output this record, it always gets truncated to either 5192 characters or 8192 characters.  I have tried to Excel, CSV, and directly to a MSSQL database to an nvarchar(max) field. 

Is there another option to get these strings to keep all of the characters?

danilang

Hi @pringleb 

it doesn't look there is an upper bound.  The attached workflow generates 10000 rows of the 26 letters of the alphabet and then concatenates them using a summarize tool

As you can see from the image of the profile tab of the browse tool below, a string of 269999 characters was created.  

In order to see the entire string, you have to dump it out to a file.

I'm not sure what the info that you see in the browse results window is (4021 bytes in my case) but it's not the length of the actual string

 

I successfully ran the WF with a 1000000 records, but it takes a long time to display the profile info

If you open a new window on the browse tool and double click on the single, concatenated field, it will display the entire string in the cell viewer

Dan

Big String.yxmd