Sed Question?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sed Question?
# 15  
Old 02-03-2008
Hi.

OK, let us assume that we can easily get rid of the commas.

Then we are left with one line that contains a list of numbers, each separated from the next by a blank character. We have an arranging program -- sort -- that orders lines. What transformation would get those two ideas together? What do we need to do? ... cheers, drl
# 16  
Old 02-03-2008
drl,

Are you saying I need to get each of the numbers into a separate line?
# 17  
Old 02-03-2008
Code:
#!/bin/sh
s="12-13 15-18 23-28 36-38 42-43 53-56 70-72 76 80-86 93-110 119-128"
echo $s | awk '
{
  for (i=1;i<=NF;i++){
    n=split($i,a,"-")
    for (j=a[1];j<=a[n];j++){
        printf  "%d " ,j  
    }
    print ""
  }
}'

output:
Code:
# ./test.sh
12 13
15 16 17 18
23 24 25 26 27 28
36 37 38
42 43
53 54 55 56
70 71 72
76
80 81 82 83 84 85 86
93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
119 120 121 122 123 124 125 126 127 128

# 18  
Old 02-03-2008
Hi.
Quote:
Originally Posted by Kweekwom
drl,

Are you saying I need to get each of the numbers into a separate line?
Yes, exactly! Then, presumably, you'd want to put them back together again. Here's one way to do that:
Code:
#!/bin/bash3 -

# @(#) user2    Demonstrate eval and tr.

# echo "Input first set of nodes"

# read node1 # This is where you insert the string of numbers
# node1="435-437,476-492 70-72,76,80-86"
node1="435-437 476-492 70-72 76 80-86"

result=`echo $node1 | sed -r -e 's/([0-9]+)-([0-9]+)[ ]*/{\1..\2} /g'`

echo {1..5}

eval echo $result |
tee t1 |
tr '[, ]' '\n' |
tee t2 |
sort -n |
tr '\n' ' '
echo

exit 0

Producing:
Code:
% ./user2
1 2 3 4 5
70 71 72 76 80 81 82 83 84 85 86 435 436 437 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492

The tee allows you to look at the intermediate form of the data. See the man pages for details on the rest. The tr especially often varies from system to system.

That's part of the design of *nix -- put general tools together to solve specific problems.

Best wishes ... cheers, drl
# 19  
Old 02-04-2008
Wow drl, that's really cool. It works just as I need it to! I'll definitely delve deeper into those commands so I can understand them better. Thanks so much for your help!
# 20  
Old 02-04-2008
Hi.
Quote:
Originally Posted by Kweekwom
... Thanks so much for your help!
You're welcome.

If you get a chance, awk, as in the solution that ghostdog74 posted, is worthwhile to learn. It breaks up input lines into fields, which can then be re-arranged, deleted, assigned to, etc. Very useful, and, once you get the idea of:
Code:
  pattern-part { action-part }

you can do a lot with very little work ... cheers, drl
# 21  
Old 02-04-2008
Just for fun:

Code:
$ input="34-40 10-20 4-8"

$ output=$(echo $input |perl -nae '$,=$\=" "; print foreach(sort {$a<=>$b} map( {s/-/../g ; eval $_ } @F))')

$ echo $output
4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 20 34 35 36 37 38 39 40

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SED question

I am trying to write a script that will take an input text file in the format person: place: phonenumber; person: place: phonenumber; person: place: phonenumber; ... and output it using sed too: Name ######## Location ######### Phone Number... (1 Reply)
Discussion started by: jmack56
1 Replies

2. Shell Programming and Scripting

Sed question

I need to replace the numbers with a new string. How can I give a wildcard for the different # of numbers sed '/abcdef/s/abcdef=*/abcdef=999999/'<foo>foo1 From: To: abcdef=1234 abcdef=999999 abcdef=12345 abcdef=999999 abcdef=123456... (10 Replies)
Discussion started by: beppler
10 Replies

3. Shell Programming and Scripting

sed question

hi i have a file with this line: variable=/export/home/oracle I want to change the file so that the path is replaced with the value of another variable var2=/tmp/anything. how to do this in sed? thx (4 Replies)
Discussion started by: melanie_pfefer
4 Replies

4. Shell Programming and Scripting

Sed Question 1. (Don't quite know how to use sed! Thanks)

Write a sed script to extract the year, rank, and stock for the most recent 10 years available in the file top10_mktval.csv, and output in the following format: ------------------------------ YEAR |RANK| STOCK ------------------------------ 2007 | 1 | Exxon... (1 Reply)
Discussion started by: beibeiatNY
1 Replies

5. UNIX for Dummies Questions & Answers

sed question

How would I use sed to print everything on the line after the regular expresion? I have a configuration file setting several variables. cfg.dat DDB = cpptest SUDBNAME = sucpptestdb host = cpptest Example I want to search for the regular expresion 'SUDBNAME =' and print everything on... (3 Replies)
Discussion started by: orahi001
3 Replies

6. Shell Programming and Scripting

sed question

I have a file that conatins following info Policy1=U|guestRoom=test1idCode=5(1):!:Amenity2=U|RoomId=testrma=4(1):!:| GuestRoomAmenity1=U|guestRoomId=testguest1id^rmaCode=5(1):!:| I need it to look like this Policy1=U|guestRoom=test1idCode Amenity2=U|RoomId=testrmaCode... (2 Replies)
Discussion started by: arushunter
2 Replies

7. Shell Programming and Scripting

sed question

Hi, :) can any body explain the following statement sed 's/\(\)- ]//g' cheers RRK (3 Replies)
Discussion started by: ravi raj kumar
3 Replies

8. Shell Programming and Scripting

sed question

Hi, When deleting lines using sed, as i understand the lines are redirected to the standard output. What i'm unclear about is how to actually modify the file? If I write the command sed '1,2d' test it will display lines one and 2 onto the screen however the file is not modified? I think my... (5 Replies)
Discussion started by: c19h28O2
5 Replies

9. Shell Programming and Scripting

sed question (again)

hello there, I have a sed question. I have a file (temp.srv), in it it has v1_host1 v2_host2 And I have another file (temp2.srv), in it is has v1_host3_date v1_host1 v2_host2 v2_host4_date v3_host5_date I had used a script to remove the name from temp2.srv base on the name inside... (3 Replies)
Discussion started by: ahtat99
3 Replies

10. Shell Programming and Scripting

Sed Question

Hi, Is there any way to traverse the file once and look for the following conditions in one sweep instead of going over the file 3 times with different search criteria...... sed -n '/^ORA-07445/ p' /tmp/t$$ > ${OERRFILE} sed -n '/^ORA-00600/ p' /tmp/t$$ >> ${OERRFILE} ... (1 Reply)
Discussion started by: YS2002
1 Replies
Login or Register to Ask a Question