AnsweredAssumed Answered

unknown characteres in a script to open document

Question asked by tcorbeil on Jul 20, 2015
Latest reply on Jul 25, 2015 by philmodjunk

Title

unknown characteres in a script to open document

Post

Hello,

I have a script that should open a file (picture) of a part in our database

Script is:

"filewin:/R:/Parts-FM12-Database/" & Left ( MTL PART# ; 2 )  &  "-"  &  CATEGORY & "/"  & MTL PART#  &   "/"  &  MTL PART# &  ".jpg"

My problem is that some parts folder and pictures where not name only with their part number some text was added also so the script doesn't work all the time

ex:

This work:

R: \ PARTS-FM12-Database \ 01-Electrical \ 0189244 \ 0189244.jpg 

This doesn't work:

R: \ PARTS-FM12-Database \ 03-Mechanical \ 0311264 Compressor HTC \ 0311264 Compressor.jpg 

 

What can I add to make a general search of the pictures having unknown character?

 

Thanks in advance

 

 

Outcomes