Trim string

[#1]

Hi.

I have a field with some values and every row starts with "01., 02., ....16." that I want to remove.

What is the best solution?

[jerem1234]

Try:

mid(FIELD, 4)

As an example:

01.test1 would get test1

Hope this helps!

[Anonymous]

Bjorn

To remove the first 2 characters use :

     mid( [YourField] , 3 )

Best Regards,     Bill

[jerem1234]

Could also try Subfield(FIELD, '.', 2)

[Nicole-Smith]

Another option...

=right(YourField, len(YourField)-3)

[rustyfishbones]

You could try SUBFIELD

SUBFIELD(YourField,'.',-1)