Remove Slash from SQL Field for Image S’abonner
I am using the Itemcode field in our database to have a corresponding image displayed.
Unfortunately we have a number of items in itemcode that have a forward slash "/" in them and so windows OS does not like them eg BFF500/R3.
The Picture Properties does not include a transform tab to allow the substitution of the slash character is there some other way to do this ?
Ideally I would like to be able to either just remove the slash or substitute with another valid DOS character.
Changing the Itemcodes in the DB is not possible
5 commentaires

John Peters
Sorry an a noob to this
I have created a hidden text box behind the graphic which gets the field and performs the transform - is there a way to reference this in the graphic or some VB script I could run ?
Well somehow the transform box is now available for the graphic so no problems !
Now its not available - i'm not sure if its me or the program ?
The Picture doesn't have the Data Sources Option only the DB part in the Picture Source
This is what I want - with the additional data source properties
So the solution is to not use "Get from the database field" and use the " Get the filename from Data Source" you can then specify the Database field to retrieve and perform the transform on it.
Vous devez vous connecter pour laisser un commentaire.