Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Editing Commas in a textfile using sed
Top Forums Shell Programming and Scripting Editing Commas in a textfile using sed Post 302351975 by repinementer on Thursday 10th of September 2009 06:14:39 AM
Old 09-10-2009
Editing Commas in a textfile using sed
Hi guys
task removing the last commas of 5th and 6th columns. The bug in the script is causing effect because of whitespaces around commas. I tried to delete white spaces first and running the above script. but still some where getting the results wrong.

I already have a script to do this task but somewhere bug located in the script. Could please debug it. Thanx

script

Code:
sed -e 's/,[^0-9]//g' -e 's/,$//g' file_name

input
Code:
 
7829885 7831552 + 1    1667,               0,
35934936 35937087 - 2  1281,870,       0,1281,
35934936 35937087 - 2  1281, 870,      0 ,1281 ,
35934936 35937087 - 2  1281 , 870 ,    0, 1281 ,

output should be like this
Code:
 
7829885 7831552 + 1 1667 0
35934936 35937087 - 2 1281,870   0,1281
35934936 35937087 - 2 1281,870   0,1281
35934936 35937087 - 2 1281,870   0,1281

Last edited by repinementer; 09-10-2009 at 09:44 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Editing File using awk/sed

Hello Awk Gurus, Can anyone of you help me with the below problem. I have got a file having data in below format pmFaultyTransportBlocks ----------------------- 9842993 pmFrmNoOfDiscRachFrames ----------------------- NULL pmNoRecRandomAccSuccess -----------------------... (4 Replies)
Discussion started by: Mohammed
4 Replies

2. UNIX for Dummies Questions & Answers

Inserting commas and replacing backslashes with commas

Hi, Newbie here. I have a file that consists of data that I want to convert to a csv file. For example: Jul 20 2008 1111 / visit home / BlackBerry8830/4.2.2 Profile/MIDP-2.0 Configuration/CLOC-1.1 VendorID/105 Jul 21 2008 22222 / add friend / BlackBerry8830/4.2.2 Profile/MIDP-2.0... (3 Replies)
Discussion started by: kangaroo
3 Replies

3. Homework & Coursework Questions

String editing using sed? awk?

1. The problem statement, all variables and given/known data: Problem Statement for project: When an account is created on the CS Unix network, a public html directory is created in the account's home directory. A default web page is put into that directory. Some users replace or... (13 Replies)
Discussion started by: peage1475
13 Replies

4. Shell Programming and Scripting

Help with sed and replacing white spaces with commas

Dear all, I am in a bit of a quandary. I have 400 text files which I need to edit and output in a very specific way. Here is a sample text file copied from gedit ... The columns will come out a bit messed up but when I cat <file>, it gives a table with six columns (0-28, tot lob vol, vcsf,... (6 Replies)
Discussion started by: antonz
6 Replies

5. Shell Programming and Scripting

sed or awk editing help

Hi all I use aix (sadly). I've got a file consisting of fields separated by commas, I need a sed or awk command that will delete all spaces between two commas as long as there are only spaces between the commas. eg ,abc, ,sd , ,dr at would become ,abc,,sd ,,dr at I have... (53 Replies)
Discussion started by: mychmose
53 Replies

6. UNIX for Dummies Questions & Answers

sed editing help....

Hello all, I need some help with sed. seems like i cant get through it. So here is what i am trying. when i do ps -ef|grep bla blah ...like below...i get /u01/app/oracle/11g/bin/tnslsnr .... but i want to replace that string with something using sed. So basically i want to get rid of... (3 Replies)
Discussion started by: abdul.irfan2
3 Replies

7. Windows & DOS: Issues & Discussions

Extracting variables between commas : GAWK or SED

Hello, I need some help, I got a CSV file called test.txt with this text in it : 08/02/2011;0,677;0,903;1,079;1,336;1,513;1,683 There's only a line and i need to copy theese numbers into variables : 0,677 0,903 1,079 1,336 1,513 1,683 The output file should look like this... (5 Replies)
Discussion started by: jujulips
5 Replies

8. UNIX for Dummies Questions & Answers

sed help finding and editing

With sed 1. I need to find a line that contains "DVM" and "73069". 2. I need to insert a double quote at the beginning of the first line of the file. These two have been driving me crazy for the last 45 minutes. Any help would be greatly appreciated. Thanks (3 Replies)
Discussion started by: nlassiter
3 Replies

9. Shell Programming and Scripting

HELP with AWK or SED. Need to replace the commas between double quotes in CSV file

Hello experts, I need to validate a csv file which contains data like this: Sample.csv "ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0 "ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0 I just need to check if all the records contain exactly the number of... (5 Replies)
Discussion started by: shell_boy23
5 Replies

10. Shell Programming and Scripting

How to separate sorte different characters from one textfile and copy them in a new textfile?

My first post, so don't kill me :) Say i open some textfile with some example like this. on the table are handy, bread and wine Now i know exactly what is in and i want to separate and sorted it in terminal to an existing file with another 2 existing lines in like this: table plane ... (3 Replies)
Discussion started by: schwatter
3 Replies

LEARN ABOUT CENTOS

column

COLUMN(1)							   User Commands							 COLUMN(1)

NAME

       column - columnate lists

SYNOPSIS

       column [options] file...

DESCRIPTION

       The column utility formats its input into multiple columns.  Rows are filled before columns.  Input is taken from file or, by default, from
       standard input.	Empty lines are ignored.

OPTIONS

       -c, --columns width
	      Output is formatted to a width specified as number of characters.

       -t, --table
	      Determine the number of columns the input contains and create a table.  Columns are delimited with whitespace, by default,  or  with
	      the characters supplied using the separator. Table output is useful for pretty-printing.

       -s, --separator separators
	      Specify possible table delimiters (default is whitespace).

       -o, --output-separator separators
	      Specify table output delimiter (default is two whitespaces).

       -x, --fillrows
	      Fill columns before filling rows.

       -h, --help
	      Print help and exit.

ENVIRONMENT

       The environment variable COLUMNS is used to determine the size of the screen if no other information is available.

EXAMPLES

       sed 's/#.*//' /etc/fstab | column -t

BUGS

       The util-linux version 2.23 changed -s option to be non-greedy, for example:

       $ printf "a:b:c
1::3
" | column  -t -s ':'

       old output:
       a  b  c
       1  3

       new output (since util-linux 2.23)
       a  b  c
       1     3

SEE ALSO

       colrm(1), ls(1), paste(1), sort(1)

HISTORY

       The column command appeared in 4.3BSD-Reno.

AVAILABILITY

       The column command is part of the util-linux package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux/.

util-linux							   October 2010 							 COLUMN(1)
All times are GMT -4. The time now is 05:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy