Length of text in a field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Graham - 26 Jan 2007 03:00 GMT

How do I determine the length (or number of characters) of a field?

I want to use something like:

{ IF { = LENGTH( { long_description } ) } > 40
{ short_description } { long_description } }

except that there doesn't seem to be a LENGTH function.

Or I want to be able to use { NUMCHARS } for a small part of text, not the
complete document.

Is there a function? Or a workaround?

Thanks

Reply to this Message

macropod - 26 Jan 2007 03:16 GMT

Hi Graham,

Try:
{IF{long_description}= "?????????????????????????????????????????*"
{long_description} {short_description}}

Cheers

Signature

macropod
[MVP - Microsoft Word]

| How do I determine the length (or number of characters) of a field?
|
[quoted text clipped - 11 lines]
|
| Thanks

Reply to this Message

Graham - 26 Jan 2007 03:27 GMT

Thanks. Nice workaround.

> Hi Graham,
>
[quoted text clipped - 19 lines]
> |
> | Thanks

Reply to this Message

Graham - 26 Jan 2007 04:11 GMT

And it works well. 41 question marks and an asterisk.
I'm glad I'm not checking a paragraph length.

I put short_description before long_description so it uses the short
description if the long description is too long for my table cell.

Thanks a lot.

> Thanks. Nice workaround.
>
[quoted text clipped - 21 lines]
> > |
> > | Thanks

Reply to this Message