AnsweredAssumed Answered

Script or calculation to verify status of container field.

Question asked by stevenkw on Nov 1, 2011
Latest reply on Nov 1, 2011 by stevenkw

Title

Script or calculation to verify status of container field.

Post

Hello All,

I have a database that displays images that are in a folder. The problem is if the file is missing or if the file is corrupt there is a text message in the container field explaining why the image can not be displayed.

Is there anyway to get this text message out of the container field and into a field I can search on?

The container says "The file cannot be displayed:" is the file is corrupt or damaged and " The file cannot be found:" if the file is missing.

I really need to be able to find all the "The file cannot be displayed:" and " The file cannot be found:" records so I know how many there are of each.

there are anywhere from 75k to 290k records and paging through them is not really an option. :)

 

Thank you,

--StevenKW

 

Screen_shot_2011-11-01_at_12.43.16_PM.jpg

Outcomes