Jason Yousef
asked on
derived column to delete comma (,)
Hello,
I searched everywhere couldn't find out what the CHAR number for the comma.
I've this derived column query in SSIS to strip the commas from the full name.
REPLACE(Full_NAME_Column," , "," ")
John, Doe to John Doe
Please help
Thanks
I searched everywhere couldn't find out what the CHAR number for the comma.
I've this derived column query in SSIS to strip the commas from the full name.
REPLACE(Full_NAME_Column,"
John, Doe to John Doe
Please help
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
RiteshShah:
cheers and thanks for your reply
still doesn't work for me !
is my expression looks ok?
REPLACE(PAT_NAME_File1,"ch ar(44)"," ")
cheers and thanks for your reply
still doesn't work for me !
is my expression looks ok?
REPLACE(PAT_NAME_File1,"ch
declare @t varchar(10)
set @t='sqlhug,com'
select REPLACE(@t,char(44),' ')
set @t='sqlhug,com'
select REPLACE(@t,char(44),' ')
ASKER
Your example works, but in SSIS expression doesn't work, any clue?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This actually worked for me.... but thanks anyway for your help
REPLACE(PAT_NAME_File1, "," ,"" )
REPLACE(PAT_NAME_File1, "," ,"" )
ASKER
Thanks
http://www.sqlhub.com/2009/04/list-of-int-ascii-code-to-character-in.html