PhilRowley
Technical User
I'm trying to create a power field for a colleague which will return the filename without the .lwp suffix.
I have tried two approaches :-
a)left(filename,position(filename,'.',1)-1)
b) left(filename,len(filename)-4)
In each case, I am getting error messages. The help file is no help whatever with the excat details.
I'd be grateful if anyone could tell me what I am doing wrong .
Phil
I have tried two approaches :-
a)left(filename,position(filename,'.',1)-1)
b) left(filename,len(filename)-4)
In each case, I am getting error messages. The help file is no help whatever with the excat details.
I'd be grateful if anyone could tell me what I am doing wrong .
Phil