Share
ReportI've got this calculated field and i thought i had it right but it gives me an error. I'm trying to get the tax schedule ID but i only want the first six characters.
Categories:
You’re offline. This is a read only version of the page.
20
I've got this calculated field and i thought i had it right but it gives me an error. I'm trying to get the tax schedule ID but i only want the first six characters.
Hi Stephanie
We have a few issues to resolve:
1) On the Conditional Expression remove the closing parenthesis (bracket). If you have brackets, they must always have opening and closing as a matching pair.
2) The LFT_STR function does not do what you want. From the manual: Prints only the data that lies to the left of the caret (^) in a field with a string storage type.
3) What you want is the custom user defined function (system series) RW_Left() that I added to GP v7.0. Here is the parameter list:
function returns string OUT_string;
in string IN_String;
in integer IN_Length;
Using the same parameters will give you the first six characters of the Tax Schedule ID field.
Good luck
David
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (