Help with removal of numericals in a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with removal of numericals in a file
# 1  
Old 05-06-2011
Computer Help with removal of numericals in a file

I have a file from which I want to eliminate the numerical values..
The contents of the file are as shown below..
Code:
1    a1,b,2    1,b,c
2    a2,4,b    a,b,2

From the above file I want eliminate only the numberical values(except the line numbers which are at the beginning)..

The file consists of a line number, followed by a tab, followed by two columns with a tab seperating them!

I've used the sed command without success..
Please take a look at my code..
I'm trying to replace a number with a comma (,)
Please note: I don't want to eliminate the digit '1' in the variable "a1".. I need to eliminate only pure numbers..

Code:
sed 's/,[0-9]+[,]*/,/g
s/,[0-9]+[\t]/,/g' file.txt

But its not working!! Please help me! Smilie
# 2  
Old 05-06-2011
Show us desired output for that sample data.
# 3  
Old 05-06-2011
Quote:
Originally Posted by bartus11
Show us desired output for that sample data.
Ya here it goes..

Code:
1    a1,b,,    ,,b,c
2    a2,,,b    a,b,,

The numbers should be replaced with a semi colon(,)..
# 4  
Old 05-06-2011
Code:
sed ':b s/\(,[^0-9]*\)[0-9]/\1,/g;t b' infile

or
Code:
sed ':b s/\(,[^[:digit:]]*\)[[:digit:]]/\1,/g;t b' infile

Tested successfully on linux / GNU sed.

You may get a "label too long" error on Sun sed.
i didn't test on other plateform.

Last edited by ctsgnb; 05-06-2011 at 05:46 AM..
This User Gave Thanks to ctsgnb For This Post:
# 5  
Old 05-06-2011
A perl:
Code:
perl -pne 's/[^^](\b)\d[,\s]/\1,,/g' file

# 6  
Old 05-06-2011
Quote:
Originally Posted by Klashxx
A perl:
Code:
perl -pne 's/[^^](\b)\d[,\s]/\1,,/g' file

Hey its not working for the file given below..
# 7  
Old 05-06-2011
MySQL

Quote:
Originally Posted by ctsgnb
Code:
sed ':b s/\(,[^0-9]*\)[0-9]/\1,/g;t b' infile

or
Code:
sed ':b s/\(,[^[:digit:]]*\)[[:digit:]]/\1,/g;t b' infile

Tested successfully on linux / GNU sed.

You may get a "label too long" error on Sun sed.
i didn't test on other plateform.
Thank u so much!! Smilie
Its working! Smilie

But I'm a noob.. could you please tell me what is ":b" "t" and "b" doing in the script??
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing string from CSV file by provide removal string from other file

What I need is to remove the text from Location_file.txt from each line matching all entries from Remove_location.txt Location_file.txt FlowPrePaid, h3nmg1cm2,Jamaica_MTAImageFileFlowPrePaid,h0nmg1cm1, Flow_BeatTest,FlowRockTest FlowNewTest,FlowNewTest,h0nmg1cm1 PartiallySubscribed,... (3 Replies)
Discussion started by: ketanraut
3 Replies

2. Shell Programming and Scripting

Honey, I broke awk! (duplicate line removal in 30M line 3.7GB csv file)

I have a script that builds a database ~30 million lines, ~3.7 GB .cvs file. After multiple optimzations It takes about 62 min to bring in and parse all the files and used to take 10 min to remove duplicates until I was requested to add another column. I am using the highly optimized awk code: awk... (34 Replies)
Discussion started by: Michael Stora
34 Replies

3. Shell Programming and Scripting

String removal from file

Dear all From below mention input file I needed op file as show below. I am using below code but not worked. I/p file BSCBCH1 EXAL-1-4 WO* SMPS MAINS FAIL BSCBCH1 EXAL-1-5 WO* SMPS RECTIFIER FAIL BSCBCH1 EXAL-1-6 WO* SMPS MAJOR ALARM BSCBCH2 EXAL-1-10 WO* ... (5 Replies)
Discussion started by: jaydeep_sadaria
5 Replies

4. Solaris

Removal of zip file permanently

Hi Everyone, I see some peculier thing happening on my server. I have one zipped file created long back as a normal user and trying to remove it now. When i tried to remove as that particular user, i was not able to do that. So i logged in as a root user and removed that successfully. But it... (8 Replies)
Discussion started by: Sricharan21
8 Replies

5. Shell Programming and Scripting

Removal of HTML ASCII Codes from file

Hi all, I have a file with extended ASCII codes in the description which needs to be removed. List of extended ascii codes "Œ", "œ", "Š", "š", "Ÿ", "ƒ", "-", "-", "‘", "'", "‚", "“", "”", "„","†", "‡", "•", "...", "‰", "€", "™" Sample data: Test Details-HAVE BEEN PUBLISHED... (1 Reply)
Discussion started by: btt3165
1 Replies

6. Shell Programming and Scripting

Help with removal of blank spaces in a file

Hello.. I have a text file. I want to remove all the blank spaces(except tab) from the file.. I tried using sed command as shown below sed 's/ //g' file1 But the problem with the above command is that it also eliminates 'tab' which is between the columns.. For example if the contents... (7 Replies)
Discussion started by: abk07
7 Replies

7. Shell Programming and Scripting

Removal of file extension question

All, I know that this will remove a file extension from a file name, but reading on the documentation on how it works confuses me. ${filename%.*}Can anyone explain what exactly is going on here? Filename is the pattern and % says to cut anything that starts with .? Also, can I run this... (4 Replies)
Discussion started by: markdjones82
4 Replies

8. Shell Programming and Scripting

Removal of carriage returns from a comma delimited file

Hi, I have a file which is having some carriage return in one of the field for which single line is coming in multiple lines. I want to combine all those multiple lines of that field into one line. Eg: Input: Id, Name, Location, Comments, Dept 2, John, US, I am from US. I... (5 Replies)
Discussion started by: mahish20
5 Replies

9. Shell Programming and Scripting

Removal of Duplicate Entries from the file

I have a file which consists of 1000 entries. Out of 1000 entries i have 500 Duplicate Entires. I want to remove the first Duplicate Entry (i,e entire Line) in the File. The example of the File is shown below: 8244100010143276|MARISOL CARO||MORALES|HSD768|CARR 430 KM 1.7 ... (1 Reply)
Discussion started by: ravi_rn
1 Replies

10. Solaris

UNIX File removal without conformation

I need to remove permanently some 3 GB of temp folder which contains Log file, simulation files from my disk. if i use "rm - rf <filename>" command it asks about conformation for accessing each folder and for removing every file and giving yes to every message in terminal window is very... (2 Replies)
Discussion started by: rajharvijay
2 Replies
Login or Register to Ask a Question