Works like a champ and I was sooo close. Thanks a lot for your help!! On Fri, Aug 19, 2011 at 2:28 PM, Josh Miller <joshua@xxxxxxxxxxxxxxxxx>wrote: > On 08/19/2011 11:06 AM, Rob DeSanno wrote: > ... > > What I am trying to do is to change the "-" character to something else >> ONLY >> when it is next to a number [0-9]. What makes this a challenge for me is >> that it can also exist next to a letter but never more than once next to a >> number. >> >> The line I am using is below and works fine for what I need expect that >> the >> first digit of the number at the end is cut off in the table I am trying >> to >> build. >> >> '102.1'>Columbus-612 >> '104.1'>Fredericksburg-628 >> '108.1'>Garden-Grove-736 >> '101.1'>Mission-Viejo-1514 >> '104.1'>Fort-Worth-418 >> '1030.1'>Ft.-Lauderdale-304 >> '1050.1'>Hamilton-713 >> >> sed -e "s/^'/\<tr\>\<td\>/" $stores_down | sed -e "s/'>/\<\/td\>\<td\>/" | >> *sed >> -e "s/-[0-9]/\<\/td\>\<td\>/"* | sed -e "s/$/\<\/td\>\<\/tr\>/">> $log >> > ... > > Hi Rob, > > You're matching the hyphen and the digit following it, without capturing > the digit to include in the resulting output. > > Try this, I've split the sed command into a sed script (file.sed) and the > input file into another file (file.txt): > > > cat file.txt > > '102.1'>Columbus-612 > '104.1'>Fredericksburg-628 > '108.1'>Garden-Grove-736 > '101.1'>Mission-Viejo-1514 > '104.1'>Fort-Worth-418 > '1030.1'>Ft.-Lauderdale-304 > '1050.1'>Hamilton-713 > > > cat file.sed > # for each line beginning with a single quote, end the table and row > s/^'/\<tr\>\<td\>/ > # for each '>, replace with cell divider > s/'>/\<\/td\>\<td\>/ > # for each hyphen digit, replace hyphen with cell divider > s/-\([0-9]\)/\<\/td\>\<td\>\1/ > # for each line ending, replace with cell/row ending > s/$/\<\/td\>\<\/tr\>/ > > > > sed -f file.sed file.txt > <tr><td>102.1</td><td>**Columbus</td><td>612</td></tr> > <tr><td>104.1</td><td>**Fredericksburg</td><td>628</**td></tr> > <tr><td>108.1</td><td>Garden-**Grove</td><td>736</td></tr> > <tr><td>101.1</td><td>Mission-**Viejo</td><td>1514</td></tr> > <tr><td>104.1</td><td>Fort-**Worth</td><td>418</td></tr> > <tr><td>1030.1</td><td>Ft.-**Lauderdale</td><td>304</td></**tr> > <tr><td>1050.1</td><td>**Hamilton</td><td>713</td></tr> > > > > HTH, > -- > Josh Miller > Open Source Solutions Architect > http://itsecureadmin.com/ > > -- > redhat-list mailing list > unsubscribe mailto:redhat-list-request@**redhat.com<redhat-list-request@xxxxxxxxxx> > ?subject=unsubscribe > https://www.redhat.com/**mailman/listinfo/redhat-list<https://www.redhat.com/mailman/listinfo/redhat-list> > -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
