How to remove .extension from a System.IO.FileInfo file ?

  • Thread starter Thread starter gamesforums
  • Start date Start date
G

gamesforums

How can i remove the .sql extension from my script files?? I want to
read all scripts in directory into a hashtable, and use
Right(scriptFile.FullName, 3) as my key and full name as value:

'buildscript_001.sql
'buildscript_002.sql

'Want to have 001 as key and buildscript_001.sql as value.


Dim scriptDirectory As New IO.DirectoryInfo "C:\Applications
\MyApplicationMainline\SW\App\DatabaseScripts\BuildScripts\")

Dim scriptFileList As IO.FileInfo() =
scriptDirectory.GetFiles()
Dim scriptFile As IO.FileInfo
Dim scriptFileTable As New Hashtable

For Each scriptFile In scriptFileList
'Read scripts to Hash tbl..
scriptFileTable.Add(Right(scriptFile.FullName, 3),
scriptFile.FullName)
Next

Regards
Mcad
 
How can i remove the .sql extension from my script files?? I want to
read all scripts in directory into a hashtable, and use
Right(scriptFile.FullName, 3) as my key and full name as value:

'buildscript_001.sql
'buildscript_002.sql

'Want to have 001 as key and buildscript_001.sql as value.


Dim scriptDirectory As New IO.DirectoryInfo "C:\Applications
\MyApplicationMainline\SW\App\DatabaseScripts\BuildScripts\")

Dim scriptFileList As IO.FileInfo() =
scriptDirectory.GetFiles()
Dim scriptFile As IO.FileInfo
Dim scriptFileTable As New Hashtable

For Each scriptFile In scriptFileList
'Read scripts to Hash tbl..
scriptFileTable.Add(Right(scriptFile.FullName, 3),
scriptFile.FullName)
Next

Regards
Mcad
Click to expand...

Check here:
http://msdn2.microsoft.com/en-us/library/system.io.path_members.aspx

Particularly look at GetFileNameWithoutExtension :-)
 
Back
Top