Retaining the standard number of characters in a text

[dunkindonut7777]

Hi I have a question. I have a data here with values that I need to trim into 10 characters only. So I need to remove the excess characters that beyond 10.

Description	Length
OUTSIDE SERVICES	16
COST OF SALES	13
OPERATING EXPENSE	17

I want to retain the characters up to 10 only including space.

[binuacs]

@dunkindonut7777 One way of doing this withe the Left() function

https://help.alteryx.com/20221/designer/string-functions

[IraWatt]

Hey @dunkindonut7777,

You could use the left function in the Formula Tool String Functions | Alteryx Help.:

Left([Description], 10)

The Left function returns a number of characters starting from the left. The first parameter is the text the second is the number of characters to return. (example attached below).

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[davidskaife]

Hi @dunkindonut7777 

A quick way of doing this is setting the field length to 10 in the select tool