CODEWITHSUNDEEP
sql-serverssis
user3352326
user3352326

Reputation: 27

SQL Server Stored Procedure -Non-numeric values caused by text fields being parsed out

How can I parse out non-numeric values using a stored procedure? I have a table that I replicate in an SSIS package. Unfortunately, when this table sends to the gpg output it includes values like:, |, \, .

Example - this is what the result set looks like for my Title column:

FLASH| BANG| POP| FIZZ|: E-OP 
YES, YOU CAN|||: POSITIVE -OP

and I need it to be:

FLASH BANG POP FIZZ
YES, YOU CAN POSITIVE -OP

Is there a way to remove these unwanted values using a stored procedure?

Thanks for your help!

Upvotes: 0

Views: 44

Answers (1)

SQLBadPanda
SQLBadPanda

Reputation: 635

You could use an UPDATE in a stored procedure using the REPLACE function but why not cleanse them in your SSIS using a Derived Column operator in your data flow?

Upvotes: 1

Related Questions