Shortening the amount of digits

[BillyL14]

Hi 

I have a column of codes. Each code has around 16 digits in it. I would like to shorten and just keep the first 8 digits. How can I do that?

Thanks

[JosephSerpis · Accepted solution]

Hi @BillyL14 I mocked up a couple of ways to do this. Let me know what you think?

[wwatson]

if you use a select tool to make the column a VSTRING type you can use a formula like left([fieldname],8)

[BillyL14]

@JosephSerpis thanks very useful

[BillyL14]

@wwatson thanks