Parsing field contents

[mfl]

I'm stuck.

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.

Thanks

Michael

[comment]

The first 7 chars will never change in length.

Assuming that the 8th character is also invariably a space, try =

Right ( Product_CodeDesc ; Length ( Product_CodeDesc ) - 9 )

The Position() function would be useful if the code was varying in length.