Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Is there a way to remove quotes around column values

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Is there a way to remove quotes around column values
 Login/Join
 
<Vijaya_settu>
posted
When I try to convert from webfocus to flat file.It is automatically put quotes around the field.I need to remove quotes for some of the fields ,not all of them. If it null value , i want show as blank not quotes
For example:"A", "B", "c","",...
I want my output like this "A","B",c,,.....

Any suggestions are appreciated
 
Report This Post
FrankDutch
Virtuoso
posted Hide Post
I would try

ON TABLE HOLD FORMAT COM

but I'm not sure what you want with that non quoted small c...
With the format COM you get numbers without quote and strings with.

Frank




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
<Vijaya_settu>
posted
Thanks for you suggestion
I will try and let you know
 
Report This Post
<Vijaya_settu>
posted
Frank,
It din't work.

I have the following 3 rows. For the "Accept" row and "Tran" row, I need to remove quote for the last field. The header row,I need to remove double quotes(""). i want show only comma(,).
Examples:
"Accept","100","170240","168607","CHEM","141","Prin Gen & Inorgan Chem","","4.00","",","
"Header","100","170240","168607","","","","","","",","
"Tran","100","170240","168607","CEM","121","General & Inorganic Chemistry","4.00","","",","

I want my output look like this:
"Accept","100","170240","168607","CHEM","141","Prin Gen & Inorgan Chem","","4.00","",,
"Header","100","170240","168607",,,,,,,,
"Tran","100","170240","168607","CEM","121","General & Inorganic Chemistry","4.00","","",,

I appreciate any thoughts
 
Report This Post
susannah
Expert
posted Hide Post
try FORMAT WK1 and FORMAT LOTUS
(raise your hands if you remember Lotus?? Wink



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Tony A
Expert
posted Hide Post
Guilty as charged Frowner. I even had to code using their macro language. Not too dissimilar from VBA of the time.

T
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Kerry
Expert
posted Hide Post
Hi Vijaya,

Suggestions from internal expert: here is a more flexible way of doing it. 
DEFINE FILE EMPDATA                                    
 -* USE THIS FOR NUMERIC FIELDS                         
 ASAL/A17=LJUST(17,FTOA(SALARY,'(D12.2)','A17'),'A17'); 
 -* BRING THEM ALL TOGETHER WITH STRONG CONCATENATION   
 LINE1/A227=PIN|| ','||LN||','||FN||','||DEPT||','||    
            DEPT||','||TITLE||','||ASAL||',' ;          
                                                        
 END                                                    
 TABLE FILE EMPDATA                                     
 PRINT                                                  
 LINE1 AS ''                                            
 -*ON TABLE SAVE Use this to save the data file         
                                                        
 END


Sample output:
000000010,VALINO,DANIEL,MARKETING,MARKETING,MARKETING EXECUTIVE,55,500.00,
000000020,BELLA,MICHAEL,MARKETING,MARKETING,INDUSTRIAL MARKETER,62,500.00,
000000030,CASSANOVA,LOIS,SALES,SALES,SALES MANAGER,70,000.00,
000000040,ADAMS,RUTH,MARKETING,MARKETING,MARKETING DIRECTOR,62,500.00,
000000050,ADDAMS,PETER,SALES,SALES,EXECUTIVE MANAGER,54,100.00,
000000060,PATEL,DORINA,MARKETING,MARKETING,MARKETING DIRECTOR,55,500.00,

Hope this helps. Big Grin

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
<Vijaya_settu>
posted
Kerry,
Thanks a lot for your suggestion.It works fine.

Vijaya
 
Report This Post
FrankDutch
Virtuoso
posted Hide Post
Susannah

quote:
Originally posted by susannah:

(raise your hands if you remember Lotus?? Wink


Lotus 1-2-3 or Symphony....

Frank




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Is there a way to remove quotes around column values

Copyright © 1996-2020 Information Builders