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]
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]