Parsing part of one field to another
I am trying to parse part of a field into another field via calculation.
I used Position() which gave me the position of first blank which is correct, but now I want to place everything after that into my second field.
First field "Product_CodeDesc" contains - "MCD01234 some description"
The first 7 chars will never change in length.
Second field is my calc field that should hold the description part.
What function do I put the Position() statement in to retrieve the description section.