Home » Developer & Programmer » Reports & Discoverer » remove ',' from csv whenever null (Oracle 10g,oracle reports6i)
remove ',' from csv whenever null [message #402679] Tue, 12 May 2009 00:50 Go to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hi,All We have a requirement.

After executing the delimited(CSV) from reports6i it`s showing the values after some null fields.i need to eliminate the null fields from the csv version.

Please let me know if any possible way.

Thanks & regards
Sriram
Re: remove ',' from csv whenever null [message #403026 is a reply to message #402679] Wed, 13 May 2009 09:21 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Any one? Smile
Re: remove ',' from csv whenever null [message #403109 is a reply to message #403026] Wed, 13 May 2009 15:19 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I understood the question, here it is: how do you plan to interpret the results if NOT NULL values take place of NULL values?

If I misunderstood it, could you, please, illustrate the problem?
Re: remove ',' from csv whenever null [message #403189 is a reply to message #403109] Thu, 14 May 2009 02:26 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
@Littlefoot
Thanks for your replay.

From the report builder,we can generate csv files.
This is the csv file output i got.Here i am using * for null columns

SNO NAME ADDRESS STRNO CITY STATE COUNTRY
1 SRI ******* **** **** AP USA
2 RAM ragk **** **** KP UK

if it is open with notepad,then
"SNO", "NAME", "ADDRESS", "STRNO" ,"CITY", "STATE", "COUNTRY"
"1","SRI","","","","AP","USA"
"2","RAM","ragk","","","KP","UK"


I Want like Below

SNO NAME ADDRESS STATE COUNTRY
1 SRI AP USA
2 RAM ragk KP UK

Remove field headings & field values if null.
So i need to eliminate "" if the field value is null.i.e.
first it should check how many fileds are null at total report.
here sri has his address field null but ram has address,but both are not having strno,city so those records should eliminated

Thanks
Sriram
Previous Topic: page total should display on all pages
Next Topic: Character report "print range" problem - 10g
Goto Forum:
  


Current Time: Fri Dec 09 23:10:00 CST 2016

Total time taken to generate the page: 0.09325 seconds