Limit a field to the first 75 characters, and trim extra?

[pacbloyd]

Hello - I need the column "NAME" to NOT exceed 75 characters, and if it does, to TRIM off the extra characters.

Which formula does this?

[Luke_C · Accepted solution]

Hi @pacbloyd 

the 'LEFT' formula does. So for this:

LEFT([FieldName],75)

Note: Field must be a string, if its numeric you could wrap it in a tostring() function or convert via select tool.

[pacbloyd]

@Luke_C  thank you!!