| remove ',' from csv whenever null [message #402679] |
Tue, 12 May 2009 00:50  |
 |
ramoradba
Messages: 2456
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 #403189 is a reply to message #403109] |
Thu, 14 May 2009 02:26  |
|
ramoradba
Messages: 2456
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
