Try creating a calculation field with this calculation:
Substitute ( your_table::your_field ; Left ( your_table::your_field ; 4 ) ; "" )
I've tried that calculation but I can't make it work,
One of the test I made earlier was only: Left ( your_table::your_field ; 4 ) as result of the calculation, but it didn't work neither.
Can't find the right way to do it.. and I imagine the answer is under my nose, I just don't see it! :D
right ( your_table::your_field ; length (your_table::your_field) - 4)
Check that the calculation field is set to "Do not store calcualtion results..." in Storage Options.
I tried both formulas and checked well all the little details and as I suspected the problem was right under my nose,
They both work great, I was confusing an auto-enter calculation with a calculation field, ...my bad..
Big Thanks Nick! ;)