question

OlssonArne-8894 avatar image
0 Votes"
OlssonArne-8894 asked OlssonArne-8894 commented

SSIS Findstring for "

Hi!
Findstring works when use findstring to search for blank space and normal letters but i cant make it work when have to use Findstring to find the character " For example Findstring(columnname,""",1) doesnt work how could i fix the syntax to make it work?
Br Arne

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered OlssonArne-8894 commented

Hi @OlssonArne-8894,

SSIS is using backslash "\" as the escape character.

Please try the following method:

  • "\""

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks that works excellent.
Br Arne

0 Votes 0 ·