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     [CLOSED] How to split string and number in one input field
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] How to split string and number in one input field
 Login/Join
 
Gold member
posted
Hi

i have input column data like this name and number
how to split name and number from input column

input_fld
abcd1.xyz(T1234)
abcd2.pqexyz(T4322)
abcd3.xyzeq(T4422)
abcd4.xyzds(T2321)

how to split string and number
output_fld1
abcd1 xyz
abcd2 pqexyz
abcd3 xyzeq
abcd4 xyzds

output_fld2
T1234
T4322
T4422
T2321
can any one help me plz

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Try GETTOK function


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
I think you need to check out the documentation, Functions Manual in particular, and apply some simple logic.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6270 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
Try this:
 
-SET &INPUT = 'abcd2.pqexyz(T4322)';
-SET &LN = &INPUT.LENGTH;
-SET &VAL1 = GETTOK(&INPUT,&LN, 1, '(', 20, 'A20');
-SET &VAL1A = TRUNCATE(&VAL1.EVAL);
-SET &VAL2 = GETTOK(&INPUT,&LN, -1, '(', 20, 'A20');
-SET &VAL2LN = &VAL2.LENGTH;
-SET &VAL2A = STRREP(20, '&VAL2.EVAL', 1, ')', 1, '' , 20, 'A20');
-SET &VAL2B = TRUNCATE(&VAL2A.EVAL);
-SET &VAL2BLN = &VAL2B.LENGTH;


WF 7703M, XP/Win7, MRE, RC, BID, PMF, HTML, PDF, Excel 2000/7/10
 
Posts: 73 | Location: NY | Registered: February 06, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
I would like to second Waz, Read The Focus Manual


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to split string and number in one input field

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