 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Function for getting right two characters
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Function for getting right two characters Read-Only TopicGo | Search | Notify | Tools |
| Function for getting right two characters | Login/Join |
| Gold member |
Is there a function in WebFocus, like there is in Excel, where you can request characters at the far right (or left) of a field? In excel, the function is: RIGHT(A2,2) and it would return 04 if cell A2 contained 20070204. Thank you. PROD: WebFocus 7.6.9 on WinXP | ||
|
| Virtuoso |
Depends on the field and is it fixed length a number alphanumeric and so on. Oh, by the by, before someone else asks you to do so, please update your signature so we know what platforma and so on. Thanks Leah | |||
|
| Expert |
You could just reverse the string using a few computed fields for length and format and then grab the (then) first two characters and reverse them - TABLE FILE CAR
PRINT COMPUTE C_LEN/I3 = ARGLEN(20, COUNTRY, 'I3');
COMPUTE C_FMT/A4 = 'A' || EDIT(C_LEN);
COMPUTE LAST_TWO/A2 = REVERSE(2,REVERSE(C_LEN,COUNTRY,C_FMT),'A2');
BY COUNTRY
ENDThe output, of which, is - COUNTRY C_LEN C_FMT LAST_TWO ENGLAND 7 A007 ND FRANCE 6 A006 CE ITALY 5 A005 LY JAPAN 5 A005 AN W GERMANY 9 A009 NY T
| |||||||||
|
| Expert |
You could also put this into a function that can be called from any TABLE request - DEFINE FUNCTION RIGHT(SOURCE/A999, CHARS/I3, X_FMT/A4) C_LEN/I3 = ARGLEN(999, SOURCE, 'I3'); C_FMT/A4 = 'A' || EDIT(C_LEN); RIGHT/A999V = REVERSE(CHARS,REVERSE(C_LEN,SOURCE,C_FMT),X_FMT); END TABLE FILE CAR SUM COMPUTE LAST_TWO/A2 = RIGHT(COUNTRY, 2, 'A2'); BY COUNTRY END TABLE FILE GGSALES SUM COMPUTE CARDINAL/A4 = RIGHT(REGION, 4, 'A4'); BY REGION END This will get the "n" right characters from a string with a maximum length of 999 chars. Note: There is no validation on this function to ensure correct parameter passing, so trying to pass a numeric field will fail. TThis message has been edited. Last edited by: Tony A,
| |||||||||
|
| Guru |
I like the reverse(reverse. Creative thinking. I probably would have gone with SUBSTR once I knew the length of the argument. ttfn, kp Access to most releases from R52x, on multiple platforms. | |||
|
| Expert |
Thanks Karen, just proves that you can't write off "old" FOCUS programmers  T
| |||||||||
|
| Gold member |
Thank you all so much. I like the idea of creating a function, Tony, I think I'm going to try it. And I NEVER write off programmers, we don't have any FOCUS programmers, but I send my mainframe programmers thanks all the time, and sometimes gifts, too. I thought I updated my signature, Leah...sorry. WebFocus 7.1.3 on WinXP PROD: WebFocus 7.6.9 on WinXP | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Function for getting right two characters
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point Function for getting right two charactersCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |