Character limit is exceeding 500+ characters

Question

Hi All,

I have a column with characters limit exceeding 500+ characters from CSV file. I tried changing the field size up to 20,000 and data type t V_WString. But the input data is still coming half of it.

danilang · Answer

Hi @vssrsairam

I think you're experiencing the common "This cell has truncated Characters" issue.

In order to conserve memory in Designer, text cells in the Results window only display the first 255 characters of long text fields.  The displayed message is misleading as well since it says Truncated Characters. (BTW: I added the New Lines to your input to be able to show the entire string on a screen shot.)  The value itself isn't truncated, it's only the display of the value. That's the "..." after "UPDATE TO DELIV"

The only place you don't get the message if if you use a browse Tool.

In this case the message changes to ">256 characters" and you can see that the entire string is actually there.  The browse tool is also placed after the tool with the "Truncated" message so this shows that the value has not been modified by the previous tool

This concept of limiting text strings to conserve memory is extremely confusing to new users such as yourself.  The wording of the tool tip just adds to the confusion.

Dan

vssrsairam · Answer

The data is getting broken from the input tool itself tried increasing Field length but no change in that column is there another way for fetching the live CSV data file which presented in the onedrive

philipmannering · Answer

Could you try reading in the file as JSON? Feel free to send a masked sample of the data, then I'm sure somebody can help.