Trimming string from the right, leaving the first ten characters

[Nicholas_Kierstead]

I have a list of first and last names without spaces. Each string is of a varying lengths, is there a way to trim each string down to the first ten characters? There are no special characters to parse off of.

Thanks,

/N

[Nicholas_Kierstead · Accepted solution]

Nm, I found the substring formula.

[Kenda]

Hey @Nicholas_Kierstead 

To keep only the first ten characters of a string, you can use the following expression:

substring([FieldName],0,10)

Breaking this down, it is saying for your given field, start at the 0th character and keep 10 characters total.

Hope this helps! 

[Nicholas_Kierstead]

Thank you, Kenda, it works perfectly.