Field truncated to 40 Charaters

[Christophe]

I imported data to a table using a transform map. The weird thing is that the data in 1 field is truncated to 40 characters.

I checked the transform table, and the field is set to a max of 4000 characters. The target table is also set to 4000 characters. 

I also tried to import my data directly to the table, but without success. Another weird thing is that the specific field on the target table says that there are 3960 characters left to type, but my text is truncated to 40 characters.

[ARG645 · Accepted solution]

Its worth trying out tony.barratt approach, look at his comment in the below link https://community.servicenow.com/community?id=community_question&sys_id=5526cf61db1cdbc01dcaf3231f9619d8

[Christophe]

Hello Aman,

This worked form me.

Thank you for your help.

Best regards,

Chris