SSIS Findstring for "

Olsson Arne 81 Reputation points
2021-03-24T13:47:49.767+00:00

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 26,376 Reputation points
    2021-03-24T14:19:21.507+00:00

    Hi @Olsson Arne ,

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

    Please try the following method:

    • "\""

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.