Form letter query

Post Reply
colonel_panic
Posts: 55
Joined: Fri Jun 08, 2018 9:19 pm

Form letter query

Post by 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. :D
colonel_panic
Posts: 55
Joined: Fri Jun 08, 2018 9:19 pm

Re: Form letter query

Post by 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!
Post Reply

Return to “TextMaker 2018 for Linux”