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

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

Thanks for you suggestion
I will try and let you know

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

try FORMAT WK1 and FORMAT LOTUS
(raise your hands if you remember Lotus??

Guilty as charged . I even had to code using their macro language. Not too dissimilar from VBA of the time.

T

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.

Cheers,

Kerry

Kerry,
Thanks a lot for your suggestion.It works fine.

Vijaya

Susannah

quote:

Originally posted by susannah:

(raise your hands if you remember Lotus??

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

Frank