sed with special characters

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sed with special characters
# 1  
Old 04-06-2009
sed with special characters


I am reading a file (GC_JAR.log) which has entries like:

511725.629, 0.1122672 secs]
525268.975, 0.1240036 secs]
527181.835, 0.2068215 secs]
527914.287, 0.2884801 secs]
528457.134, 0.2548725 secs]

I want to replace all the entries of "secs]" with just "secs"

Thus, the output should be like:

511725.629, 0.1122672 secs
525268.975, 0.1240036 secs
527181.835, 0.2068215 secs
527914.287, 0.2884801 secs
528457.134, 0.2548725 secs

I tried using sed but it's not working for some reason. I read line by line from the original file ( GC_JAR.log ) and dump the final output in GC_cycles.csv

# !/bin/bash
cat GC_JAR.log | while read line
echo "${line}" | sed 's/"${SOURCE}"/"${TARGET}"/g' >> GC_cycles.csv

Any ideas please? what's going wrong with sed command there.
# 2  
Old 04-06-2009
single quotes stop variable expansion

# !/bin/bash
sed "s/${SOURCE}/${TARGET}/g" GC_JAR.log  > GC_cycles.csv

# 3  
Old 04-06-2009
Thanks! that works

I am newbie.. still learning how to use single quotes and double quotes :-)

I still need to do another operation on the file

With the above sed operation, I get the output file as below ( GC_cycles.csv)

511725.629, 0.1122672 secs
525268.975, 0.1240036 secs
527181.835, 0.2068215 secs
527914.287, 0.2884801 secs
528457.134, 0.2548725 secs

Now, I want to convert the first field ( which is in seconds currently) to hours.

I used the following:

echo "Converting seconds to hours"
cat GC_cycles.csv | while read line
X=`echo "${line}" | awk -F"," '{ print $1}'` # X is the first field
X=`echo $X / 60/ 60 | bc` # Convert seconds to hours
Y=`echo "${line}" | awk -F"," '{ print $2}'` # Y is the second field
echo $X "hrs" "," $Y >> Final_GC_cycles.csv

Now I get the output as:

142 hrs , 0.1122672 secs
145 hrs , 0.1240036 secs
146 hrs , 0.2068215 secs
146 hrs , 0.2884801 secs
146 hrs , 0.2548725 secs

There are 2 things which I want to look at:
1) the value of X is coming in integer. How can I get it to be a floating number? with rounding to 1 decimal place.
2) Is there a more efficient way to write the above code?
# 4  
Old 04-06-2009
What you have looks fine, just replace the bc line with this:

X=`echo "scale=1;$X / 60/ 60" | bc` # Convert seconds to hours, with 1 decimal.

The "scale" variable defines your precision. It's documented in the "bc" man page. :-)

I've added my version of your program above:

#! /bin/bash

cat data | sed 's/,//g' |
while read a b c
x=$(echo "scale=1;$a/60/60" | bc)
echo "$x hrs, $b $c"

And this was done without the need of calling awk; of course I called "sed" and "bc". but I think you get the idea.

