topic Re: Replace a Blank Char to ~ (tilde) Using 'sed' Command in Operating System - HP-UX

Replace a Blank Char to ~ (tilde) Using 'sed' Command

Dewa Negara_4 — Thu, 17 Sep 2009 10:09:59 GMT

Hi All,

I have an output below:
bdhp4126.na.pg.com ~17 Sep 2009~06:45:01~W~FILE

I want to add tilde (~) between date and month (char 29), and between month and year (char 33). So the output will be like below:
bdhp4126.na.pg.com ~17~Sep~2009~06:45:01~W~FILE

How can we do that using sed command? Please help. Thanks in advance.

Regards,

Re: Replace a Blank Char to ~ (tilde) Using 'sed' Command

Hein van den Heuvel — Thu, 17 Sep 2009 10:19:12 GMT

Just a regular expression...

Using perl:

$ cat x
bdhp4126.na.pg.com ~17 Sep 2009~06:45:01~W~FILE
$
$ perl -pe "s/(\d+) (\w+) (\d+)/\1~\2~\3/" x
bdhp4126.na.pg.com ~17~Sep~2009~06:45:01~W~FILE

So that looks for some numbers followed by a space stored in $1 (day)
followed by a word stored in $2 (month)
followed by a space and more numbers in $3 for the year.
Re-assemble with the tildes.

Hein.

Re: Replace a Blank Char to ~ (tilde) Using 'sed' Command

Suraj K Sankari — Thu, 17 Sep 2009 10:37:15 GMT

Hi,
awk '{ print $1" "$2"~"$3"~"$4 } outputfile

OR

awk '{
a=substr($0,1,22)
b=substr($0,24,3)
c=substr($0,28,20)
print a~b~c
}'outputfile

or

awk '{
print substr($0,1,22)"~"substr($0,24,3)"~"substr($0,28,20)
}'outputfile

Suraj

Re: Replace a Blank Char to ~ (tilde) Using 'sed' Command

Suraj K Sankari — Thu, 17 Sep 2009 10:44:09 GMT

Hi,
awk '{ print $1" "$2"~"$3"~"$4 }' outputfile

Suraj

Re: Replace a Blank Char to ~ (tilde) Using 'sed' Command

James R. Ferguson — Thu, 17 Sep 2009 11:19:19 GMT

Hi:

Your requirement, based on the data presented, seems as simple as replacing blank characters with tildes. If that's truly the case, using 'sed' (as requested) this becomes:

# X="bdhp4126.na.pg.com ~17 Sep 2009~06:45:01~W~FILE"

# echo ${X}|sed -e 's/[ ]/~/g'

Regards!

...JRF...

Re: Replace a Blank Char to ~ (tilde) Using 'sed' Command

Dewa Negara_4 — Thu, 17 Sep 2009 12:46:21 GMT

Hi All,

Got it. Resolved the issue using perl command as advised above. Thanks alot to you all for the great help.

Best Regards,