How to Recode COMPANY field from 40 charater to 13 charater ?

[admin11]

Hi All

My COMPANY_NAME field now 40 charater , i like to recode this field to 13 charater. 

For example :- TDS Technology (S) Pte Ltd

recode to TDS Technology (13 charater)

Paul Yeo

[ryan_mayu · Accepted solution]

@admin11 

since your sample data is too less, not sure if the solution fits your real data. maybe you can try this

Column = 
VAR _num=13-len(SUBSTITUTE(left('Table'[company_name],13)," ",""))
return left('Table'[company_name],13+_num)

[admin11]

@ryan_mayu 

Thank you very much for sharing.

Paul