Last edited by sandholm; 04-06-2009 at 10:47 PM.. Reason: further example
# 5  
Old 04-06-2009
When using perl I use the time module for conversions. In shell it is a bit more work. Here is a function I use for converting seconds, which you can include in your script
 convert_seconds() {
   days=$(expr $time / 86400)
   hour1=$(expr $time / 3600)
   hour2=$(expr $days \* 24)
   hours=$(expr $hour1 - $hour2)
   minute1=$(expr $time / 60)
   minute2=$(expr $days \* 1440)
   minute3=$(expr $hours \* 60)
   minutes=$(expr $minute1 - $minute2 - $minute3)
   second1=$(expr $minutes \* 60)
   second2=$(expr $hours \* 3600)
   second3=$(expr $days \* 1440)
   seconds=$(expr $time - $second1 - $second2 - $second3)

   echo "
     days   =$days
     hours  =$hours
if [[ -n $1 ]]; then
  convert_seconds $1

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed in a while loop with special characters

I have the foolowing data file: File1 <p name="A">5004</p> <p name="B">5004</p> <p name="C">5004</p> <p name="A">15004</p> <p name="B">15004</p> <p name="C">15004</p> In a while loop using sed (100 of line need to be replace), I need the output to File3:... (2 Replies)
Discussion started by: bobo
2 Replies

2. Shell Programming and Scripting

sed special characters issues

I am dusting off the sed cobwebs and had a basic question: I have a file that contains: $firewall = "on"; $cache = "on"; $dataset{'mary had a little lamb'} = "on"; and want to only change the contents of what is between the single quotes: $dataset{'big bad wolf'} = "on"; I... (3 Replies)
Discussion started by: metallica1973
3 Replies

3. Shell Programming and Scripting

Sed - remove special characters

Hi, I have a file with this line, it's always in the first line: I want to remove these special characters: ´╗┐ file1 ´╗┐\\bar\c$\test2\;3.348.118 Bytes;160 ;3 \\bar\c$\test\;35 Bytes;2 ;1 I want the same file to be only \\bar\c$\test2\;3.348.118 Bytes;160 ;3 \\bar\c$\test\;35... (4 Replies)
Discussion started by: nakaedu
4 Replies

4. Shell Programming and Scripting

sed special characters issue

Hi I'm trying to replace string1 by string2 in file homepage.htm as follows but is not working. Please Help: sedsed -i "s@'://your server name:port/test/owa'@'://'@g" homepage.htm Where, String1 ://your server name:port/test/owa String2... (3 Replies)
Discussion started by: koazter
3 Replies

5. Shell Programming and Scripting

Escape special characters in SED

Need help in escaping special characters in sed command. Here is the the string which i am trying to find a replace with From :- REQUEST_TYPE=PIXEL&amp;MSG_ID={//MESSAGE_ID} To :- REQUEST_TYPE=PIXEL&amp;MSG_ID= X_EDELIVERY_MESSAGE_ID &amp; BATCH_ID= X_EDELIVERY_BATCH_ID Here is the sed command i am... (2 Replies)
Discussion started by: aakishore
2 Replies

6. Shell Programming and Scripting

SED with Special characters

Hello All Seeking the right one SED command. My attempt is: From orginal.txt by SED to target.txt sed -i "/('outbound-callerid/a\$ext->add($context, $exten, '', new ext_SipAddHeader('P-Preferred-Identity', '<sip:${CALLERID(nummer)}>'));" orginal.txtWhat am make wrong?:wall: ... (5 Replies)
Discussion started by: mdbinder
5 Replies

7. Shell Programming and Scripting

Using sed to replace special characters

Hi everyone I have file1 contains: '7832' ' 8765 6543 I want a sed command that will format as: '7832' , '8765' , '6543' I tried sed -e s/\'//g -e 's/^*//;s/*$//' file1 > file2 sed -e :a -e '$!N; s/\n/ /; ta' file2 which gives: 7832 8765 6543 I need some help to continue with... (5 Replies)
Discussion started by: nimo
5 Replies

8. Shell Programming and Scripting

sed with many special characters

I started with this: counter1=1 cp file.txt file_${counter1}.tmp while read name1 do echo $name1 counter2=`expr $counter1 + 1` sed /'${name1}'/d file_${counter1}.txt > file_${counter2}.txt counter1=`expr $counter1 + 1` done < source.txtsource.txt contains the... (1 Reply)
Discussion started by: lakanino
1 Replies

9. Shell Programming and Scripting

Changing Special Characters Using Sed

Hi. Does anyone know how to use the sed command to change the special border characters on this .per file. I have to edit about 80 .per files. I need a sed script to change the below 3 and A characters. ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ³ Test Islands, Office of Public Health -- WIC... (4 Replies)
Discussion started by: cstovall
4 Replies

10. Shell Programming and Scripting

awk/sed with special characters

i have this script that searches for a pattern. However it fails if the pattern includes some special characters. So far, it fails with the following strings: 1. -Cr 2. $Mj 3. H'412 would a sed or awk be more effective? i don't want the users to put the (\) during the search (they... (5 Replies)
Discussion started by: apalex
5 Replies
Login or Register to Ask a Question

Featured Tech Videos