Check length of a field

Me, personally, BPM.



Check out the LENGTH() function.



LENGTH ( { string [ type ] | raw-expression } )





Example...



FOR EACH item:

IF LENGTH(item-name, "CHARACTER") > 8 THEN

short-name = SUBSTRING(item-name,1,8, "FIXED") + "..." .

ELSE short-name = item-name.

DISPLAY item-num short-name on-hand allocated

re-order on-order price FORMAT "$>>>9.99".

END.





Use a BPM to pop back an Exception message if whatever field isn't X
characters long.











Vic



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
P.M.
Sent: Monday, February 04, 2013 3:04 PM
To: Vantage
Subject: [Vantage] Check length of a field





Hi Group,

What is the simplest way to check the length of the field and display a
warning message if the length is smaller than 5.

Thank you.
PM

[Non-text portions of this message have been removed]



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2238 / Virus Database: 2639/5580 - Release Date: 02/04/13




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2238 / Virus Database: 2639/5580 - Release Date: 02/04/13

[Non-text portions of this message have been removed]
Hi Group,
Â
What is the simplest way to check the length of the field and display a warning message if the length is smaller than 5.
Â
Thank you.
PM

[Non-text portions of this message have been removed]