Is there a "length" function in LPL? Can you determine the number of characters entered in the fiel

Does anyone know if there is a "len" function in LPL? I need the ability to say

if (addr2's length = 1)

return "UNIT " + Addr2

else

return addr2

So, if someone entered just "1" in the address 2 line, it would return "UNIT 1" instead of 1 but if they anything else, that's more than just one character, it would return what they entered.

Thanks in advance.

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

Hi Bryant,

U can try using something like this, getting the Local Field length value and then returning that with the Field (addr2)

// LocalFieldLength.ReturnLength = 35 - FamilyNameLength
//return (LocalFieldLength.ReturnValue + " " + Name.FamilyName)

In your case it would be something as following:

Eg:

if first PostalRel.PostalAddress.DeliveryAddress.AddressLine2.ReturnLength = 1

File += "UNIT" + PostalRel.PostalAddress.DeliveryAddress.AddressLine2

else

File += PostalRel.PostalAddress.DeliveryAddress.AddressLine2

laura-bryant

When I try to use the .ReturnLength, I get an error saying that the AddressLine2 does not have any States. I'm using my own relation to my address BC. Would I need to set up a user defined relation to the Postal address specific for this reason? Thanks again!

Legacy Contributor

ok. yes you could create the one specific to your custom relation BC.

Dr. Awesome

Yes, there are LPL operators like this for alpha fields. Check out docs.infor.com and the Landmark Developer section.

cleverly

if (Addr2 size = 1)
return "UNIT " + Addr2
else
return Addr2

would be one way. Another would be:

if (Addr2 matches "^.$")
return "UNIT " + Addr2
else
return Addr2

Copyright © 2025 Infor. All rights reserved.