Guaranteed stumper...truncating last 3 characters on a string...
-
Hi, guys. I have a string that represents a path to a file. However, the file is the wrong type and needs to be converted to a different file type. I need the file to be a .CSV file instead of a .XLS file type. If I had a string representing the entire path to the file, including the .XLS, how would I truncate the .XLS and replace it with .CSV? :confused::confused::confused: -- modified at 14:19 Friday 9th November, 2007
-
Hi, guys. I have a string that represents a path to a file. However, the file is the wrong type and needs to be converted to a different file type. I need the file to be a .CSV file instead of a .XLS file type. If I had a string representing the entire path to the file, including the .XLS, how would I truncate the .XLS and replace it with .CSV? :confused::confused::confused: -- modified at 14:19 Friday 9th November, 2007
select reverse(substring(reverse('C://hello/world.txt'), 5, 100)) -
select reverse(substring(reverse('C://hello/world.txt'), 5, 100))So - not stumped by the guaranteed stumper then.;)
Deja View - the feeling that you've seen this post before.