Anyone know if it's possible to cast a field to a different type in LPL without creating additional Local or Derived fields?
For example, if I want to substring the first four characters a field that is Numeric size 12 it seems the only way to do that is to create a new Alpha field that returns the original field (e.g. cast Numeric to Alpha), and then create another Derived field to returns the first four characters of the other newly added field.
This works, but I'm wondering if there's a more efficient way to do this inline that doesn't require adding two fields to get the substring of a Numeric field.
Something like...
Alpha(FieldToSubstring)[1:4]
