removing commas from text file

hcclnoodles · #1 (**permalink**) 03-24-2003

Dear all

I have a file which looks like this

xxxxxxxxxxxxxx,xxx,xxxxxxxxxx
xxxxxxxxxxxxxx,xxx,xxxxxxxxxx

etc

basically 14 characters then a comma, three characters, then a comma then 10 characters. We are uploading this file to our mainframe and they want the commas removed, so it looks like this

xxxxxxxxxxxxxxxxxxxxxxxxxxx

Has anybody got any ideas on how to do this?. Note, the file will always be the same format, but will vary in the number of lines

Any help would be greatly appreciated

oombera · #2 (**permalink**) 03-24-2003

Well, here's one way:

Code:

sed -e 's/xxxxxxxxxxxxxx,xxx,xxxxxxxxxx/xxxxxxxxxxxxxxxxxxxxxxxxxxx/' some_file > TMP_00
cp TMP_00 some_file
rm TMP_00

Perderabo · #3 (**permalink**) 03-24-2003

That sed solution will work only if each line literally contains those x's.

To get rid of all commas in a file, change that to:

sed 's/,//g' some_file > TMP_00

oombera · #4 (**permalink**) 03-24-2003

wow i must be tired.. your solution looks much better perderabo

s93366 · #5 (**permalink**) 03-25-2003

or you can use the tr command

cat test.txt|tr -d , > out.txt

Have fun!
/Peter

hcclnoodles · #6 (**permalink**) 03-26-2003

Thanks Guys, that now works

regards

WIntellect · #7 (**permalink**) 03-26-2003

Quote:

Originally posted by Perderabo
sed 's/,//g' some_file > TMP_00

For a bit of fun (mine) the "perl" version is VERY similar to the sed version:

Code:

perl -pe 's/,//g;' < some_file > TMP_00

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Removing text from a line in a file	outthere_3	Shell Programming and Scripting	10	02-13-2008 03:38 AM
Removing empty spaces and adding commas	jazz	High Level Programming	4	11-13-2006 09:54 AM
Removing a particular line from a text file	sendhilmani123	Shell Programming and Scripting	5	05-31-2006 09:32 AM
Padding zeros after removing commas in file	pranag21	HP-UX	1	11-09-2005 10:22 PM
Removing lines in a text file.	WABonnett	Shell Programming and Scripting	4	11-25-2003 11:27 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by