sudhirnune (8/24/2012)
Hi All,We are using FINDSTRING Function in one of Data flow Derived Column (Component), It work Fine for Symbols like '&','%' and ' (Single Quote)
Where as we need to implement it for " (Double Quote) and \ (Slash).
FINDSTRING ("STRING&32","&") != 0 Works
FINDSTRING ("STRING&32","\") != 0 Not Working Working (Its shows Syntax Error)
FINDSTRING ("STRING&32","\\") != 0 Not Working Working (Syntax works, but Actual Functionality Does not)
FINDSTRING ("STRING&32","\"") != 0 Not Working Working (Syntax works, but Actual Functionality Does not)
Please need help.
Hi sudhirnune
Based on the sample code provide, it seems your target string STRING&32 does not contains the text you are trying to find.
FINDSTRING ("STRING&32","&") returns 7 because the '&' is at position 7
FINDSTRING ("STRING&32","\") fails with an error becase the \ is escaping the closing ".
FINDSTRING ("STRING&32","\\") returns zero because there is not back slash in the target text STRING&32; you should try with a testing string containing a back slash.
FINDSTRING ("STRING&32","\"") returns zero because the target text STRING&32 does not contain a double quote, you should try with a test string containing double quotes.
Cheers,
Hope this helps,
Rock from VbCity