Search

[SSIS] TOKENCOUNT(string, delimiter) or OCCURRENCES(string, delimiter) by Todd McDermid

Closed
as Fixed Help for as Fixed

3
0
Sign in
 to vote
Type: Suggestion
ID: 635968
Opened: 1/13/2011 11:27:38 AM
Access Restriction: Public
0
Workaround(s)
Related to #543945: https://connect.microsoft.com/SQLServer/feedback/details/543945

Adding an expression function that permits the counting of occurrences of a specific character or set of characters within a string would assist in string deconstruction efforts. FINDSTRING can currently fill some of the need for this, but only if the expected number of delimiters is known ahead of time.
Details (expand)
Product Language
English

Category

Integration Services (DTS)

Proposed Solution

TOKENCOUNT("01/12/2011", "/") or OCCURRENCES("01/12/2011", "/") would return 2.
TOKENCOUNT("01/12/2011", "-") or OCCURRENCES("01/12/2011", "-") would return 0.

Benefits

Faster Development

Other Benefits

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.
© 2012 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement