Excel truncation error on Field Summary Output file

[kimc745]

Hi All,

I am receiving a "Max character width supported by Excel for a single cell exceeded, 13778 characters were truncated.  Fieldname: Layout record number  2 (also get same for record number 3 and 4.  

Background:

Using just the data investigation tools of basic data profile and field summary tools and creating outputs for both.  The error is on the field summary tool. 

Looked over data set and there is no value greater than 255 characters.  

How do I identify where the offending data is and is there any way to correct?

Thanks

Kimberly

[danilang · Accepted solution]

Hi @kimc745 

This error will occur if you try to send the results of the R or I output to excel through an Output Tool.  The issue is that the output of either of those is a single report snippet, which is long pcxml string

Excel tries to stick this snippet into a single cell and you get the overflow error.  

Use a render tool to output the results to excel and it will interpret the pcxml and format the excel file accordingly.

Dan

[alisonpitt]

The max string length in the Field Summary tool is 44 characters, before it starts truncating. I have read that in other forum posts and I tested it myself 😊. Depending on what you're trying to do, there might be other workarounds for that field, like pairing Summarize with Sample, or similar.

I assume that was just a warning and not an error?

[kimc745]

It was an error message (conversion error specifically).  The issue is solved - see the previous post from Dan.  It was because i was outputting to excel directly with output tool.  The one thing I wish I had was an error decoder translator. If it weren't for everyone in the community, I'd be stuck.