Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Find replace a particular string of data with wildcard

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Find replace a particular string of data with wildcard
# 1  
Old 08-10-2010
Find replace a particular string of data with wildcard
Hi

I am having a csv file in which lots of data are available wherein i need to find a particular kind of data and replace it with null value.

here is the sample data..
Quote:
404-064-3204-204-10723 404-64-401-2081 404-064-3204-204-10721 404-064-3204-204-10653 404-064-3204-204-10652 404-064-3204-204-10651 404-64-401-2082 404-64-401-2251 404-64-401-2253 404-64-401-2093 404-64-401-2083
I need to find the string starting with 404-064- and up to the first space i have to remove the data and keep the remaining data as it is.

i.e the result expected is
Quote:
404-64-401-2081 404-64-401-2082 404-64-401-2251 404-64-401-2253 404-64-401-2093 404-64-401-2083
how to achieve this?
# 2  
Old 08-10-2010
Code:
tr  " " "\n" <file |grep -v 404-064- | tr "\n" " "

# 3  
Old 08-10-2010
Hi.

Your desired output is slightly ambiguous (much shorter than it should look).

Code:
$ sed "/404-064-/ s/[^ ]* //" file

Gives:

Code:
404-64-401-2081 404-064-3204-204-10721 404-064-3204-204-10653 404-064-3204-204-10652 404-064-3204-204-10651 404-64-401-2082 404-64-401-2251 404-64-401-2253 404-64-401-2093 404-64-401-2083

I used the number 404-64-401-2081 from your output as a reference.

Plus, for a CSV, I don't see any comma's Smilie
# 4  
Old 08-10-2010
hi,

i have given only one column value in the data provided...and moreover i need to find and replace whereever that 404-064-xxxx-xxx-xxxx (any length upto space) has to be removed...
# 5  
Old 08-10-2010
Hi

Code:
sed -r "s/404-064-[0-9-]+ //g" file

Guru.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace String matching wildcard pattern

Hi, I know how to replace a string with another in a file. But, i wish to replace the below string pattern EncryptedPassword="{gafgfa}]\asffafsf312a" i.e EncryptedPassword="<any random string>" To EncryptedPassword="" i.e remove the random password to a empty string. Can you... (3 Replies)
Discussion started by: mohtashims
3 Replies

2. UNIX for Beginners Questions & Answers

Find and replace with wildcard

HI there, I am trying to find and replace with wildcard with data chr1 69511 69511 A G 1/1:0,34:791,78,0:78:34 0/1:55,60:1130,0,1513:99:116 1/1:0,28:630,63,0:63:28 0/1:0,34:626,57,0:57:34 To this chr1 69511 69511 A G homo hetero homo hetero Where I find and replace 0/1 with... (3 Replies)
Discussion started by: daashti
3 Replies

3. Solaris

How to find and replace a string?

Dear All I need to find and replace a string in a set of files. I try as : #find / -name "*"|xargs grep "Tektra"|grep -v "Tektra GSM BTS" But it doesn't work. It just finds the string in the files. I need to find and replace it.Can you please let me know how to correct it? Thank you (2 Replies)
Discussion started by: hadimotamedi
2 Replies

4. Shell Programming and Scripting

HPUX find string in directory and filetype and replace string

Hi, Here's my dilemma. I need to replace the string Sept_2012 to Oct_2012 in all *config.py files within the current directory and below directories Is this possible? Also I am trying to find all instances of the string Sept_2012 within files in the current directory and below I have... (13 Replies)
Discussion started by: pure_jax
13 Replies

5. Shell Programming and Scripting

find string and replace with string in other file

Dear all, I need your help, I have file like this: file1:23456 01910964830098775635 34567 01942809546554654323 67589 26546854368698023653 09778 58716868568576876878 08675 86178546154065406546 08573 54165843543054354305 . .file2: 23456 25 34567 26 67589 27 (2 Replies)
Discussion started by: attila
2 Replies

6. Shell Programming and Scripting

use sed do batch wildcard string replace

Hi, Here is what I want to do I want to search local directory and its sub directory, all the files which contain any string like _12345, then remove this string. String is a combination of _ plus a random integer number. For example, here is one line in a file before <properties... (1 Reply)
Discussion started by: bp5000
1 Replies

7. Shell Programming and Scripting

Find the position of a string and replace with another string

Hi, I have a file named "Test_2008_01_21" The file contains a string "manual" that occurs many times in the file How can i find the positions of the string "manual" in the file Ex: if the string " manual " occurs three times in the file. i want to replace the second occurance of string... (6 Replies)
Discussion started by: bab123
6 Replies

8. UNIX for Dummies Questions & Answers

Find and replace character in a string

Hi all, My problem is the following: I've a script that must list all files in a directory and write this information in a text file. I've tried to get the list through ls command and then write it using msgecho msgecho "`ls $PATH_APS_JOB_ORA`" This works good but the created string... (7 Replies)
Discussion started by: callimaco0082
7 Replies

9. Programming

how to find and replace string

hi I wanted to find this char " ^M " in my file and replace it with blank space. I am using Unix system. If i give command " :%s/^M//gc " it wont work so can anyone tell what is command to find and replace thankx (3 Replies)
Discussion started by: mridula
3 Replies

10. UNIX for Dummies Questions & Answers

Find wildcard .shtml files in wildcard directories and removing them- How's it done?

I'm trying to figure out how to build a small shell script that will find old .shtml files in every /tgp/ directory on the server and delete them if they are older than 10 days... The structure of the paths are like this: /home/domains/www.domain2.com/tgp/ /home/domains/www.domain3.com/tgp/... (1 Reply)
Discussion started by: Neko
1 Replies
Login or Register to Ask a Question