Max Length of Text Field

[hung pham]

I want to concat some text fields: T1&T2&T3

Then assign the concat value to new text field called A (set A = T1&T2&T3)

But before I assign the concat value to A, I like to check if the length of T1&T2&T3 is exceed to its limit. How do I know and check the limit?

Thank you in advance

HP

[LiveOak]

The limit is 64k characters.

-bd

[chattavegas]

> I want to concat some text fields: T1&T2&T3

> Then assign the concat value to new text field called A (set A = T1&T2&T3)

> But before I assign the concat value to A, I like to check if the length of T1&T2&T3

> is exceed to its limit. How do I know and check the limit?

HP,

You can use a one-step Set Field script command with the following fields:

T1, T2, T3 - text fields

A - concatenaed field of T1 & T2 & T3

L_Test - maximum length of A field you want set to, make sure it's a number field

SCRIPT STEP:

Set Field ["", " If (Length(T1 & T2 & T3) <= L_Test, T1 & T2 & T3, "") "]

You can then maybe do a "Show Message" step check if the A field equals nothing to notify you when the A field exceeds the maximum limit or however you want to handle it. The key ingredient is that you should probably use the Length function.

Cheers,

Scott