topic Re: find and replace for strings in shell scripts in Operating System - HP-UX

find and replace for strings in shell scripts

Prasad Govenkar — Tue, 29 Jun 2004 05:00:52 GMT

I have a file , and each line has values seperated by pipe"|".

Now I have to replace the string after the 3th Pipe, with another string.
How do I do the same in unix shell script?

Suposse the file has contents as below.[ 2 lines]

B100|ABCD|1234|AM20|TEST
B100|ABCDAM20|1234|AM20|TEST

Now I want to replace the AM20 with TPID after the 3rd Pipe, and not in any other place

if I use sed command like this..
echo $LINE | sed -e 's/AM20/TPID/' >>CPQFILE.tmp

it will also replace ABCDAM20 in the second line as ABCDTPID which I DONT want to happen..
PS: I am reading the file line by line and outputting in a temp file.

Re: find and replace for strings in shell scripts

Muthukumar_5 — Tue, 29 Jun 2004 05:08:46 GMT

Re: find and replace for strings in shell scripts

Simon Hargrave — Tue, 29 Jun 2004 05:12:17 GMT

Try this: -

echo $LINE | awk -F\| 'BEGIN{OFS="|"}$4=="AM20"{$4="TPID"}{print $0}'

Re: find and replace for strings in shell scripts

Muthukumar_5 — Tue, 29 Jun 2004 05:12:43 GMT

Hai,

We can do the above with tr command too.
Use the command setup as like,

echo $LINE | tr -c '|AM20|' '|TPID|'

It will work too.

Regards,
Muthukumar.

Re: find and replace for strings in shell scripts

Thierry Poels_1 — Tue, 29 Jun 2004 05:13:46 GMT

hi,

with vi:
%s/$^.*|.*|.*|$AM20$|.*$/\1TPID\2

with ed:
,s/$^.*|.*|.*|$AM20$|.*$/\1XXX\2

good luck,
Thierry.

Re: find and replace for strings in shell scripts

Ionut Grigorescu_2 — Tue, 29 Jun 2004 19:12:40 GMT

Hi,

what about using awk?

awk -F\| '{$4="your_string";print}' your_file

Re: find and replace for strings in shell scripts

Allan Prentice — Tue, 29 Jun 2004 21:16:20 GMT

Try this, which doesn't care about the field contents:

sed -e 's/^$[^|]*|[^|]*|[^|]*|$$[^|]*$$.*$$/\1NEWSTUFF\3/' < oldfile > newfile

Re: find and replace for strings in shell scripts

Allan Prentice — Tue, 29 Jun 2004 21:23:30 GMT

Or if you use Ionut's prettier awk script, you need to add the output field separator:

awk -F\| '{OFS="|";$4="your_string";print}' your_file

Re: find and replace for strings in shell scripts

Rory R Hammond — Wed, 30 Jun 2004 10:28:55 GMT

Re: find and replace for strings in shell scripts

Fred Ruffet — Wed, 30 Jun 2004 10:53:15 GMT

nobody to promote perl ? here it is :
$>cat file
B100|ABCD|1234|AM20|TEST
B100|ABCDAM20|1234|AM20|TEST
$>cat run
#!/opt/perl/bin/perl
while () {
($one,$two,$three,$four,$five)=split /\|/,$_;
$four=~ s/^AM20$/TPID/g;
print join '|', $one,$two,$three,$four,$five;
}
$>./run < file
B100|ABCD|1234|TPID|TEST
B100|ABCDAM20|1234|TPID|TEST

regards,

Fred