Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

remove and replace

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting remove and replace
# 1  
Old 08-25-2009
remove and replace
Hi Friends,

I have following string.
1:Y 2:Y 3:Y 4:Y 5:Y 6:N 7:N 8:Y 9:N 10:N 11:N 12:N 13:Y 14:Y 15:411

I need to have follwoing string.
'Y','Y','Y','Y','Y','N','N','Y','N','N','N','N','Y','Y','411'

Thank you,
Prashant
# 2  
Old 08-25-2009
xx='1:Y 2:Y 3:Y 4:Y 5:Y 6:N 7:N 8:Y 9:N 10:N 11:N 12:N 13:Y 14:Y 15:411'
echo $xx\' | sed "s/[[:digit:]]\+:/'/g; s/ /',/g"
# 3  
Old 08-25-2009
Thank you so much.
# 4  
Old 08-25-2009
Quote:
Originally Posted by edidataguy
xx='1:Y 2:Y 3:Y 4:Y 5:Y 6:N 7:N 8:Y 9:N 10:N 11:N 12:N 13:Y 14:Y 15:411'
echo $xx\' | sed "s/[[:digit:]]\+:/'/g; s/ /',/g"
Some implementations of sed don't seem to like that (eg mine Smilie )
I fiddled it a teeny bit to get:
Code:
echo $string | sed "s/[0-9]*\:/\'/g; s/ /\',/g;s/$/\'/"

(Also added the s/$/\'/ bit to avoid having to tack a ' on the end of the line manually)
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Remove first 3 leadings zeros and replace with space

Hi Folks - I need help manipulating a file. For column 2, I need to replace the first 3 leading zeros with spaces. The file looks like such: 00098|00011250000003|00000000000.0200|D|1|07|51|04INDP |04|00820|CS|000000|092717|000000000000.0000|000|... (3 Replies)
Discussion started by: SIMMS7400
3 Replies

2. UNIX for Beginners Questions & Answers

Remove characters and replace with space

tr -cd '\11\12\15\40-\176' < file-with-binary-chars > clean-file This removes special characters but how can I replace it with space (4 Replies)
Discussion started by: eskay
4 Replies

3. UNIX for Dummies Questions & Answers

How to replace and remove few junk characters from a specific field?

I would like to remove all characters starting with "%" and ending with ")" in the 4th field - please help!! 1412007819.864 /device/services/heartbeatxx 204 0.547%!i(int=0) 0.434 0.112 1412007819.866 /device/services/heartbeatxx 204 0.547%!i(int=1) 0.423 0.123... (10 Replies)
Discussion started by: snemuk14
10 Replies

4. Shell Programming and Scripting

Remove/replace the very first character/symbol match

cat file.txt file 1123.x July 23:222 /cd/hh2/k39/ss2/f7d8d9d8e6r5t4s/dd2/e/s7a/s7a2afa5017d8b975-1.7-1395610245-b22e19bbc477b134 i wish to only extract out the 1.7 (anything within the first - -) i try to look for the sed command under match the first occurence of pattern but out of luck, my... (6 Replies)
Discussion started by: ctphua
6 Replies

5. Shell Programming and Scripting

ksh Remove and replace repeated in file

Hi, i need to read a line from a file and count the number of times it appear in, then continuous to the second line with the same. So when i count a line i have to remove all duplicates in the file to not count it another time. while read line do n=$(grep -c $line File) print "$line... (5 Replies)
Discussion started by: ToniX
5 Replies

6. Solaris

Cannot remove and replace failed disk

-bash-3.00# zpool detach zonepool c1t1d0 cannot detach c1t1d0: only applicable to mirror and replacing vdevs -bash-3.00# zpool remove zonepool c1t1d0 cannot remove c1t1d0: only inactive hot spares, cache, top-level, or log devices can be removed -bash-3.00# zpool offline zonepool c1t1d0... (3 Replies)
Discussion started by: LittleLebowski
3 Replies

7. Shell Programming and Scripting

Replace/Remove not specific text in perl

Hello, Consider that i have many files that have the below format: file1 900 7777 1000 5 6 23 nnnnnnnnnnnnnnnnnn 1100 kkkkkkk file2 900 1989 1000 5 3 10 kkkdfdfdffd 1100 kkkkkkk What i would like to do is on every file to search the line that starts with... (4 Replies)
Discussion started by: chriss_58
4 Replies

8. UNIX for Advanced & Expert Users

Locate text in file then remove and replace

I'm trying to locate a block of text in a file, remove it and then replace with a new block. I can find the first line number that the text starts on using grep -n. I then need to locate the ending line by searching for the string "}" that follows the line I found. Here's the steps I need to... (1 Reply)
Discussion started by: lchandle
1 Replies

9. Shell Programming and Scripting

remove and replace text in a file

Hello all, How would I go to a particular line in a file and remove certain text from it and replace with something that I want it to be there. like: file /etc/abc now look for line HOME="/export/xyz" in /etc/abc and then replace with HOME=/"export/xyz1" thanks in advance guys. (1 Reply)
Discussion started by: solaix14
1 Replies

10. Shell Programming and Scripting

Remove spaces between charc and replace it with ','.

Hi, Below is my output file: (The below line has multiple spaces bet charc and I want to replace spaces with "," only for the first line) NYCCMS97KJ931 01-JUN-08 1214957 I want this to be: ... (5 Replies)
Discussion started by: smc3
5 Replies
Login or Register to Ask a Question