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.
@dunkindonut7777 One way of doing this withe the Left() function
https://help.alteryx.com/20221/designer/string-functions
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