Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] TRIM/STRIP HELP
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] TRIM/STRIP HELP
 Login/Join
 
Platinum Member
posted
WF 8105m

Needs some code to TRIM leading characters before '-'. I only want the number after it?

ex.
HARRIS - 101
I will want the HARRIS in one column and 101 in the other.

Thanks
JV

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 152 | Registered: August 23, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Try using TOKEN, check it out in the functions manual.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6289 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
We have used a combination of POSIT and SUBSTRING for something like this.

 
DEFINE
SPECIAL_CHARACTER/I3 = POSIT(NAME,256,'-',1,'I3');
FIRST_NAME/A24 = SUBSTRING(NAME,1,SPECIAL_CHARACTER-1);
LAST_NAME/A24 = SUBSTRING(NAME,SPECIAL_CHARACTER+1,(LENV(NAME,'I3')-SPECIAL_CHARACTER));
END
 


WebFOCUS 8.2.06, Windows
 
Posts: 19 | Registered: July 18, 2019Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Thanks jltz83od! That worked.


WebFOCUS 8105m
Windows, All Outputs
 
Posts: 152 | Registered: August 23, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] TRIM/STRIP HELP

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.