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]Splitting a column values into two columns.
Go
New
Search
Notify
Tools
Reply
  
[Closed]Splitting a column values into two columns.
 Login/Join
 
Platinum Member
posted
Hi I have the below sample code with CAR file where i am splitting a column values into two separate columns.

  
TABLE FILE CAR
BY COUNTRY
BY MODEL
WHERE COUNTRY EQ 'W GERMANY'
ON TABLE HOLD AS EXT1
END
-*-EXIT

DEFINE FILE EXT1
SNO/I2 = IF LAST MODEL NE MODEL THEN SNO+1 ELSE SNO;
SNO_IMOD/I2 = IMOD(SNO, 2, SNO_IMOD);
END
TABLE FILE EXT1
BY COUNTRY
BY SNO
BY SNO_IMOD
BY MODEL
ON TABLE HOLD AS EXT2
END
-*-EXIT

DEFINE FILE EXT2
MODEL_1/A100 = IF SNO_IMOD EQ 1 THEN MODEL ELSE '';
MODEL_2/A100 = IF SNO_IMOD EQ 0 THEN MODEL ELSE '';
END
TABLE FILE EXT2
PRINT
MODEL_1
MODEL_2
END
-EXIT



The output i get is shown below.
Capture

I am trying to get the output without the empty string in the rows.I tried COMPUTE and it didn't work for me.
I think i am missing some basic simple logic there,and i am not able to get it right.

Suggestions please.

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


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 225 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Guru
posted Hide Post
Any reason why you're not using SUBSTR or other character functions to split the string?
 COMPUTE STR1/A10 = EDIT(MODEL,'999999999$$$$$$$$');
COMPUTE STR2/A10 = EDIT(MODEL,'$$$$$$$$9999999999'); 


-********************
Sandbox: 8206.10
Dev: 8201M
Prod:8009
-********************
 
Posts: 283 | Location: Houston,TX | Registered: June 11, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
quote:
not using SUBSTR or other character functions to split the string?


I am not trying to split a particular string.I am string to store values from a column into two separate columns.


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 225 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Finally got it working.The solution i have is to store the fields into two separate hold files and then join which will give the output the way i need.


WF8202M,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 225 | Location: MI | Registered: September 13, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Maybe a bit simpler:
  
TABLE FILE CAR
LIST MODEL
ON TABLE HOLD
END
-RUN
DEFINE FILE HOLD
L/I5=LIST - 1;
C/I1=IMOD(L,2,'I1');
R/I5=L / 2;
END
TABLE FILE HOLD
SUM MODEL
BY R NOPRINT ACROSS C NOPRINT
END



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1967 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed]Splitting a column values into two columns.

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