Using

#1

I'm using the function FINDSTRING in a derived column transformation in SSIS.
If I need to find the location of special characters like quotation marks,
how do I specify them to be searched within the string?
FINDSTRING([ColumnName], ???, 1)

Is there anything like a chr$() function I can use?

Thank you.

#2

The escape sequence \" should match a quotation mark in the string.

Other supported escape sequences are described on the Literals (SSIS)
page in Books Online.

Andrew Watt [MVP]

On Thu, 13 Apr 2006 19:39:02 -0700, Orlando
<Orlando (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I'm using the function FINDSTRING in a derived column transformation in SSIS.
If I need to find the location of special characters like quotation marks,
how do I specify them to be searched within the string?
FINDSTRING([ColumnName], ???, 1)

Is there anything like a chr$() function I can use?

Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Using - 04-13-2006 , 09:39 PM

Re: Using - 04-14-2006 , 03:26 AM