Sponsored Content
Top Forums Shell Programming and Scripting Remove duplicate commas after exporting excel file to csv Post 302444610 by Spunkerspawn on Thursday 12th of August 2010 08:45:17 AM
Old 08-12-2010
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:
Code:
AVAE34-IS1472-2P01.1,In Service,AMM 2PB,somsrv01,12713,AVAE34-IS1472-2P01,MTN12713,1,,,,172.17.213.145,,161,,,null,ISHB05_MECIDIYEKOY_172.17.213.XX.5,,,,,,,,,,,,,,,,control_user

Is there a sed command I can execute to delete these repeating commas?

I tried this one:

Code:
sed 's/,,*$/,/'

but it didn't work.

Thanks guys.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Exporting text file data to csv

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)
Discussion started by: l_jayakumar
3 Replies

2. Shell Programming and Scripting

replacing commas with tilde in csv file.

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)
Discussion started by: femig
4 Replies

3. Shell Programming and Scripting

Retaining the Unix CSV format in Excel format while exporting

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)
Discussion started by: rawat_me01
2 Replies

4. Shell Programming and Scripting

Exporting log file into Excel

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)
Discussion started by: harshaganapathy
1 Replies

5. Shell Programming and Scripting

shell script to remove extra commas from CSV outp file

Name,,,,,,,,,,,,,,,,,,,,Domain,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Contact,Phone,Email,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Location -----------------------,------------------------------------------------,-------,-----,---------------------------------,------------------------------------ ----... (1 Reply)
Discussion started by: sreenath1037
1 Replies

6. Shell Programming and Scripting

CSV with commas in field values, remove duplicates, cut columns

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)
Discussion started by: krishnix
4 Replies

7. Shell Programming and Scripting

Adding Extra Commas to a CSV file

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)
Discussion started by: chillblue
1 Replies

8. Shell Programming and Scripting

Shell script that should remove unnecessary commas between double quotes in CSV file

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)
Discussion started by: mathias23
5 Replies

9. UNIX for Beginners Questions & Answers

Removing commas from CSV file

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)
Discussion started by: preema
2 Replies

10. Shell Programming and Scripting

How to remove unwanted commas from a .csv file?

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
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)
All times are GMT -4. The time now is 12:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy