Substracting strings?

[Leb i Sol]

Hello people!

I was just wondering if this approach is even possible.

All of the image paths in field are constant:

-----------fields---------------

ItemID: xxxxx

ImageName:xxxxx.jpg

Image_Path: M/xxxxx.jpg"]file://X:/images/M/xxxxx.jpg

--------------------------------

how to set field to the same string but altered?

c_Large_Image_Path: L/xxxxx.jpg"]file://X:/images/L/xxxxx.jpg

My inital though was to :

c_root= TrimRight((Image_Path - ImageName),3)

to produce a "root" value:

file://X:/images/

and then

c_final= (c_root & "M/" & ImageName)

but the problem is "subtracting text strings"

Anyone has ideas?

Much Obliged!

[fishma]

SetField["c_Large_Image_Path", "Substitute ( Image_Path:, "file://X:/images/M/", "file://X:/images/L/")"]

[Leb i Sol]

Hi Fishma!

Thanx for the post...I am sorry, the sample above just that....the actual path varies and is not constant.

the "true" path is:

file://X:/images/LocationName/M/

where I have a few locations and are diff.

But, I managed to get it to work.

The idea here was to "open/View" larger image:

- without ever storing it in DB

- having it in the same root folder but only the "last folder" would differ.

- images are named the same

Here is how it worked out: attached image

[fishma]

Excellent...I'm glad you got it to work.

[Leb i Sol]

Hi Fishma!

Thanx for the pointer!

Your way is much easier & quicker in "static" paths... nice move with SetFild!

Many thanx to Lee who also pitched in with this post!