Hidden characters from Container info

[Witz]

hi.

I have two problems currently.

I have a text field called Filepath that is a calculation field that returns Text.

calculation is simply that Filepath = thumbImage (which is a container field)

If I insert a REFERENCE to a file into thumbImage manually, I get this sort of result

size:344,450

image:10093_CHG_m240_SaraAngels.jpg

imagemac:/Media Station/Applications/FileMaker Pro 9 Advanced/Web/10093_CHG_m240_SaraAngels.jpg

but if I import a folder of images, AS REFERENCES, I get this:

image:/Media Station/Applications/FileMaker Pro 9 Advanced/Web/10367_CAS_b179_Bonnet.jpg

so, I was used to the difference when I EMBEDDED the pictures, versus Referencing them, but I did not expect a difference when I did a bulk import with references.

anyway that isn't much of a problem until the next calculation, which is to create an URL so that you can find use OpenUrl to open the images in a browser (the images are mirrored on a public webserver not connected to the dbServer)

so I take an url prefix, and concatenate with a imageFilename Field.

Filename calculation looks like this:

RightValues ( Substitute ( Image_FilePath ; "/" ; "¶" ) ; 1 )

which LOOKS like it gives me the proper extracted filename.

It displays, for example

10367_CAS_b179_Bonnet.jpg

but there is a second line of blank space, noticeable when you select all in the field.

furthermore. when I concatenate that name with the url prefix, and use the open url command, what shows up in the browsers URL is:

blahblahServer/10093_CHG_m240_SaraAngels.jpg%OD

so of course the url doesn't resolve properly.

I've tried wrapping the filename calculation in a LeftValues function, thinking there is a hidden paragraph return. I can't filter for a %OD, because I can't guarantee files won't have that in the filename. I've also done a Position function to get position of ".jpg" so that I can do a LEFT(filename; position+4,1) function on it, thinking I'd end up with the only the filename and proper extension, but I still get the "%OD" tacked on.

why is this happening? doesn anyone know?

My previous solution worked with manually inserted image references, because I didnt' rely on filename, rather, I used LeftValues 2 on the container, then took off the "image:" portion.

[IdealData]

Well I tested this one - I cannot concur.

Maybe your file names have got trailing spaces.

Resolve that first then maybe your URL calcs will work

[Witz]

Thanks.

I always solve these things right after I post in a forum.

The extracted filename had a Paragraph Return at the end. Once I Substituted that with "", it works fine.

HOWEVER,

Now all the images that have been bulk imported from a file, they don't retain their proportions in IWP. The only way I get proportions properly is by manually linking them. I think the problem might be that I first import the folder into a table that has fields that extract the inventory number from the filename, then I import them to the inventory table with the extracted the inventory number as the match field. It seems that these then are embedded, not linked. argh. I have to manually attach 10,000+ images???

I also just tried a matching relationship to the first image table, and they show up as distorted in IWP as well, so it seems you can't bulk import a folder of images and maintain proportions in IWP if they are referenced links.