How to Truncated Spanish text field to 4000 byte?

Question

Hi Team,

I have to Truncated Field to exactly 4000 bytes . Field contain some rows in Spanish  and some in English, can any one help me? How I can Achieve it ?

OTrieger · Accepted Answer

@KajalBharamabe

English letters, numbers, basic symbols is 1 byte per character, as Spanish is accented it is a bit different.

I believe that you need the original Spanish text so you will not be able to convert the text format to UTF-8 and then use Left([field], 4000) as that will give an exact 4000 byte for a none accented languages.

So you will need a hybrid solution here, getting the text transform to UTF-8 so you know where the string potentially end, then get Alteryx figure out how many accented characters are in that part of the text, calculate those as 2 bytes per string. Now deduct half of the additional bytes to get 4000. Now you know what is the real number that needed to be used to truncate the string, use it with the Left function to get the desired result on the original data.