Beginner in need of help

[samuelbraga]

Anybody taht can help?

I have a table with a code where the number of characters on right is fixed (15) but the letters on the left changes. It's the code for the stock options. I need to create a field where any number of letters on left will be shown alone.

A120621P00040000

DVN120519C00085000

AMZN120519P00010000

A

DVN

AMZN

Thanks,

Samuel

[Vaughan]

Left( field ; length( field ) - 15 )

[samuelbraga]

Thank you Vaughan, it worked just perfect.