Forums
This topic is locked
stip ext before database save
Posted 17 Feb 2003 13:47:45
1
has voted
17 Feb 2003 13:47:45 Rick Touchstone posted:
How do I strip the ext on the file name before it saves to the database?Replies
Replied 17 Feb 2003 16:52:12
17 Feb 2003 16:52:12 Dennis van Galen replied:
try using something like:
left(MyString,len(MyString)-4)
This will remove the last 4 characters from your MyString value, for instance if MyString holds "file.doc" then the .doc will be stripped out.
HTH
with regards,
Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services
Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5
Edited by - djvgalen on 17 Feb 2003 16:52:44
left(MyString,len(MyString)-4)
This will remove the last 4 characters from your MyString value, for instance if MyString holds "file.doc" then the .doc will be stripped out.
HTH
with regards,
Dennis van Galen
Webmaster KPN Telecom Holland
Financial & Information Services
Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5
Edited by - djvgalen on 17 Feb 2003 16:52:44