Remove duplicate commas after exporting excel file to csv
Hello everyone I'm new here and this is my first post so first of all I want to say that this is a great forum and I have managed to found most of my answers in these forums : )
So with that I ask you my first question:
I have an excel file which I saved as a csv. However the excel file contained several blank columns (they will be updated later so I cannot delete them).
The csv file looks like this:
Is there a sed command I can execute to delete these repeating commas?
Could any one help me in basic shell script to export text file data to csv.
I need to export only particular data from text file to csv column.
I am a newbie to UNIX could anyone help me with sample script code (3 Replies)
hello all,
i have a comma delimited file.
i want to replace the commas in the file with the tilde symbol using sed.
how can i do this?
thanks. (4 Replies)
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
Hi,
I am using HP-UX.
I have an output log file which gives me server statistics.
I want to export the contents of the file(last 100 lines) using tail command and then save it into an excel file in my local machine.
The server statistics should be collected every 3 hrs.
So, i wanted the idea... (1 Reply)
Hi
Description of input file I have:
-------------------------
1) CSV with double quotes for string fields.
2) Some string fields have Comma as part of field value.
3) Have Duplicate lines
4) Have 200 columns/fields
5) File size is more than 10GB
Description of output file I need:... (4 Replies)
Trying in this forum. Not sure if it is permitted.... but in need of help.
Please find the requirements in the below link.
https://www.unix.com/unix-dummies-questions-answers/191503-add-extra-commas-csv-file-2.html#post302665179
Thanks in Advance. (1 Reply)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Hi
I'm creating a sh script to generate a csv file. The CSV contains the values from a sql table.
The content looks this:
a,b,c,c2,c3,,,,,,,,,,,d,e
I have some code that can separate the fields using the comma as delimiter, but some values actually contain commas, such as... (2 Replies)
how to remove unwanted commas from a .csv file
Input file format
"Server1","server-PRI-Windows","PRI-VC01","Microsoft Windows Server 2012, (64-bit)","Powered On","1,696.12","server-GEN-SFCHT2-VMS-R013,server-GEN-SFCHT2-VMS-R031,server-GEN-SFCHT2-VMS-R023"... (5 Replies)
Discussion started by: ranjancom2000
5 Replies
LEARN ABOUT DEBIAN
blaze-remove
BLAZE-REMOVE(1) BlazeBlogger Documentation BLAZE-REMOVE(1)NAME
blaze-remove - removes a post or page from the BlazeBlogger repository
SYNOPSIS
blaze-remove [-fipqPV] [-b directory] id...
blaze-remove -h|-v
DESCRIPTION
blaze-remove removes a blog post or a page with the specified id from the BlazeBlogger repository.
OPTIONS -b directory, --blogdir directory
Allows you to specify a directory in which the BlazeBlogger repository is placed. The default option is a current working directory.
-p, --page, --pages
Tells blaze-remove to remove a page or pages.
-P, --post, --posts
Tells blaze-remove to remove a blog post or blog posts. This is the default option.
-f, --force
Disables requiring manual confirmation of each blog post or page removal. This is the default option.
-i, --interactive
Enables requiring manual confirmation of each blog post or page removal.
-q, --quiet
Disables displaying of unnecessary messages.
-V, --verbose
Enables displaying of all messages. This is the default option.
-h, --help
Displays usage information and exits.
-v, --version
Displays version information and exits.
EXAMPLE USAGE
Remove a blog post:
~]$ blaze-remove 10
Successfully removed the post with ID 10.
Remove a page:
~]$ blaze-remove -p 4
Successfully removed the page with ID 4.
Remove multiple blog posts:
~]$ blaze-remove 10 4 6
Successfully removed the post with ID 10, 4 and 6.
Remove multiple blog posts safely:
~]$ blaze-remove -i 10 4 6
Remove the post with ID 10 titled `Debian and Fedora Packages'? y
Remove the post with ID 4 titled `BlazeBlogger 0.8.0 RC2'? y
Remove the post with ID 6 titled `BlazeBlogger 0.8.1'? y
Successfully removed the post with ID 10, 4 and 6.
SEE ALSO blaze-config(1), blaze-add(1), blaze-list(1)BUGS
To report a bug or to send a patch, please, add a new issue to the bug tracker at <http://code.google.com/p/blazeblogger/issues/>, or visit
the discussion group at <http://groups.google.com/group/blazeblogger/>.
COPYRIGHT
Copyright (C) 2008-2011 Jaromir Hradilek
This program is free software; see the source for copying conditions. It is distributed in the hope that it will be useful, but WITHOUT ANY
WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Version 1.2.0 2012-03-05 BLAZE-REMOVE(1)