LPL/Configuration Console - Substring or Left Function for Derived User Field

We would like to create a user field(derived or computed?) that returns the first 3 characters of the position short description. Ex. Left(Position.ShortDescription,3) or Substring(Position.ShortDescription,1,3), but we are unable to locate the syntax in the LPL guide. Is this even possible? This is for the potential to create actor groups based on part of a field.

Find more posts tagged with

Accepted answers

Legacy Contributor

You can create the derived field on Position as an Alpha size 3 and input in the definition:

return ShortDescription[0:3]

All comments

andy

I'm trying to accomplish the same thing, and I don't think it's possible in LPL directly.

There are control rules in LPL, e.g. if's and while loops, but there doesn't appear to be a way to index the length of a field value / string.

I think the way to accomplish this would be through activating a script engine, but thus far I haven't been able to get that to function.

Creating a Remote Workforce Strategy_Webinar_6-2020_LN.pdf

Legacy Contributor

You can create the derived field on Position as an Alpha size 3 and input in the definition:

return ShortDescription[0:3]

andy

Thanks, I actually just got what I needed using a JS script engine, but the ability to index an alpha string is helpful. My use case was a little different; e.g. conditionally removing a char from a string.

Copyright © 2025 Infor. All rights reserved.