Form letter query

[colonel_panic]

Hello

I am looking to insert the first character from a database field into a Textmaker document, then merging. So if the field contents were "1 Apple", I'd get "1" in the document.
Is this possible?

Thanks.

[colonel_panic]

I found out how to do it myself! It's exactly the same as MS Office, although I'd completely forgotten.
In case you are wondering:
F2 to add a formula
The formula is LEFT(FIELDNAME;1)
FIELDNAME is the name of the field in your database, and 1 is the number of characters to return.
Easy. Thanks for the great product!