How to create FileName or Folder name with space ?

[Golden Jing]

Dear all, I have issue when i creat folder/condition with other foldername with space. In code bellow is i create foldername that with space Declare @ComMkDir varchar(100) (eg. C:\ComName\Test Folder Set @ComMkDir = 'mkDir ' + @ComComp EXEC master.dbo.xp_cmdshell @ComMkDir After create is just create "Test" folder. Thanks for your help...

VB.Net

[Andy_L_J]

This gets the result you want, change to suit:

DECLARE @ComMkDir varchar(100)
DECLARE @mkDir varchar(50) = 'C:\ComName\Test'
DECLARE @ComComp varchar(50) = 'Folder'

SET @ComMkDir = @mkDir + ' ' + @ComComp

Print @ComMkDir

RESULT:

C:\ComName\Test Folder

I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife

modified on Friday, December 25, 2009 9:46 PM

[Golden Jing]

ohh maybe you don't undestand what i posted. I want to create folder not just print. you can test it. It is not acept with space.

VB.Net

[Tim Carmichael]

Put double quotes around the directory and file name. Eg: "c:\Temp Folder\Temporary File.txt" Tim

[Md Marufuzzaman]

Try the following hope that may helped you...

--EXEC spCreateF0lder 'C:\ComName\Test\' ,'Test Folder 1'
CREATE PROCEDURE spCreateF0lder
@DefaultPath varchar(MAX)
,@FolderName VARCHAR(100)
AS
BEGIN

DECLARE @SqlScript VARCHAR (MAX)

SET @SqlScript = 'EXEC master.dbo.xp_cmdshell ''' + ' mkDir ' + @DefaultPath + @FolderName + ''''

EXEC @SqlScript
Print @SqlScript

END
GO

Thanks Md. Marufuzzaman

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

modified on Saturday, December 26, 2009 8:35 AM

[Golden Jing]

Thanks you so much it work well...

VB.Net

[Md Marufuzzaman]

I'm facing the following error: Output SqlScript: EXEC master.dbo.xp_cmdshell 'mkDir "C:\ComName\Test\Test Folder 1"' -- It works fine But when I try like EXEC @SqlScript ,it raise the following error. Msg 203, Level 16, State 2, Procedure spCreateF0lder, Line 19 The name 'EXEC master.dbo.xp_cmdshell 'mkDir "C:\ComName\Test\Test Folder 1"'' is not a valid identifier.

Thanks Md. Marufuzzaman

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.