Removing extra comma from delimited file
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Everyone!
i have a specific requirement to produce a comma delimited file which has total row calculated at the top of the report. since rest of the columns are blank for the very first (total) row, i am getting only commas -- which is understandable HOWEVER my legacy backend application does not like those extra commas. Anyone come across this type of situation. Trying my luck with this awesome community before i make changes to the receiver.
- Labels:
- Datasets
- Developer
- Help
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DharmaAcharya
I am not sure your attached the correct one.
I have made some dummy data and hope it can give some hint.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DharmaAcharya One of the options I am thinking to use the Python tool to manipulate the final output file, something like the one below, I would defer it with @PhilipMannering , who one of the expertise in python tool