- This topic has 2 replies, 3 voices, and was last updated 3 years, 6 months ago by .
This might be an easy one but I’m trying to take a substring of a field, pass it to a lookup table and if that substring passes leave the field alone else perform some action on it. my issue is getting the first three characters of a field and then using that as the input to the lookup table.
So if I have : AB1BT1550 i just want to use the AB1 in the lookup. and maintain the original value if it succeeds, I just wont know the full value ahead of time.
Any assistance would be appreciated.
- You must be logged in to reply to this topic.