My text field keeps getting truncated at 254, even after changing the field size, and the character set. Is this a version issue (we're on 10.5.9) or am I missing something?
The actual results however show the red corner stating the field was truncated, and the max field size is 254.
Solved! Go to Solution.
can you post a sample of the data with a few records please?
Thanks,
Mark
Hi Mark,
Thanks for taking the time to look at this. The last screenshot shows some records from the import. I can't share the data files themselves, as they contain sensitive data.
while the data could be sensitive, you could create dummy data that behaves the EXACT same way. Once you create that dummy data, either you will find the issue yourself or you can post the replica issue with data so that I could solve with you. I could also setup a webex now with you and fix it also.
Thanks for the data....
The input data was read and I put a formula tool after the read to see what the true length of the field is. The first record is 435 bytes and the second is 439. The browse everywhere does have a message that the field is > 256 characters (a limit for the visualization). The full data content is present in the data.
Does this help?
cheers,
Mark
That makes sense, I was just obsessing over the message itself and didn't take the time to review the actual output. Thanks for that!