Good afternoon PSM experts!

A little background on what we're doing. We're using a API to pull Street View images from Google, then merging these images with the data list in PSM.

The issue I'm running into is each image is uniquely named and the only way I've been about to trigger the correct image is with the code below.

IF([SORTPOSITION]="1" AND FILE_EXISTS("C:\Users\Desktop\Images\2_Print\1.jpg"), "C:\Users\Desktop\Images\2_Print\1.jpg","C:\Users\Desktop\Images\Generic.jpg")

I have to write a line of code like this for every single image and corresponding record number. So [SORTPOSITION] could range from 1 to 10,000 and the image could range from 1 to 10,000".jpg"

Is there anyway I can use a "wild card" to match the record with the correct image instead of forcing the match like I am above?

Have you tried this?:

I have not, I will give that a try.

What is &[SORTPOSITION]& looking for? Is it searching for the value of "1" from the beginning of the line of code?

Well I thought that [SORTPOSITION] could be relied on for the name of the file...but if you want to use the record number, use this instead:



RECORD_NR() will return the current record number.
STR() will convert RECORD_NR() to a string.

and the "&" is used to concatenate 2 strings.

I apologize for the confusion, yes [SORTPOSITION] can be relied on for the name of the file.

Will I need to have a string of code for every value of [SORTPOSITION]? Like the example below.


IF([SORTPOSITION]="1" AND FILE_EXISTS("C:\Users\Desktop\Images\2_Print\"&[SORTPOSITION]&".jpg"),"C:\Users\Desktop\Images\2_Print\"&[SORTPOSITION]&".jpg",
IF([SORTPOSITION]="2" AND FILE_EXISTS("C:\Users\Desktop\Images\2_Print\"&[SORTPOSITION]&".jpg"),"C:\Users\Desktop\Images\2_Print\"&[SORTPOSITION]&".jpg",
IF([SORTPOSITION]="3" AND FILE_EXISTS("C:\Users\Desktop\Images\2_Print\"&[SORTPOSITION]&".jpg"), "C:\Users\Desktop\Images\2_Print\"&[SORTPOSITION]&".jpg","C:\Users\Desktop\Images\Generic.jpg")))

Now if [SORTPOSITION] can be relied on for the name of the file, then you should only need 1 string of code:

This worked, you just saved me so much time!
Thank you! Next time I'm in Québec I own you a beer!