"contains" means theres more data than the quoted phrases? or could we say "equals"?
If we can use "equals" we can have this expression:
If ( SingleOrSharedPhoto = "has own photo" ;
Left ( Auto Photo Path ; Length ( Auto Photo Path ) - 4 ) & ".tif" ;
Left ( Photo Sharing ID ; Length ( Photo Sharing ID ) - 4 ) & ".tif" )
if we are dealing with "contains" we can change the first term to:
If ( PatternCount ( SingleOrSharedPhoto ; "has own photo" ) ;
You're right, "equals" is what I want. Regarding the ".tif"...the file names will include a .jpg extension. Will your formula above replace those?
Also, forgive my "green-ness" but, would I paste your formula above just as you've typed it, indented at the left?
You can paste it if I have the field names correct and all fields are defined in the same table as your calculation field.
The expression I used strips off the last 4 letters and replaces it with ".tif". This assumes that all data in the two fields comes with a 4 character file extension.
Awesome, worked perfectly the first try! ...I appreciate your help!