Merge Field formatting

[Scatman]

I have a text field that contains data in the following format: "06/10/09 By John Doe"

I want to use the date portion of this field in a mail merge document. Is there a way that I can code this in the document to strip out the "By John Doe" portion of the field?

The field is titled Pre_Review if this helps in the code creation.

Any help would be appreciated.

Thanks

 

[langley111]

What is the datasource for the mail merge? Can you format the field in the datasource? You can always do string manipulation and only show the data portion:

left(Pre_Review, instr(Pre_Review , " ") - 1)

This should work if the field is always in the format you provided. You find the first space which occurs after the date and then take the characters to the left of that position.