Prepend and Append to a field 1

[mrimagepueblo]

Using /bin/sh shell script. I have to pull fields from a bigger file, no problem there, I'm just clueless on adding something to the beginning and the end of a field.

I have a pipe delimited file as such: I'll only use one line for the example: 12345 will always match, as I'm just duplicating whatever is in field 1 to the fourth field.

example:
12345|JF1SG65683H725202|data|12345|data|data|

What I want to be able to do is prepend and append two variables to the fourth field. It will always be

http://www.domain.com/images/

to the front and .jpg to the end.

end result:
12345|JF1SG65683H725202|data|

http://www.domain.com/images/12345.jpg|data|data|

Any help would be appreciated.

 

[Ygor]

Try..

awk 'BEGIN {
             FS = OFS = "|"
     }
     {
             $4 = "[URL unfurl="true"]http://www.domain.com/images/"[/URL] $4 ".jpg"
             print $0
     }
     ' file1 > file2

 

[mrimagepueblo]

That's what I was looking for.
Thank you!